-
1. Re: PreparedStatementCache
rafcio Mar 22, 2004 2:56 AM (in response to cherold)I think the parameter prepared-statement-cache-size is per transaction. But I'm not sure.
Regards,
Rafal -
2. Re: PreparedStatementCache
cherold Mar 23, 2004 4:51 AM (in response to cherold)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 -
3. Re: PreparedStatementCache
pants Aug 18, 2004 5:44 AM (in response to cherold)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?
-
4. Re: PreparedStatementCache
cherold Aug 19, 2004 3:28 AM (in response to cherold)Hi all
Hi Dear JBoss Cracks !
Would be nice to get an answer to my question (thanks "pants" and Rafal).
Isn't there any JBoss Develeper who can answer this little question?
Why can't I see any Difference when declaring a PreparedStatement Cache in the DataSource config ?
well thanks a lot .. I will wait some more months :-)
regards
Christian -
5. Re: PreparedStatementCache
pants Aug 23, 2004 5:32 AM (in response to cherold)Found answer, if you call prepareStatement with any arguments other than just the sql then caching doesn't work.
-
6. Re: PreparedStatementCache
restrepo Sep 14, 2004 6:47 AM (in response to cherold)Hi,
What is not yet clear for me is why in the JMX-Console the "JBoss LocalTransaction JDBC Wrapper"the attribute "PreparedStatementCacheSize"has the value null.
Is it a JBoss bug? I'am working with JBoss 3.2.5
Any help will be really apreciated,
Fabio.