[jboss-jira] [JBoss JIRA] (JBMESSAGING-1789) setFetchSize used in JDBCPersistenceManager with too large value for oracle (200000)

setFetchSize used in JDBCPersistenceManager with too large value for oracle (200000) ------------------------------------------------------------------------------------ Key: JBMESSAGING-1789 URL: https://issues.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, 1.4.8.GA Environment: oracle Reporter: Simo Nikula Assignee: Yong Hao Gao Fix For: 1.4.0.SP3.CP15, 1.4.8.SP12 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)