Tags: attempting, class, database, evermind, java, loadjava, mysql, oracle, procedure, procedures, program, rmi, rmiinitialcontextfactory, run, server, sql, stored

loadjava and Java Stored Procedures

On Database » Oracle

6,698 words with 3 Comments; publish: Tue, 12 Feb 2008 00:43:00 GMT; (25078.13, « »)

Hi,

I am attempting to run a java stored procedure that uses the com.evermind.server.rmi.RMIInitialContextFactory class. When I run my program as a stored procedure it attempts to instantiate this class, and throws me the following error:

javax.naming.NoInitialContextException: Cannot instantiate class:

com.evermind.server.rmi.RMIInitialContextFactory [Root exception is

java.lang.ClassNotFoundException:

com/evermind/server/rmi/RMIInitialContextFactory]

I have determined that I need to load oc4jclient.jar into the database to take care of this dependency. I am using the loadjava utility to load the jar file. I am running the command like this:

call dbms_java.loadjava('-u user/pass.oracle.itags.org.130.54.9.189:1535:mysid -v -r -t C:\jdev1012\j2ee\home\oc4jclient.jar');

I am running this from Toad in a SQL editor window, but I don't think it is properly loading the jar file. Am I calling this correctly?

Thanks!

All Comments

Leave a comment...

  • 3 Comments
    • Are you sure you want to load an OC4J client jar into a database?

      Anyway, most likely your problem is this:

      >> C:\jdev1012\j2ee\home\oc4jclient.jar

      The JAR needs to be visible to the database, which means it needs to be on a directory on the database server. Furthermore the user running the loadjava script needs to be able to see that directory from the database. The easy way to acheive this is to run loadjava as SYS;

      otherwise you need to read up on java security permissions.

      Another thing you need to do is

      SET serveroutput ON SIZE 1000000
      exec dbms_java.set_output(2000)

      in order to see your verbose output. Not sure how that works in TOAD.

      Cheers, APC

      #1; Fri, 22 Feb 2008 21:44:00 GMT
    • All I am trying to do is to have a Java Stored Procedure that enqueues a JMS message to a JMS queue on a different server than the database server. That is why I am using the RMI class (to access the remote server's JNDI tree to lookup to JMS queue). Maybe you have a better idea about the best way to do this. I want to avoid using AQ (I want to just use the OC4J/J2EE JMS).

      On the remote machine I have a BPEL process waiting for the arrival of the JMS message.

      I talked to someone who said that I needed the oc4jclient.jar to include the proper classes I am missing. But if there is a way to code a Java Stored procedure that can successfully enqueue the message without me having to load additional classes to the database, that would be great.

      Thanks for your help

      #2; Fri, 22 Feb 2008 21:45:00 GMT
    • Hi,

      I got loadjava to work (see output below). However when I look at my database objects, I notice that there are now 246 invalid 'JAVA CLASS' database objects in the ALL_OBJECTS table. One of these rows has an OBJECT_NAME of '/c5b41e1_RMIInitialContextFact' which I believe is the RMI class I am intending to use. Does anyone have any idea why these objects might be invalid? Also I noticed that many of the 'VALID' objects don't have the garbage string (i.e. c5b41e1) in the OBJECT_NAME. What does this encoding represent?

      Thanks!

      SQL*Plus: Release 8.0.6.0.0 - Production on Fri May 20 13:22:27 2005 (c) Copyright 1999 Oracle Corporation. All rights reserved.  Connected to:Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.4.0 - Production  PL/SQL procedure successfully completed. arguments: '-kprb''-u''user/pass.oracle.itags.org.131.52.8.188:1535:mysid''-v''-r''-t''/home/hollinsg/oc4jclient.jar'creating : resource META-INF/MANIFEST.MFcreating : class com/evermind/bytecode/Attributecreating : class com/evermind/bytecode/BasicAttributecreating : class com/evermind/bytecode/ClassDatacreating : class com/evermind/bytecode/ClassFormatExceptioncreating : class com/evermind/bytecode/ClassPoolEntrycreating : class com/evermind/bytecode/ClassSerializationcreating : class com/evermind/bytecode/CodeAttributecreating : class com/evermind/bytecode/CodeOutputStreamcreating : class com/evermind/bytecode/ConstructorCodeAttributecreating : class com/evermind/bytecode/ConstructorMethodDatacreating : class com/evermind/bytecode/DoublePoolEntrycreating : class com/evermind/bytecode/ExceptionRegioncreating : class com/evermind/bytecode/FieldDatacreating : class com/evermind/bytecode/FieldPoolEntrycreating : class com/evermind/bytecode/FloatPoolEntrycreating : class com/evermind/bytecode/IntegerPoolEntrycreating : class com/evermind/bytecode/InterfaceMethodPoolEntrycreating : class com/evermind/bytecode/LinkedClassDatacreating : class com/evermind/bytecode/LinkedMethodDatacreating : class com/evermind/bytecode/LongPoolEntrycreating : class com/evermind/bytecode/MethodDatacreating : class com/evermind/bytecode/MethodPoolEntrycreating : class com/evermind/bytecode/NameAndTypePoolEntrycreating : class com/evermind/bytecode/PoolEntrycreating : class com/evermind/bytecode/ProxyCodeAttributecreating : class com/evermind/bytecode/ProxyInitializationCodeAttributecreating : class com/evermind/bytecode/ProxyMethodDatacreating : class com/evermind/bytecode/StringPoolEntrycreating : class com/evermind/bytecode/UTF8PoolEntrycreating : class com/evermind/client/assembler/Assemblercreating : class com/evermind/compiler/Compilable PL/SQL procedure successfully completed.
      #3; Fri, 22 Feb 2008 21:46:00 GMT