Was the prepared statement cache in 3.2.2 ?
--- Adrian Brock <[EMAIL PROTECTED]> wrote: > 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 ===== 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
