Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-2613

Blobs/Clobs don't work with DB2 9.7 JDBC driver

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • EAP 5.0.0
    • Hibernate
    • None

    • DB2 9.7 with JDBC driver from 9.7

    • Release Notes
    • Workaround Exists
    • Hide

      there are 2 workarounds here
      1. create a property file named DB2JccConfiguration.properties and it should be on your class path or in a JAR which should also be on your classpath.
      then put this line below into that properties file
      "db2.jcc.override.progressiveStreaming=2"
      this will disable progressive streaming on DB2

      2. you can use the DB2 JDBC 9.1 version instead of the 9.7 version.

      Note: When Version 9.1 JDBC is used with a 9.7 DB, only DB2 Version 9.1 or earlier functionality is available.
      ( http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.qb.upgrade.doc/doc/c0022579.html)

      Show
      there are 2 workarounds here 1. create a property file named DB2JccConfiguration.properties and it should be on your class path or in a JAR which should also be on your classpath. then put this line below into that properties file "db2.jcc.override.progressiveStreaming=2" this will disable progressive streaming on DB2 2. you can use the DB2 JDBC 9.1 version instead of the 9.7 version. Note: When Version 9.1 JDBC is used with a 9.7 DB, only DB2 Version 9.1 or earlier functionality is available. ( http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.qb.upgrade.doc/doc/c0022579.html )

      Unit tests involving Blob/Clob locators are failing when the DB2 9.7 version of JDBC is used.

      org.hibernate.test.lob.BlobTest.testBoundedBlobLocatorAccess
      org.hibernate.test.lob.BlobTest.testUnboundedBlobLocatorAccess
      org.hibernate.test.lob.ClobTest.testBoundedClobLocatorAccess
      org.hibernate.test.lob.ClobTest.testUnboundedClobLocatorAccess
      org.hibernate.ejb.test.lob.BlobTest.testBlobSerialization

      "Materialized" Blobs and Clobs seem to work properly.

            shaozliu Strong Liu(刘少壮) (Inactive)
            gbadner@redhat.com Gail Badner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: