Stefano; I have had some luck loading classes using a custom Ant task. It is really just a wrapper for LoadJava but easier to use if you are Ant inclined. It looks like this: <patternset id="oracle.load.classes"> <include name="jbossall-client.jar"/> </patternset> <target name="LoadJBossToOracle"> <OracleLoadJava oci="on" user="SCOTT/[EMAIL PROTECTED]" resolve="on" debug="on" force="on" noverify="on" verbose="on" noserverside="on" schema="scott" synonym="on" time="on"> <fileset dir="C:/jboss-3.2.0_tomcat-4.1.24/client"> <patternset refid="oracle.load.classes"/> </fileset> <grant name="scott"/> </OracleLoadJava> </target>
The keys are the following: 1. Defer resolution until the second pass. (set resolve="on") 2. Recompile all classes when you are done. You can generate a script to do this as follows: select 'ALTER JAVA CLASS <USER NAME>."' || object_name || '" COMPILE;' from ALL_OBJECTS where object_type in ('JAVA CLASS', 'JAVA SOURCE') and OWNER = '<USER NAME>' Run the output as a SQL script. It will take quite a long time....... Anyways, email me off line and I'll send you the Ant tasks, examples and doc. //Nicholas --- Stefano Maestri <[EMAIL PROTECTED]> wrote: > We are trying to write a java Stored procedure for > oracle that call a session > bean. We are experiencing some troble because when > we set the InitialContext > we get an error because > org.jnp.interfaces.NamingContextFactory is not > present in Aurora. We tryied to load it (extracted > from jbossall-client.jar), > but Oracle failed to resolve that class. We tryied > also to load all > jbossall-client.jar with a lot of resolving error. > Ideas? Domeone had already did something like that. > We are using Jboss-3.2.1 > for the bean (and for the jabossall-client.jar) and > Oracle 9.2 on HP-UX for > the DB. > Thanks a lot for the attention. > > P.S.: We had not also javax.ejb in Aurora, but it > load correctly. > > -- > --------------- all work and no play makes Jack a > dull boy --------------- > bye Stefano > [EMAIL PROTECTED] > www.javalinux.it > MSN messanger: [EMAIL PROTECTED] > ICQ uin: 122192578 > Jabber: canezen > Yahoo MSN: canezen > #jedit IRC channel as <maeste> > > > ------------------------------------------------------- > This SF.net email is sponsored by: Etnus, makers of > TotalView, The best > thread debugger on the planet. Designed with thread > debugging features > you've never dreamed of, try TotalView 6 free at > www.etnus.com. > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ===== Nicholas Whitehead Home: (973) 377 9335 Cell: (201) 615 2716 [EMAIL PROTECTED] Get Your News From The Crowbar: http://crowbar.dnsalias.com:443/crowbar/ ------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The best thread debugger on the planet. Designed with thread debugging features you've never dreamed of, try TotalView 6 free at www.etnus.com. _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user