Loading Java & Drop Java utilities

Using the LoadJava and DropJava Utilities

LoadJava  is  a  utility  in which  Oracle  provides  to  automate  loading  Java  programs  into  the database. It is written in Java and uses the JDBC drivers to communicate with the database. LoadJava can take input that can be Java binaries (.class), Java source texts and Java archives. It does not load Java resources straightly, but you can archive (.jar) the Java resources and then load the JARs through the LoadJava utility.

A DropJava is a complimentary utility you can use to drop Java binaries and archives from the libunits.

When LoadJava is run, it performs the subsequent tasks:

1.    It creates a system-generated table, create$table, which can be used to load Java.
2.    The Java binaries and JARs are loaded into a BLOB column of this system-generated table.
3.    CREATE JAVA is invoked to load Java from the BLOB column into database libunits. The syntax for LoadJava is as given below:

LoadJava [-user connectstring] [options]

In the above syntax,

•    Connectstring is of the form username /  password@database and is used to specify the database schema to load Java into.
•    Options which could be specified involve the following:

-o    Use the JDBC/OCI driver
-t    Use the thin JDBC driver
-v    Use verbose mode to denotes the status of the load as it occurs.
-f    Force loading of classes by replacing existing classes. The default is to load only those which do not exist and those which have been modified.
-r    the resolver spec to use in during the load
-s    For the loaded classes create public synonyms.
-g    Grant permissions on loaded classes
-h    Obtain help on the syntax

The given code example loads a Java class which is named by Test.class into the schema SCOTT

In the specified server using thin JDBC drivers. A class is forced and status information is given as the loading proceeds.
LoadJava -user scott / tiger@myserver:5521:orcl -t -f -v Test.class