2 Replies Latest reply: May 13, 2011 8:23 AM by chrdei RSS

    Working with external Library -> NoSuchMethodError

    chrdei
      Hi!
      Slowly but steady myself is getting crazy. Since quite some time I try to get my java files working in a Oracle 11g database.

      What I've done up to now:
      1. Loaded Library with loadjava -> loadjava -user SCOTT/TIGER -resolve -resolver "((* SCOTT)(* PUBLIC))" -force -recursivejars MyJar.jar The import completes without any error.
      2. I created a Wrapper class in Java and a wrapper procedure in PL/SQL
      3. Now I call the PL/SQL procedure to execute the java code, but...

      ORA-29532: Java call terminated by uncaught Java exception: java.lang.NoSuchMethodError
      ORA-06512: at "SCOTT.PAC_JAVA_WRAPPER", line 284
      ORA-06512: at line 1
      29532. 00000 - "Java call terminated by uncaught Java exception: %s"
      *Cause:    A Java exception or error was signaled and could not be
      resolved by the Java code.
      *Action:   Modify Java code, if this behavior is not intended.
      Exception in thread "Root Thread" java.lang.NoSuchMethodError
           at MyJavaWrapper(WRAPPER:7)

      This is the error message when I try to execute the java. In line 7 of the Wrapper Class is the first call of a function in the Library.
      Where is the problem? Outside of the database everything is working fine (JVM 1.5) but in the database it don't works.

      Please help me.