# 22. Virtuoso Functions Guide - unimport_jar

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
import_jar
internal_to_sql_type
internal_type
internal_type_name
isarray
isbinary
isblob
isdouble
isentity
isfloat
isinteger
isnull
isnumeric
isstring
iszero
jvm_ref_import
make_string
sign
stringdate
stringtime
udt_defines_field
udt_get
udt_implements_metho...
udt_instance_of
udt_set
unimport_jar
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## unimport_jar

Drops SQL wrapper types of selected Java classes
void unimport_jar (in files any, in classes any);
Description

This function calls the jvm_ref_import() function to produce the XML, then transforms it to a set of DROP TYPE statements and executes them.

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.
Examples

    SQL> import_jar (null, vector ('java.lang.System'));

    Done. -- 126 msec.
    SQL> select java_lang_System::getProperty('java.vm.name');
    callret
    NVARCHAR
    _______________________________________________________________________________

    Java HotSpot(TM) Client VM
    SQL> unimport_jar (null, vector ('java.lang.System'));

    Done. -- 54 msec.
    SQL> select java_lang_System::getProperty('java.vm.name');

    *** Error 37000: [Virtuoso Driver][Virtuoso Server]UD041: No user defined type DB.DBA.java_lang_System
    at line 8 of Top-Level:
    select java_lang_System::getProperty('java.vm.name')

See Also

import_jar()

jvm_ref_import()