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

[Yong Hao Gao (JIRA)]

     [ https://issues.jboss.org/browse/JBMESSAGING-1789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yong Hao Gao updated JBMESSAGING-1789:
--------------------------------------

    Fix Version/s: 1.4.8.SP4
                       (was: 1.4.8.SP3)


> 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.SP4
>
>
> 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