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

[Simo Nikula (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBMESSAGING-1789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12511849#action_12511849 ] 

Simo Nikula commented on JBMESSAGING-1789:
------------------------------------------

Setting FullSize attribute to e.g. 65000 in Topic or Queue definition allows to run (at least with ojdbc6-11.1.0.7.0 driver)

> 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.5.GA, 1.4.6.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