From: Nathan H. <nh...@sp...> - 2003-04-06 19:59:40
|
Oracle has a maximum number of statements that can be run concurrently. One of two things is occurring if you get ORA-01000 - either your OPEN_CURSORS parameter in your init.ora is too low for your load, or your JDBC operations are leaving the cursors open. Check that value first. N At 04:50 PM 4/6/2003, you wrote: >Hi, > >i'm using jboss 3.06 with oracle database. I have a message driven bean >that is getting a lot of requests, and is doing some jdbc operations. I'm >closing all the statments and the oracle connection, but after some >requests i get this error: > >java.sql.SQLException: ORA-01000: maximum open cursors exceeded > >I don't now what is wrong. Any idea ? > >thanks a lot > > > >------------------------------------------------------- >This SF.net email is sponsored by: ValueWeb: >Dedicated Hosting for just $79/mo with 500 GB of bandwidth! >No other company gives more support or power for your dedicated server >http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ >_______________________________________________ >JBoss-user mailing list >JBo...@li... >https://lists.sourceforge.net/lists/listinfo/jboss-user |