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

[Simo Nikula (JIRA)]

setFetchSize used in JDBCPersistenceManager with too large value for oracle (200000)
------------------------------------------------------------------------------------

                 Key: JBMESSAGING-1789
                 URL: https://jira.jboss.org/jira/browse/JBMESSAGING-1789
             Project: JBoss Messaging
          Issue Type: Bug
          Components: Messaging Core Persistence
    Affects Versions: 1.4.6.GA, 1.4.5.GA
         Environment: oracle
            Reporter: Simo Nikula


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.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira