java.lang.AbstractMethodError: oracle.jdbc.driver.T4CPreparedStatement.setCharacterStream(ILjava/io/Reader;J)V

spring hibernate oracle10g clob
Tiny picture Tiny · Feb 17, 2013 · Viewed 9.9k times · Source

I'm getting the following exception when trying to insert the contents of a CKEditor (for CMS - Contents Management System) into Oracle database - Oracle 10g.

The field in the Oracle table is of type clob.

java.lang.AbstractMethodError: oracle.jdbc.driver.T4CPreparedStatement.setCharacterStream(ILjava/io/Reader;J)V

The opposite side is that this exception is not caused when I try to insert the same contents into the database via AJAX using JSON.

I'm using

  • Spring 3.2.0
  • Hibernate 4.2.0.CR1
  • Oracle JDBC Driver version - 10.2.0.5.0
  • JDK - 1.7
  • Oracle 10g

The exception has been causing since I changed Hibernate from 3.2.5 to 4.2.0.CR1

This link says

There are 3 versions of the setCharacterStream() method, two of them were added as part of JDBC 4.0 (Java 1.6). Your JDBC driver may not support them:

This answer recommends to upgrade the JDBC driver but that question is about Oracle 11g that I'm not yet using.

I'm quite not sure. Are JDBC 11.x drivers compatible with Oracle 10g? Once upon a time, I had tried with one but it didn't work properly.

How to solve this exception?

EDIT:

I have just downloaded ojdbc6.jar (previously it was ojdbc14.jar with the driver specified as above) which contains Oracle JDBC Driver version - "11.1.0.7.0-Production".

The exception exception disappeared. Kindly tell me, if this driver version is perfectly compatible with Oracle 10g.

Answer

gerrytan picture gerrytan · Feb 18, 2013

I'm quite not sure. Are JDBC 11.x drivers compatible with Oracle 10g? Once upon a time, I had tried with one but it didn't work properly.

As stated on Oracle JDBC driver 11g documentation http://docs.oracle.com/cd/E11882_01/java.112/e16548/getsta.htm

Backward Compatibility

The JDBC drivers are certified to work with the currently supported versions of Oracle Database. For example, the JDBC Thin drivers in Oracle Database 11g Release 2 (11.2) are certified to work with the 10.2.x, 10.1.x, 9.2.x, and 9.0.1.x Oracle Database releases. However, they are not certified to work with older, unsupported database releases, such as 8.0.x and 7.x.

Related questions

How to convert a CLOB data type to a String in Hibernate?

In hibernate (3.2.1.GA), I use the following method to insert CLOB type data into Oracle (10g) database. Hibernate.createClob(parameters.get("txtCatImage")); parameters is a Map where all the request parameters have been stored. While retrieving the Clob data type …

Read More
How to solve the “failed to lazily initialize a collection of role” Hibernate exception

I have this problem: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: mvc3.model.Topic.comments, no session or session was closed Here is the model: @Entity @Table(name = "T_TOPIC") public class Topic { @Id @GeneratedValue(strategy=…

Read More
Error creating bean with name 'entityManagerFactory' defined in class path resource : Invocation of init method failed

When I compile my spring project, I got the following error. Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Invocation of init method failed I am using STS Eclipse …

Read More