I'm using JBoss 3.2.3 (Jetty) and have just enable prepared-statement-caching by
setting the prepared-statement-cache-size in the datasource descriptor. The setting
however appears to have had no effect, and I can see in the debugger that I keep
getting a new instance of a prepared statement.
Is there anything else I need to do apart from simply modify the datasource descriptor?
Descriptor snippet below..
<local-tx-datasource>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<jndi-name>Blah</jndi-name>
<connection-url>jdbc:oracle:thin:@server1:1521:server1</connection-url>
<user-name>user</user-name>
pass
<min-pool-size>20</min-pool-size>
<max-pool-size>40</max-pool-size>
<blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
<idle-timeout-minutes>5</idle-timeout-minutes>
<prepared-statement-cache-size>50</prepared-statement-cache-size>
</local-tx-datasource>
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845419#3845419
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845419
-------------------------------------------------------
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
