Re: Help - Java Stored Procedures Examples

Well, I got past the NoClassDefFoundError error. Turns out the "loadjava.bat" file doesn't have the correct directory set for SQLJ. If you go into NT explorer to [ORACLE_HOME]\Bin and right click on "loadjava.bat," you can edit the batch file and add the correct path. If your system is installed like mine, you can change the last path listed in the JRECLASSPATH variable to [ORACLE_HOME]\sqlj\LIB\translator.zip where ORACLE_HOME is the root oracle directory. (i.e. E:\Oracle\Ora81\sqlj\LIB\translator.zip).

This fixes the class problem and you can move on to the next bug, which for me was "ORA-00987: missing or invalid username(s)" even though I can log into SQLplus fine with travel/travel and have no other database instances running. I wonder when I'll be able to test the example.

More to come... I hope.

STAN Stan wrote in message <7jreen$9qj$1_at_ash.prod.itd.earthlink.net>...
>I'm trying to get the example Java Stored Procedures to load in Oracle 8i
>Enterprise for NT. The instructions on OTN say to type in the following
>line on the command line:
>
>loadjava -user travel/travel_at_hostname:port:SID -v -f -r -t hotel.java
>
>I'm getting the following error when I run that line:
>
>java.lang.NoClassDefFoundError: oracle/aurora/sqljdecl/SqljDecl
>
>I added a bunch of paths to CLASSPATH to make sure I was pointing to all of
>the JARS: ORACLEHOME\Lib, ORACLEHOME\jdbc\Lib, etc. I even opened the
>aurora jars/zips and couldn't find anything with sqlj in it. I pulled up
>Oracle Installer and it verifies that I have the SQLJ installed.
>
>Anybody got any ideas as to what's wrong?
>
>STAN
>
>P.S. If you have spaces in the paths listed in user variable CLASSPATH
>(i.e. C:\Program Files\...), you may get an error running 'loadjava.' I
>did. I was lucky enough to have that variable set to non-essential crap,
so
>I just set it to nothing. It doesn't seem to matter if there are spaces in
>system variable CLASSPATH. Go figure.
>
>
>
Received on Wed Jun 16 1999 - 03:18:17 CDT