Uploaded image for project: 'JBoss Enterprise SOA Platform'
  1. JBoss Enterprise SOA Platform
  2. SOA-3350

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

    XMLWordPrintable

    Details

    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      there are 2 workarounds here
      1. add the following to the connection url:

      :driverType=4;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;

      so the url looks like:

      So the full URL looks like:

      jdbc:db2://<host>:50000/testDB:driverType=4;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;

      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.

      Show
      there are 2 workarounds here 1. add the following to the connection url: :driverType=4;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2; so the url looks like: So the full URL looks like: jdbc:db2://<host>:50000/testDB:driverType=4;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2; 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.
    • Release Notes Text:
      Hide
      https://issues.jboss.org/browse/SOA-3350

      When using a DB2 9.7 database to retrieve blobs/clobs, you may run into the issue where DB2 hasn't fully materialized the blobs/clobs in your query. This was not an issue in DB2 9.1. Therefore, to access blobs/clobs in a DB2 9.7 database using EDS you need to append the following to your connection url: :driverType=4;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;
      Show
      https://issues.jboss.org/browse/SOA-3350 When using a DB2 9.7 database to retrieve blobs/clobs, you may run into the issue where DB2 hasn't fully materialized the blobs/clobs in your query. This was not an issue in DB2 9.1. Therefore, to access blobs/clobs in a DB2 9.7 database using EDS you need to append the following to your connection url: :driverType=4;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;
    • Release Notes Docs Status:
      Documented as Known Issue

      Description

      BQT Testing is failing reading Blobs/Clobs against DB2 using the 9.7 driver. Found a JBAPP jira (JBPAPP-2613) that discusses this issue and the workaround. However, checked the DB2 website and there appears to a possible fix in the update on March 25, 2011. But that still has to be tested.

        Gliffy Diagrams

          Attachments

            Issue Links

            is related to

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

            • Major - A request that should be considered seriously but is not a show stopper.
            • Resolved

              Activity

                People

                • Assignee:
                  van.halbert Van Halbert
                  Reporter:
                  van.halbert Van Halbert
                  Writer:
                  David Le Sage
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: