0 Replies Latest reply on Dec 19, 2013 5:31 AM by mac2009

    JBoss EAP 6.2 with DB2 v9.7 FP5 - Exception when inserting a @Lob (JDBC type 3 driver only)

    mac2009
    mac2009 Dec 19, 2013 5:31 AM

      Hello all,

       

      testing an update from EAP 6.0.1 to 6.2. DB2 JDBC driver is v9.7 FP (3.63.75; JDBC type 3).

      With EAP 6.2 we get an exception when inserting a @Lob column.

      Stacktrace is bit longer but I think that's the interesting part.

      ...

      Caused by: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver

          at org.jboss.jca.adapters.jdbc.WrappedConnection.checkException(WrappedConnection.java:1636)

          at org.jboss.jca.adapters.jdbc.WrappedStatement.checkException(WrappedStatement.java:1267)

          at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.setCharacterStream(WrappedPreparedStatement.java:1451)

          at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$4$1.doBind(ClobTypeDescriptor.java:114) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

          at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:93) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

          at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:280) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

          at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:275) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

          at org.hibernate.type.AbstractSingleColumnStandardBasicType.nullSafeSet(AbstractSingleColumnStandardBasicType.java:57) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

          at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2800) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

          at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3205) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

          ... 129 more

      Caused by: java.lang.AbstractMethodError: com.ibm.db2.jcc.am.zn.setCharacterStream(ILjava/io/Reader;J)V

          at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.setCharacterStream(WrappedPreparedStatement.java:1447)

          ... 136 more

       

      Switching to the type 4 driver (4.13.80) and everything is fine.

      So it's not a big issue, but I would like to know the reason...and maybe it's a bug?

       

      Best regards

      Carsten