[jboss-jira] [JBoss JIRA] Updated: (JBMESSAGING-1010) ORA-01000: maximum open cursors exceeded when adding messages to a queue

[Tim Fox (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBMESSAGING-1010?page=all ]

Tim Fox updated JBMESSAGING-1010:
---------------------------------

    Fix Version/s: 1.4.0.CR1

> 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
>          Components: Messaging Core Persistence
>    Affects Versions: 1.3.0.GA
>            Reporter: Jay Howell
>         Assigned To: Tim Fox
>             Fix For: 1.4.0.CR1
>
>
> 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