Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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).
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 - 04:02:00 CDT