[
https://jira.jboss.org/browse/JBMESSAGING-1789?page=com.atlassian.jira.pl...
]
Miroslav Novak commented on JBMESSAGING-1789:
---------------------------------------------
The same failure i've got for ojdbc5.jar-11.1.0.7.0 (jdbc3 driver) on Oracle 11g R1.
Workaround is working. Found during testing JBM 1.4.0.SP3.CP11 testsuite with EAP 4.3.9
CR2.1.
setFetchSize used in JDBCPersistenceManager with too large value for
oracle (200000)
------------------------------------------------------------------------------------
Key: JBMESSAGING-1789
URL:
https://jira.jboss.org/browse/JBMESSAGING-1789
Project: JBoss Messaging
Issue Type: Bug
Components: Messaging Core Persistence
Affects Versions: 1.4.5.GA, 1.4.6.GA
Environment: oracle
Reporter: Simo Nikula
Assignee: Yong Hao Gao
Fix For: 1.4.0.SP3.CP12, 1.4.8.GA
in method loadFromStart (line 984 in 1.4.6) fetchSize is set based on parameter number
which is as default 200000.
setting max rows using setMaxRows with same value would be correct way to limit result
set.
java.sql.SQLException: Bigger type length than Maximum
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.java:2253)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.java:1101)
at oracle.jdbc.driver.T4C8TTIrxh.unmarshalV10(T4C8TTIrxh.java:115)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:654)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
at
org.jboss.messaging.core.impl.JDBCPersistenceManager.loadFromStart(JDBCPersistenceManager.java:988)
at
org.jboss.messaging.core.impl.PagingChannelSupport.load(PagingChannelSupport.java:211)
at
org.jboss.jms.server.destination.TopicService.startService(TopicService.java:92)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira