Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?

Question

I've got a problem with JDBC.

I'have the following code:

//blargeparam is a blob column.
PreparedStatement pst =connection.prepareStatement("update gcp_processparams_log set blargeparam= ? where idprocessparamslog=1");

pst.setBinaryStream(1,inputStream);

I get the following error:

Exception in thread "main" java.lang.AbstractMethodError:           
oracle.jdbc.driver.T2CPreparedStatement.setBinaryStream(ILjava/io/InputStream;)V

My connection string is jdbc:oracle:oci:@.....

The Oracle version is 11g.

From the error message it seems that something is missing but:

when I read from the same blob column (with blob.getBytes) everything works.
The DLL's of the instant client are (correctly) in the library path.

This is the manifest of the Oracle JDBC JAR in my class path:

Manifest-Version: 1.0  
Specification-Title:    Oracle JDBC driver classes for use with JDK14  
Sealed: true  
Created-By: 1.4.2_14 (Sun Microsystems Inc.)  
Implementation-Title:   ojdbc14.jar  
Specification-Vendor:   Oracle Corporation  
Specification-Version:  Oracle JDBC Driver version - "10.2.0.4.0"  
Implementation-Version: Oracle JDBC Driver version - "10.2.0.4.0"  
Implementation-Vendor:  Oracle Corporation  
Implementation-Time:    Sat Feb  2 11:40:29 2008

I guess you solved this long ago, but for those who come here now. The solution can be found here: http://stackoverflow.com/a/27847317/511976 — mhvelplund, Oct 04 '16 at 19:39

score 65 · Answer 1 · edited Mar 12 '18 at 10:43

With JDBC, that error usually occurs because your JDBC driver implements an older version of the JDBC API than the one included in your JRE. These older versions are fine so long as you don't try and use a method that appeared in the newer API.

I'm not sure what version of JDBC setBinaryStream appeared in. It's been around for a while, I think.

Regardless, your JDBC driver version (10.2.0.4.0) is quite old, I recommend upgrading it to the version that was released with 11g (download here), and try again.

score 14 · Accepted Answer · answered Jul 29 '09 at 08:49

It looks that even if the driver 10.2 is compatible with the JDBC3 it may not work with JRE6 as I've found here:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#02_03

Which JDBC drivers support which versions of Javasoft's JDK?

pre-8i OCI and THIN Drivers - JDK 1.0.x and JDK 1.1.x
8.1.5 OCI and THIN Drivers - JDK 1.0.x and JDK 1.1.x
8.1.6SDK THIN Driver - JDK 1.1.x and JDK 1.2.x (aka Java2)
8.1.6SDK OCI Driver - Only JDK 1.1.x
8.1.6 OCI and THIN Driver - JDK 1.1.x and JDK 1.2.x
8.1.7 OCI and THIN Driver - JDK 1.1.x and JDK 1.2.x
9.0.1 OCI and THIN Driver - JDK 1.1.x, JDK 1.2.x and JDK 1.3.x
9.2.0 OCI and THIN Driver - JDK 1.1.x, JDK 1.2.x, JDK 1.3.x, and JDK 1.4.x
10.1.0 OCI and THIN Driver - JDK 1.2.x, JDK 1.3.x, and JDK 1.4.x
10.2.0 OCI and THIN Driver - JDK 1.2.x, JDK 1.3.x, JDK 1.4.x, and JDK 5.0.x
11.1.0 OCI and THIN Driver - JDK 1.5.x and JDK 1.6.x

Oracle 10.2.0 supports:

Full support for JDBC 3.0
Note that there is no real change in the support for the following in the database. Allthat has changed is that some methods that previously threw SQLException now do something more reasonable instead.
result-set holdability
returning multiple result-sets.

So use the 11g drivers... you said you tried them and it worked, so what's the problem? — skaffman, Jul 29 '09 at 08:59
Yep, the problem doesn't exist anymore. I just wanted to figure out what was happening. — mic.sca, Jul 29 '09 at 09:17

score 6 · Answer 3 · answered Jul 28 '09 at 15:47

6

Here's what the JDK API says about AbstractMethodError:

Thrown when an application tries to call an abstract method. Normally, this error is caught by the compiler; this error can only occur at run time if the definition of some class has incompatibly changed since the currently executing method was last compiled.

Bug in the oracle driver, maybe?

answered Jul 28 '09 at 15:47

Steve B.

55,454
12
93
132

Yes, the error terminates the JVM so it's very important to know what is causing it! As soon as I can (tomorrow) I will check if downloading the latest version of the client helps. The other thing that comes to my mind is that there is some dll conflict with a oracle client on my machine. – mic.sca Jul 28 '09 at 16:00

score 4 · Answer 4 · edited Oct 26 '12 at 08:26

4

Just put ojdbc6.jar in class path, so that we can fix CallbaleStatement exception:

oracle.jdbc.driver.T4CPreparedStatement.setBinaryStream(ILjava/io/InputStream;J)V)

in Oracle.

edited Oct 26 '12 at 08:26

rolve

10,083
4
55
75

answered Mar 28 '12 at 09:53

Sudarsan

41
1

score 3 · Answer 5 · answered Jul 29 '09 at 09:02

3

As described in the API of java.sql.PreparedStatement.setBinaryStream() it is available since 1.6 so it is a JDBC 4.0 API! You use a JDBC 3 Driver so this method is not available!

answered Jul 29 '09 at 09:02

Arne Burmeister

20,046
8
53
94

score 3 · Answer 6 · edited Mar 12 '18 at 10:42

Just use ojdb6.jar and will fix all such issues.

For maven based applications:

Download and copy ojdbc6.jar to a directory in your local machine
From the location where you have copied your jar install the ojdbc6.jar in your local .M2 Repo by issuing below command C:\SRK\Softwares\Libraries>mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.3 -Dpackaging=jar -Dfile=ojdbc6.jar -DgeneratePom=true

Add the below in your project pom.xml as ojdbc6.jar dependency

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.3</version>
</dependency>

PS: The issue might be due to uses of @Lob annotation in JPA for storing large objects specifically in oracle db columns. Upgrading to 11.2.0.3 (ojdbc6.jar) can resolve the issue.

score 2 · Answer 7 · edited Jul 17 '16 at 20:59

In my case this was the error.

Exception in thread "main" java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.isValid(I)Z at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:917) at org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:282) at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:356) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2306) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2289) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1532) at beans.Test.main(Test.java:24)

Solution: I just change ojdbc14.jar to ojdbc6.jar

score 1 · Answer 8 · answered Jul 28 '09 at 16:03

1

I would suggest investigating your classpath very carefully. You might have two different versions of a jar file where one invokes methods in the other and the other method is abstract.

answered Jul 28 '09 at 16:03

Thorbjørn Ravn Andersen

73,784
33
194
347

valijon · Answer 9 · 2018-02-15T11:35:14.870

In my case problem was at context.xml file of my project.

The following from context.xml causes the java.lang.AbstractMethodError, since we didn't show the datasource factory.

<Resource name="jdbc/myoracle"
              auth="Container"
              type="javax.sql.DataSource"
              driverClassName="oracle.jdbc.OracleDriver"
              url="jdbc:oracle:thin:@(DESCRIPTION = ... "
              username="****" password="****" maxActive="10" maxIdle="1"
              maxWait="-1" removeAbandoned="true"/>

Simpy adding factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" solved the issue:

<Resource name="jdbc/myoracle"
              auth="Container"
              factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"  type="javax.sql.DataSource"
              driverClassName="oracle.jdbc.OracleDriver"
              url="jdbc:oracle:thin:@(DESCRIPTION = ... "
              username="****" password="****" maxActive="10" maxIdle="1"
              maxWait="-1" removeAbandoned="true"/>

To make sure I reproduced the issue several times by removing factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" from Resource

Changing ojdbc7.jar to ojdbc8.jar or other versions didn't help much — valijon, Feb 15 '18 at 11:47

score 0 · Answer 10 · answered Aug 09 '13 at 03:17

I do meet this problem. use ojdbc14.jar and jdk 1.6

InputStream in = new FileInputStream(file);     
cstmt.setBinaryStream(1, in,file.length());  // got AbstractMethodError 

InputStream in = new FileInputStream(file);     
cstmt.setBinaryStream(1, in,(int)file.length());  // no problem.

score 0 · Answer 11 · edited May 06 '14 at 09:44

0

InputStream in = new FileInputStream(file);     
cstmt.setBinaryStream(1, in,file.length());

instead of this u need to use

InputStream in = new FileInputStream(file);     
cstmt.setBinaryStream(1, in,(int)file.length());

edited May 06 '14 at 09:44

AlexVogel

10,601
10
61
71

answered May 06 '14 at 09:25

Dhananjay Randive

1

Teddy · Answer 12 · 2014-10-03T10:43:19.647

0

The problem is due to older version of ojdbc - ojdbc14.

Place the latest version of ojdbc jar file in your application or shared library. (Only one version should be there and it should be the latest one) As of today - ojdbc6.jar

Check the application libraries and shared libraries on server.

edited Oct 03 '14 at 10:43

answered Oct 03 '14 at 10:37

Teddy

4,009
2
33
55

score 0 · Answer 13 · edited Mar 12 '18 at 10:41

0

I think, the reason of the error from JDBC driver, you should get suitable JDBC driver for your Oracle db. You can get it from

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

edited Mar 12 '18 at 10:41

Ahmed Ashour

5,179
10
35
56

answered Jun 09 '15 at 08:50

ArmağaN OlsuN

1
2

score -2 · Answer 14 · edited Mar 12 '18 at 10:43

-2

I got the same problem and resolved it.

To resolve this problem, you should upgrade commons-dbcp library to latest version (1.4). It will work with latest JDBC drivers.

edited Mar 12 '18 at 10:43

Ahmed Ashour

5,179
10
35
56

answered Nov 16 '13 at 12:55

ThanhMai

1

1

Thanks, but I'm not using commons-dbcp. – mic.sca May 28 '14 at 08:02

Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?

14 Answers14

Linked

Related