Once you have compiled the Java code, you use the loadjava program to load the classes or JAR archive files into the database. The syntax you use to invoke loadjava is:

loadjava -user user_name/password[@URL] [option_list] file_list

where user_name and password indicate the schema that will be used to load the classes, and URL is a database URL (described in more detail for the SQLJ connect function in the “SQLJ Methods” section later in this chapter). The file_list is a list of files to be loaded, and the option_list is one or more of the parameters listed here:


Performs all actions. The default. New with Oracle9i.


Compiles the uploaded source files and resolves each as it is loaded. Mutually exclusive with -resolve.


Publishing creates case-sensitive names. New with Oracle9i.


Clears out any existing grants to classes, sources, and resources. Used with -grants to reset grant levels.


Generates and displays debugging information as load progresses.

-definer | d

Specifies that methods of classes being loaded be executed with the privileges of the definer, not the invoker.

-dirprefix prefix

Deletes prefix from the name before the name of the schema object is determined. New with Oracle9i.

-encoding | e

Specifies character set encoding for source files.

-fileout file

Prints all messages to file. New with Oracle9i.

-force | f

Forces loading of previously loaded Java class files.


Causes the generation of dummy ...

Get Oracle in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.