loadjava woes, Oracle 8i

From: <dlevitt_at_bellatlantic.net>
Date: Tue, 12 Jun 2001 18:11:34 GMT
Message-ID: <3B265B53.40ECB196@bellatlantic.net>

I'm trying to test loading a Java stored proceedure into Oracle 8i [ Release 8.1.5.0.0 ]

It looks like there is some setup/enviornment issue that needs to be resolved. Has anyoune been able to get this working?

The loadjava utility fails when loading a java source file by throwing an exception:

D:\clients\gtms\projects\playpen>loadjava -v -schema GTMS -user gtms/gtms HelloSQLWorld.java
internal error: unanticipated exception: java.lang.NoClassDefFoundError: oracle/aurora/sqljdecl/SqljDecl
java.lang.NoClassDefFoundError: oracle/aurora/sqljdecl/SqljDecl

        at
oracle.aurora.server.tools.SourceFileReader.getScanner(SourceFileReader.java:52)

        at
oracle.aurora.server.tools.SourceFileReader.getFirstName(SourceFileReader.java:61)

        at
oracle.aurora.server.tools.LoadJava.processLoadAndCreate(LoadJava.java:1094)

        at
oracle.aurora.server.tools.LoadJava.process(LoadJava.java:1021)

        at
oracle.aurora.server.tools.LoadJavaMain.run(LoadJavaMain.java:193)

        at
oracle.aurora.server.tools.LoadJavaMain.main(LoadJavaMain.java:49) loadjava: 1 errors

But seems to work when loading a precompiled class:

D:\clients\gtms\projects\playpen>loadjava -v -schema GTMS -user gtms/gtms HelloS
QLWorld.class
initialization complete
loading : HelloSQLWorld
creating : HelloSQLWorld

The class shows as invalid:
SQL> @user_obj
A)ll or J)ava only?
Choice: j
Input truncated to 1 characters

Object Name                    Object Type   Status  Timestamp
------------------------------ ------------- ------- ----------------
HelloSQLWorld                  JAVA CLASS    INVALID 2001-06-11:13:47

PL/SQL procedure successfully completed.

Oh, yes - the class to be loaded:

public class HelloSQLWorld{

    public static String sayHello(){

        return "howdy";
    }
}

--

The Three Laws of Infernal Dynamics:

1. An object in motion will always be headed in the wrong direction.
2. An object at rest will always be in the wrong place.
3. The energy necessary to change either of these states is always more

than you wish to
expend, but never so much as to be totally impractical.
-- David Gerrold
Received on Tue Jun 12 2001 - 13:11:34 CDT