ORA-01000: maximum open cursors exceeded when adding messages to a queue ------------------------------------------------------------------------ Key: JBMESSAGING-1010 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-1010 Project: JBoss Messaging Issue Type: Bug Affects Versions: 1.3.0.GA Reporter: Jay Howell Assigned To: Tim Fox When users create a large amount of messages and don't consume them, oracle users will get an error telling them that there are too many cursors open. The test was done with 20,000 text messages. In JDBCPersistenceManager::pageReferences we need to create the prepared statement once. We need to move the prepared statement out side of the loop. This will reduce the number of cursors open and should alleviate the problem. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira