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

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: EAP 5.0.0
    • Fix Version/s: None
    • Component/s: Hibernate
    • Labels:
      None
    • Environment:

      DB2 9.7 with JDBC driver from 9.7

    • Affects:
      Release Notes
    • Workaround:
      Workaround Exists
    • Workaround Description:
      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 )

      Description

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

            relates to

            Bug - A problem which impairs or prevents the functions of the product. SOA-3350 Blobs/Clobs don't work with DB2 9.7 JDBC driver

            • Critical - An upcoming version that is affected by this issue cannot be released until it's addressed. A critical bug is one that crashes the application, causes loss of data or severe memory leak.
            • Closed

              Activity

                People

                • Assignee:
                  stliu Strong Liu
                  Reporter:
                  gbadner Gail Badner
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: