<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="Function: import_jar - Virtuoso Functions Guide" />
<meta name="dc.subject" content="Function: import_jar - Virtuoso Functions Guide" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="functions.html" title="Chapter Contents" />
<link rel="prev" href="appendixa.html" title="Appendix" />
<link rel="next" href="functions.html#.html" title="" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>Function: import_jar - Virtuoso Functions Guide</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="fn_import_jar" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>22. Virtuoso Functions Guide - import_jar</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="functions.html#txn" title="Transaction">Prev</a> | <a class="link" href="fn_internal_to_sql_type.html" title="internal_to_sql_type">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div>
<a class="selected" href="functions.html">Virtuoso Functions Guide</a>
</div>
<br />
<div>
<a href="functions.html#admin">Administration</a>
</div>
<div>
<a href="functions.html#aggr">Aggregate Functions</a>
</div>
<div>
<a href="functions.html#array">Array Manipulation</a>
</div>
<div>
<a href="functions.html#bpel">BPEL APIs</a>
</div>
<div>
<a href="functions.html#backup">Backup</a>
</div>
<div>
<a href="functions.html#compression">Compression</a>
</div>
<div>
<a href="functions.html#cursors">Cursor</a>
</div>
<div>
<a href="functions.html#time">Date & Time Manipulation</a>
</div>
<div>
<a href="functions.html#debug">Debug</a>
</div>
<div>
<a href="functions.html#dict">Dictionary Manipulation</a>
</div>
<div>
<a href="functions.html#encoding">Encoding & Decoding</a>
</div>
<div>
<a href="functions.html#file">File Manipulation</a>
</div>
<div>
<a href="functions.html#ft">Free Text</a>
</div>
<div>
<a href="functions.html#hash">Hashing / Cryptographic</a>
</div>
<div>
<a href="functions.html#ldap">LDAP</a>
</div>
<div>
<a href="functions.html#localization">Locale</a>
</div>
<div>
<a href="functions.html#mail">Mail</a>
</div>
<div>
<a href="functions.html#misc">Miscellaneous</a>
</div>
<div>
<a href="functions.html#number">Number</a>
</div>
<div>
<a href="functions.html#phrz">Phrases</a>
</div>
<div>
<a href="functions.html#rdf">RDF data</a>
</div>
<div>
<a href="functions.html#rmt">Remote SQL Data Source</a>
</div>
<div>
<a href="functions.html#repl">Replication</a>
</div>
<div>
<a href="functions.html#soap">SOAP</a>
</div>
<div>
<a href="functions.html#sql">SQL</a>
</div>
<div>
<a href="functions.html#string">String</a>
</div>
<div>
<a href="functions.html#txn">Transaction</a>
</div>
<div>
<a class="selected" href="functions.html#type">Type Mapping</a>
</div>
<div class="selected">
<div>
<a class="selected" href="fn_import_jar.html">import_jar</a>
</div>
<div>
<a href="fn_internal_to_sql_type.html">internal_to_sql_type</a>
</div>
<div>
<a href="fn_internal_type.html">internal_type</a>
</div>
<div>
<a href="fn_internal_type_name.html">internal_type_name</a>
</div>
<div>
<a href="fn_isarray.html">isarray</a>
</div>
<div>
<a href="fn_isbinary.html">isbinary</a>
</div>
<div>
<a href="fn_isblob.html">isblob</a>
</div>
<div>
<a href="fn_isdouble.html">isdouble</a>
</div>
<div>
<a href="fn_isentity.html">isentity</a>
</div>
<div>
<a href="fn_isfinitenumeric.html">isfinitenumeric</a>
</div>
<div>
<a href="fn_isfloat.html">isfloat</a>
</div>
<div>
<a href="fn_isinteger.html">isinteger</a>
</div>
<div>
<a href="fn_isnull.html">isnull</a>
</div>
<div>
<a href="fn_isnumeric.html">isnumeric</a>
</div>
<div>
<a href="fn_isstring.html">isstring</a>
</div>
<div>
<a href="fn_iszero.html">iszero</a>
</div>
<div>
<a href="fn_jvm_ref_import.html">jvm_ref_import</a>
</div>
<div>
<a href="fn_make_string.html">make_string</a>
</div>
<div>
<a href="fn_sign.html">sign</a>
</div>
<div>
<a href="fn_stringdate.html">stringdate</a>
</div>
<div>
<a href="fn_stringtime.html">stringtime</a>
</div>
<div>
<a href="fn_udt_defines_field.html">udt_defines_field</a>
</div>
<div>
<a href="fn_udt_get.html">udt_get</a>
</div>
<div>
<a href="fn_udt_implements_method.html">udt_implements_metho...</a>
</div>
<div>
<a href="fn_udt_instance_of.html">udt_instance_of</a>
</div>
<div>
<a href="fn_udt_set.html">udt_set</a>
</div>
<div>
<a href="fn_unimport_jar.html">unimport_jar</a>
</div>
</div>
<div>
<a href="functions.html#uddi">UDDI</a>
</div>
<div>
<a href="functions.html#udt">User Defined Types & The CLR</a>
</div>
<div>
<a href="functions.html#vad">VAD</a>
</div>
<div>
<a href="functions.html#jvmpl">Virtuoso Java PL API</a>
</div>
<div>
<a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a>
</div>
<div>
<a href="functions.html#ws">Web & Internet</a>
</div>
<div>
<a href="functions.html#xml">XML</a>
</div>
<div>
<a href="functions.html#XPATH">XPATH & XQUERY</a>
</div>
<br />
<div>
<a href="functionidx.html">Functions Index</a>
</div>
<br />
</div>
<div id="text">
<h2>import_jar</h2>
<div class="refpurpose">Creates SQL wrapper types of selected Java classes</div>
<div class="funcsynopsis">
<span class="funcdef">void <span class="function">import_jar</span>
</span>
(<span class="paramdef">in <span class="parameter">files</span> any</span>,
<span class="paramdef">in <span class="parameter">classes</span> any</span>,
<span class="paramdefoptional">[in <span class="optional">security_mode</span> integer]</span>);
</div>
<div class="refsect1">
<div class="refsect1title">Description</div>
<p>This function calls the <span class="computeroutput">jvm_ref_import()</span> function
to produce the XML, then transforms it to a set of CREATE TYPE statements
and executes them. The SQL names of the types are generated by retrieving
the fully qualified name of the Java class and substituting the . with _
(e.g.: java.lang.System becomes java_lang_System). The names of the static
members observer functions are composed by prepending the name of the
static member with 'get' so the static Java member stat_m is mapped to a
SQL static method getstat_m(). As a result it creates SQL type wrappers
for the specified Java classes.</p>
</div>
<div class="refsect1">
<div class="refsect1title">Parameters</div>
<div class="refsect2">
<span class="refsect2title">files – </span>
Null, string or vector of strings. This can contain one or many
Java .class files, .zip or .jar files to pick classes from. Null means
only the classes specified in the classes argument regardless of their
physical location.
</div>
<div class="refsect2">
<span class="refsect2title">classes – </span>
Wildcard string or a vector of strings specifying which classes to
describe in the resulting XML.
</div>
<div class="refsect2">
<span class="refsect2title">security_mode – </span>
This optional parameter defines the access mode as follows:
<ul>
<li>
<strong>0</strong> - restricted (default if unspecified)</li>
<li>
<strong>1</strong> - unrestricted</li>
</ul>
</div>
</div>
<div class="refsect1">
<div class="refsect1title">Examples</div>
<a name="ex_import_jar" />
<div class="example">
<div class="exampletitle" />
<p />
<div>
<pre class="screen">
SQL> import_jar (null, vector ('java.lang.System'));
SQL> select java_lang_System::getProperty('java.vm.name');
callret
NVARCHAR
_______________________________________________________________________________
Java HotSpot(TM) Client VM
</pre>
</div>
</div>
</div>
<div class="refsect1">
<div class="refsect1title">See Also</div>
<p>
<a href="fn_unimport_jar.html">unimport_jar()</a>
</p>
<p>
<a href="fn_jvm_ref_import.html">jvm_ref_import()</a>
</p>
</div>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
343
