loadjava: Loading Java Sources/Classes/Jars into oracle Database

Loading the Java Sources/Classes into Database is important thing in Java based application software. Java sources (jar/Classes) can be loaded into database by using few methods, and using loadjava command is one of them.

loadjava:
This is OS based utility tool by Database. This command will be available in the OS. This can be run by Command Prompt (cmd) in Windows or Shell in UNIX/LINUX.

• Windows:
  1. goto the jar existing path in Command Prompt (cmd)
  2. loadjava -resolve -user scott/tiger@demo SQLJ.jar

  Issue the above command , If the error loadjava command not found is coming up then set environment variables like PATH, JAVA_HOME then issue loadjava command.

• UNIX/Linux
  1. Set parameters
     To execute the loadjava in server environment directly, it is better to set the following parameters.
     • $ export ORACLE_HOME=/scratch/oracle/app/oracle/product/11.2.0/dbhome_1
     • $ export PATH=$ORACLE_HOME/bin:$PATH:.
     • $ export ORACLE_SID=DEMO
  2. goto the jar existing path in Shell
  3. loadjava -resolve -user scott/tiger@demo SQLJ.jar

Errors:
ORA-29534: referenced object cannot be resolved
Cause: In case of loading multiple Jars
It might be because the internal sources of a Jar referring to another source in another jar.
So load all the jars at once to avoid the above error as follows

loadjava -resolve -user scott/tiger@demo *.jar

It will load all the jars existing in the folder/directory/path mentioned

Reference Links:
Refer the following links for detailed information of the tool
http://docs.oracle.com/cd/B28359_01/java.111/b31225/chtwo.htm
http://docs.oracle.com/cd/B28359_01/java.111/b31225/cheleven.htm#CACFHDJE