6 Replies Latest reply on Sep 14, 2004 6:47 AM by Fabio Restrepo

    PreparedStatementCache

    Wolf-Christian Herold Newbie

      Hi

      Does anybody know if there is a runnning preparedStatementCache in Jboss 3.2.x ?
      I use JBoss 3.2.3 with JDK 1.4.2 and DB2 8.1 in Linux.
      I saw there is a property for the Datasource:
      <prepared-statement-cache-size>100</prepared-statement-cache-size>
      but setting this (with different values) didn't change anything.
      On the DB side, it doesn't seem to cache client request for Prepare.

      What I understood is, when caching is enabled the prepare call can be cacheched in the client Pool to avoid a network call (well the DB also caches the prepare internal to avoid recalculating thing each call).

      When enabling the Trace for jboss... resource I couldn't see any hints about caching.

      In the JMX-Console the "JBoss LocalTransaction JDBC Wrapper" has an attribute "PreparedStatementCacheSize" with value null.

      So how does it work , does it work and how to configure?

      I could't find any documentation about it (only in the JCA docs the parameter).

      Thanks