On Tue, 2004-01-06 at 19:59, Sasidharan, Manoj wrote: > The same source build works just fine in Weblogic 7.0.SP4. Can we still > suspect the code? > > Here are some facts: > 1. Source code for building binaries (JBoss and Weblogic applications) are > same > 2. Oracle server/driver is the same > > Is there any way to set/configure the Prepared Statement Cache in JBoss? >
The max cursors message comes from not closing result sets. By spec, closing the statements should close result sets, but Oracle had problems with that in the past. I can't confirm that it was ever fixed. If you add <track-statements>true<track-statements/> to your oracle-ds.xml JBoss will inform you when you don't close statements. >From 3.2.3RC1 it also gives you a nice stack trace telling you where you opened them. (This assumes you are closing your connections). The prepared statement cache is turned off by default. You can enable it with: <prepared-statement-cache-size>100</prepared-statement-cache-size> meaning 100 cached statements per connection. You can find all these details in docs/dtd/jboss-ds_1_0.dtd Regards, Adrian > rgds > MS > > -----Original Message----- > From: Nicholas [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 06, 2004 10:53 AM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] ***JBoss 3.2.2/Oracle 9i thin driver test > running out of database cursors on HPUX11*** > > > This is nearly always because the Statements, > PreparedStatements, CallableStatements and ResultSets > are not being closed properly. > > Make sure that: > A. Finally blocks call the close() methods on each of > those resources. Also make sure that the close() calls > in the finally block are themselves in a try/catch so > a failure in one does not blow you out of the finally > before it is comlete. > B. Make sure you do not reuse Statements or ResultSets > without closing them first. > > //Nicholas > > > --- "Sasidharan, Manoj" <[EMAIL PROTECTED]> > wrote: > > Hello All, > > > > When we run our stress test, the number of Oracle > > database cursors keep > > increasing. Finally the system crashes with "Max > > Cursors Exceeded error" > > from Oracle. > > > > Any tips on how to tackle this? > > > > Thanks and Best Regards > > MS > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: IBM Linux > > Tutorials. > > Become an expert in LINUX or just sharpen your > > skills. Sign up for IBM's > > Free Linux Tutorials. Learn everything from the > > bash shell to sys admin. > > Click now! > > > http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > > _______________________________________________ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > ===== > Nicholas Whitehead > Home: (973) 377 9335 > Cell: (201) 615 2716 > [EMAIL PROTECTED] > Get Your News From The Crowbar: http://crowbar.dnsalias.com:443/crowbar/ > > > ------------------------------------------------------- > This SF.net email is sponsored by: IBM Linux Tutorials. > Become an expert in LINUX or just sharpen your skills. Sign up for IBM's > Free Linux Tutorials. Learn everything from the bash shell to sys admin. > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > ------------------------------------------------------- > This SF.net email is sponsored by: IBM Linux Tutorials. > Become an expert in LINUX or just sharpen your skills. Sign up for IBM's > Free Linux Tutorials. Learn everything from the bash shell to sys admin. > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user -- xxxxxxxxxxxxxxxxxxxxxxxx Adrian Brock Director of Support Back Office JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
