Name

import_jar — Creates SQL wrapper types of selected Java classes

Synopsis

void import_jar ( in files any ,
  in classes any ,
  in security_mode integer );
 

Description

This function calls the jvm_ref_import() 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.

Parameters

files

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.

classes

Wildcard string or a vector of strings specifying which classes to describe in the resulting XML.

security_mode

This optional parameter defines the access mode as follows:

0 - restricted (default if unspecified)
1 - unrestricted

Examples

Example 24.187. Simple example

SQL> import_jar (null, vector ('java.lang.System'));
SQL> select java_lang_System::getProperty('java.vm.name');
callret
NVARCHAR
_______________________________________________________________________________

Java HotSpot(TM) Client VM