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

[JBoss JIRA] Created:...

Simo Nikula (JIRA)

Thursday, 11 February 2010 Thu, 11 Feb '10

4:20 a.m.

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

Show replies by date

Simo Nikula (JIRA)

Thursday, 11 February Thu, 11 Feb

5:52 a.m.

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

[ https://jira.jboss.org/jira/browse/JBMESSAGING-1789?page=com.atlassian.ji... ] 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

Howard Gao (JIRA)

Thursday, 4 March Thu, 4 Mar

9:04 a.m.

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

[ https://jira.jboss.org/jira/browse/JBMESSAGING-1789?page=com.atlassian.ji... ] Howard Gao updated JBMESSAGING-1789: ------------------------------------ Fix Version/s: 1.4.0.SP3.CP11 1.4.7.GA 1.4.8.GA Assignee: Howard Gao

...

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 Assignee: Howard Gao Fix For: 1.4.0.SP3.CP11, 1.4.7.GA, 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)

Howard Gao (JIRA)

Wednesday, 28 July Wed, 28 Jul

4:03 a.m.

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

[ https://jira.jboss.org/browse/JBMESSAGING-1789?page=com.atlassian.jira.pl... ] Howard Gao updated JBMESSAGING-1789: ------------------------------------ Fix Version/s: (was: 1.4.7.GA)

...

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

Yong Hao Gao (JIRA)

Wednesday, 3 November Wed, 3 Nov

7:38 a.m.

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

[ https://jira.jboss.org/browse/JBMESSAGING-1789?page=com.atlassian.jira.pl... ] Yong Hao Gao updated JBMESSAGING-1789: -------------------------------------- Fix Version/s: 1.4.0.SP3.CP12 (was: 1.4.0.SP3.CP11)

...

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)

Miroslav Novak (JIRA)

Tuesday, 16 November Tue, 16 Nov

9:51 a.m.

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

[ 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

Yong Hao Gao (JIRA)

Friday, 29 April Fri, 29 Apr

8:01 a.m.

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

[ https://issues.jboss.org/browse/JBMESSAGING-1789?page=com.atlassian.jira.... ] Yong Hao Gao updated JBMESSAGING-1789: -------------------------------------- Fix Version/s: 1.4.0.SP3.CP13 (was: 1.4.0.SP3.CP12)

...

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 Environment: oracle Reporter: Simo Nikula Assignee: Yong Hao Gao Fix For: 1.4.0.SP3.CP13, 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

Yong Hao Gao (JIRA)

9:19 a.m.

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

[ https://issues.jboss.org/browse/JBMESSAGING-1789?page=com.atlassian.jira.... ] Yong Hao Gao updated JBMESSAGING-1789: -------------------------------------- Fix Version/s: 1.4.8.SP1 (was: 1.4.8.GA)

...

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 Environment: oracle Reporter: Simo Nikula Assignee: Yong Hao Gao Fix For: 1.4.0.SP3.CP13, 1.4.8.SP1 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

Miroslav Novak (JIRA)

Thursday, 26 May Thu, 26 May

2:40 a.m.

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

[ https://issues.jboss.org/browse/JBMESSAGING-1789?page=com.atlassian.jira.... ] Miroslav Novak commented on JBMESSAGING-1789: --------------------------------------------- Found also during testing EAP 5.1.1 ER2 on Oracle 11g R1 with 11.1.0.7.0 jdbc driver.

...

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 Environment: oracle Reporter: Simo Nikula Assignee: Yong Hao Gao Fix For: 1.4.0.SP3.CP13, 1.4.8.SP1 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

Miroslav Novak (JIRA)

2:42 a.m.

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

[ https://issues.jboss.org/browse/JBMESSAGING-1789?page=com.atlassian.jira.... ] Miroslav Novak updated JBMESSAGING-1789: ---------------------------------------- Affects Version/s: 1.4.8.GA

...

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.CP13, 1.4.8.SP1 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

Yong Hao Gao (JIRA)

Tuesday, 21 June Tue, 21 Jun

7:52 p.m.

New subject: [JBoss JIRA] Updated: (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.CP13, 1.4.8.SP2 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

Yong Hao Gao (JIRA)

11:33 p.m.

New subject: [JBoss JIRA] Updated: (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.CP14, 1.4.8.SP2 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

Yong Hao Gao (JIRA)

Tuesday, 19 July Tue, 19 Jul

9:54 p.m.

New subject: [JBoss JIRA] Updated: (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.SP2 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

Yong Hao Gao (JIRA)

Thursday, 21 July Thu, 21 Jul

12:57 a.m.

New subject: [JBoss JIRA] Updated: (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.SP3 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

Yong Hao Gao (JIRA)

Thursday, 8 September Thu, 8 Sep

10:33 p.m.

New subject: [JBoss JIRA] Updated: (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.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

Yong Hao Gao (Updated) (JIRA)

Tuesday, 25 October Tue, 25 Oct

10:44 p.m.

New subject: [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.SP5 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, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

Yong Hao Gao (Updated) (JIRA)

Thursday, 27 October Thu, 27 Oct

8:21 a.m.

New subject: [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.SP6 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)

Yong Hao Gao (Updated) (JIRA)

Wednesday, 4 January Wed, 4 Jan

9:25 p.m.

New subject: [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.SP7 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)

Yong Hao Gao (JIRA)

Sunday, 15 April Sun, 15 Apr

11:07 p.m.

New subject: [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.SP8 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)

Yong Hao Gao (JIRA)

Sunday, 22 July Sun, 22 Jul

11:58 p.m.

New subject: [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.SP9 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)

Yong Hao Gao (JIRA)

Tuesday, 16 October Tue, 16 Oct

9:26 p.m.

New subject: [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.SP10 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, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

4455

days inactive

5434

days old

jboss-jira@lists.jboss.org

Manage subscription

20 comments

5 participants

tags (0)

participants (5)

Howard Gao (JIRA)
Miroslav Novak (JIRA)
Simo Nikula (JIRA)
Yong Hao Gao (JIRA)
Yong Hao Gao (Updated) (JIRA)

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

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