Home » Developer & Programmer » JDeveloper, Java & XML » ORA-29532: Java call terminated by uncaught Java exception: java.lang.AbstractMethodError (Oracle 11.0.2.4 with JVM installed)
ORA-29532: Java call terminated by uncaught Java exception: java.lang.AbstractMethodError [message #678846] Fri, 17 January 2020 06:22 Go to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Please help me to confirm this error on Oracle 11.2.0.4:

set serveroutput on;
call dbms_java.set_output(50);

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "CREATE_BLOB_TEST" AS

package createBlobTest;

import java.sql.*;
import oracle.jdbc.*;
import oracle.jdbc.pool.*;

class CreateBlobTest {

                public static  Blob test() throws Exception {
                                Connection connection;
                                OracleDataSource ds;
                                String connectUrl = "jdbc:default:connection:";

                                ds = new oracle.jdbc.pool.OracleDataSource();
                                ds.setURL(connectUrl);
                                connection = (OracleConnection) ds.getConnection();

                                DatabaseMetaData dbmd = connection.getMetaData();
                                System.out.println("Database Version: " + dbmd.getDatabaseProductVersion() );
                                System.out.println("Driver Version: " + dbmd.getDriverVersion() );

                                return  connection.createBlob();
                }
}
/

CREATE OR REPLACE FUNCTION createblobtest RETURN BLOB AS
    LANGUAGE JAVA
    NAME 'createBlobTest.CreateBlobTest.test() return java.sql.Blob' ;
/

BEGIN
    dbms_output.put_line (dbms_lob.getlength (createblobtest ()));
END;
/
My output:
Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
Driver Version: 11.2.0.3.0
Exception in thread "Root Thread" java.lang.AbstractMethodError
at createBlobTest.CreateBlobTest.test(CREATE_BLOB_TEST:22)
BEGIN
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.AbstractMethodError
ORA-06512: at "SYS.CREATEBLOBTEST", line 1
ORA-06512: at line 2
Re: ORA-29532: Java call terminated by uncaught Java exception: java.lang.AbstractMethodError [message #678847 is a reply to message #678846] Fri, 17 January 2020 07:10 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Output on Oracle 12.2.0.1:
Database Version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Driver Version: 12.2.0.1.0
0
I'm hoping that one would be able to fix/update the database's JDBC driver on 11.2.0.
Re: ORA-29532: Java call terminated by uncaught Java exception: java.lang.AbstractMethodError [message #678855 is a reply to message #678846] Fri, 17 January 2020 10:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In 11.2, with jvm 1.5, neither (embedded) java.sql.Connection nor oracle.jdbc.OracleConnection class implements the CreateBlob method (it is inherited from java.sql.Connection in 12c and was introduced in jvm 1.6) and, unfortunately, I think you cannot upgrade the database jvm.
I'm afraid there is nothing to do but upgrade Oracle itself.

Re: ORA-29532: Java call terminated by uncaught Java exception: java.lang.AbstractMethodError [message #679017 is a reply to message #678855] Tue, 28 January 2020 08:29 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Thank you Michel Smile
Up to now Oracle Support is unable (or unwilling) to just execute the code and confirm the problem on 11g.
Previous Topic: Extract XML data into columns
Next Topic: xml global element validation
Goto Forum:
  


Current Time: Thu Mar 28 08:19:07 CDT 2024