3 Replies Latest reply on Mar 23, 2011 2:55 PM by amathewjboss1

    Open cursor issue with Jboss 5.1

    amathewjboss1

      Hi,

       

         We are running an application in Jboss 5.1 and we have been hit with the open cursor error. We have set the maximum open cursor to 200, but when the load is more we are getting the "maxiumum cursor exceeded" from the Oracle. We checked all the application code and made sure all the Resultset & Statement is closed in the finally block. It seems like i am missing some Jboss configuration in regards to the datasource? Any thoughts on this please?

       

      Thanks

      Anil Mathew