Details
-
Bug
-
Resolution: Obsolete
-
Major
-
4.3.0.GA_CP09, EAP_EWP 5.3.0.ER1
-
None
-
Documentation (Ref Guide, User Guide, etc.), Release Notes
-
-
-
Documented as Known Issue
Description
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.
