1 Reply Latest reply on Feb 28, 2014 12:07 PM by mcardia

    loadjava mysql jdbc - error

    mcardia

      Hi!

       

      I´m Trying to load the mysql connector into oracle database.

       

      I create a package to connect to mysql and all that is missing is the jdbc driver.

       

      So i executed loadjava, but i´m getting the error bellow. Can anyone help me?

      Oracle database 10g

       

      arguments: '-u' 'vendas/***@idev10g' '-v' '-resolve' '/ora10g/app/oracle/product/10.2.0/db_1/jlib/mysql-connector-java-5.1.12.jar' 
      dropped  : JAVA$CLASS$MD5$TABLE
      Exception in thread "main" java.lang.UnsatisfiedLinkError: getClassContext
              at com.ibm.jvm.classloader.ClassLoaderUtils.getLastClassLoader(ClassLoaderUtils.java:38)
              at java.security.Provider.loadProvider(Provider.java:209)
              at java.security.Security$2.run(Security.java:434)
              at java.security.AccessController.doPrivileged1(Native Method)
              at java.security.AccessController.doPrivileged(AccessController.java:351)
              at java.security.Security.getProviderAt(Security.java:431)
              at java.security.Security.getAlgClassName(Security.java:583)
              at java.security.Security.getAlgClassName(Security.java:637)
              at java.security.Security.getImpl(Security.java:1118)
              at java.security.MessageDigest.getInstance(MessageDigest.java:135)
              at oracle.aurora.server.tools.loadjava.SchemaObject.MD5OfStream(SchemaObject.java:730)
              at oracle.aurora.server.tools.loadjava.SchemaObject.getNewMD5(SchemaObject.java:418)
              at oracle.aurora.server.tools.loadjava.SchemaObject.doCreate(SchemaObject.java:174)
              at oracle.aurora.server.tools.loadjava.SchemaObject.process1(SchemaObject.java:215)
              at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:548)
              at oracle.aurora.server.tools.loadjava.LoadJava.addObject(LoadJava.java:529)
              at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:467)
              at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:396)
              at oracle.aurora.server.tools.loadjava.LoadJava.addJar(LoadJava.java:743)
              at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:448)
              at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:396)
              at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:365)
              at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:668)
              at oracle.aurora.server.tools.loadjava.LoadJava.processDeferredFiles(LoadJava.java:633)
              at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:834)
              at oracle.aurora.server.tools.loadjava.LoadJava.command(LoadJava.java:267)
              at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:164)
              at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:89)
      
        • 1. Re: loadjava mysql jdbc - error
          mcardia

          I solved it.

           

          I had to increase the java pool memory (first time i run the server complained about it) and then load the mysql jdbc driver executing in sqlplus:

           

          dbms_java.loadjava('path to jdbc driver file');

           

          When executing from console, the loadjava command require extra information (LD_LIBRARY_PATH etc) giving the error i mention above.

          Executing from sqlplus it is all set.