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

JBM testsuite on Oracle 11g R1 with JDBC driver version 11.1.0.7.0 throws java.sql.SQLException: Bigger type length than Maximum...

XMLWordPrintable

    • Documentation (Ref Guide, User Guide, etc.), Release Notes
    • Hide

      Setting "FullSize" attribute to e.g. 65000 (default is 200000) in Topic or Queue definition or using Oracle JDBC driver 11.2.0.1.0 of 11.2.0.2.0 solves this issue.

      Show
      Setting "FullSize" attribute to e.g. 65000 (default is 200000) in Topic or Queue definition or using Oracle JDBC driver 11.2.0.1.0 of 11.2.0.2.0 solves this issue.
    • Hide
      Oracle JDBC driver version 11.1.0.7.0 causes the JBoss Messaging Test Suite to fail with a SQLException ("Bigger type length than Maximum") on Oracle 11g R1. This was caused by a regression in Oracle JDBC driver 11.1.0.7.0. To work around the issue, use Oracle JDBC driver version 11.2.0.2.0 with Oracle 11g R1, Oracle 11g R2, Oracle RAC 11g R1 and Oracle RAC 11g R2. Alternatively, you can set the <literal>FullSize</literal> attribute (defaults to 200000) in the Topic or Queue to a smaller value (for example, 65000).
      Show
      Oracle JDBC driver version 11.1.0.7.0 causes the JBoss Messaging Test Suite to fail with a SQLException ("Bigger type length than Maximum") on Oracle 11g R1. This was caused by a regression in Oracle JDBC driver 11.1.0.7.0. To work around the issue, use Oracle JDBC driver version 11.2.0.2.0 with Oracle 11g R1, Oracle 11g R2, Oracle RAC 11g R1 and Oracle RAC 11g R2. Alternatively, you can set the <literal>FullSize</literal> attribute (defaults to 200000) in the Topic or Queue to a smaller value (for example, 65000).
    • Documented as Known Issue

      Hi Laura,
      there is an issue with jdbc driver version 11.1.0.7.0. when used with Oracle 11g database as described in jira https://jira.jboss.org/browse/JBPAPP-3904 and https://jira.jboss.org/browse/JBMESSAGING-1789.

      SQL Exception with error message: ,,Bigger type length than Maximum" is thrown when using this version of jdbc driver. Workaround for this issue is known now.

      This issue was already documented for EAP 5 in Administration And Configuration Guide in section 12.3.6:

      "Oracle JDBC driver version 11.1.0.7.0 causes the JBoss Messaging Test Suite to fail with a SQLException ("Bigger type length than Maximum") on Oracle 11g R1.
      This is caused by a regression in Oracle JDBC driver 11.1.0.7.0. We recommend Oracle JDBC driver version 11.2.0.1.0 for use with Oracle 11g R1, Oracle 11g R2, Oracle RAC 11g R1 and Oracle RAC 11g R2."

      and in the Release Notes for EAP 5.0.1 and 5.1:

      "JBPAPP-3904 - Oracle JDBC driver version 11.1.0.7.0 causes the JBoss Messaging Test Suite to fail with a SQLException ("Bigger type length than Maximum") on Oracle 11g R1. This is caused by a regression in Oracle JDBC driver 11.1.0.7.0. We recommend Oracle JDBC driver version 11.2.0.1.0 for use with Oracle 11g R1, Oracle 11g R2, Oracle RAC 11g R1 and Oracle RAC 11g R2."

      Could you please add those notes to JBM User Guide for EAP 4.3 and to Release Notes for EAP 4.3 CP09 with small changes?

      1. We recommend Oracle JDBC driver version 11.2.0.2.0...(not 11.2.0.1.0)
      2. Add that setting "FullSize" attribute to smaller value e.g. 65000 (default is 200000) in Topic or Queue definition also solves this issue.

      If there is anything what you would like to know, feel free to ask.

      Thank you.

              rdickens_jira Russell Dickenson (Inactive)
              mnovak1@redhat.com Miroslav Novak
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: