[JBoss-user] [JCA/JBoss] - Re: PreparedStatementCache
Hi, What is not yet clear for me is why in the JMX-Console the JBoss LocalTransaction JDBC Wrapperthe attribute PreparedStatementCacheSizehas the value null. Is it a JBoss bug? I'am working with JBoss 3.2.5 Any help will be really apreciated, Fabio. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3848124#3848124 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3848124 --- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: PreparedStatementCache
Found answer, if you call prepareStatement with any arguments other than just the sql then caching doesn't work. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845876#3845876 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845876 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: PreparedStatementCache
We are seeing the same behaviour, setting the prepared-statement-cache-size doesn't seem to have any effect. Is there another setting that needs to be set apart from just the datasource descriptor? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845416#3845416 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845416 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: PreparedStatementCache
Hi what do you meen hen you say per transaction. I use an JDBC DataSource. Transaktions are Handled by DB2 Database. I do not use CMP or User Transacton in JBoss. So my Conncetion Pool just Pools Connections for my Application. Each Connection is used only by my custom Classes (called from SLSB). I'm using direkt JDBC API calls. As far as I understood, there are no transaktion performed in JBoss. So am I wrong ? thanks for help (also some further help :-) ) Christian a href=http://www.jboss.org/index.html?module=bbop=viewtopicp=3827031#3827031;View the original post/a a href=http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3827031Reply to the post/a --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470alloc_id=3638op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: PreparedStatementCache
I think the parameter prepared-statement-cache-size is per transaction. But I'm not sure. Regards, Rafal a href=http://www.jboss.org/index.html?module=bbop=viewtopicp=3826813#3826813;View the original post/a a href=http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3826813Reply to the post/a --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470alloc_id=3638op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user