IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

HELP ORA01000 maximum open cursors exceeded

  • 1.  HELP ORA01000 maximum open cursors exceeded

    Posted Thu March 17, 2005 07:59 PM

    This is an urgent request for help!

    We are using webMethods 4.6 with Service Pack 2 and we have some java services that use connection pooling and execute database queries. We have 15 maximum pool connections. We have over 500 set as the max cursor limit. We have been checking the code to make sure there is a finally block which closes the resultset and the statement object thinking this may be our leak - but we do not see any open resultsets being left and WE ARE STILL GETTING THIS ERROR (ORA-01000: maximum open cursors exceeded).

    Help! Does anyone know how to resolve this issue?


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 2.  RE: HELP ORA01000 maximum open cursors exceeded

    Posted Fri March 18, 2005 08:54 AM

    Are you explicitly closing the connections & resultsets??

    OR

    Depending on your environment, you may need to have the DBA increase the value of OPEN_CURSORS in the Oracle server, if it turns out that your code is functioning correctly and you still receive the error.

    HTH

    MB


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB


Related Content