4 Replies Latest reply on Oct 16, 2004 8:52 AM by Frank Langelage

    prepared-statement-cache-size problem

    Fabio Restrepo Newbie

      Hello,

      I'am trying to speed up my JBoss by using the prepared-statement-cache-size parameter, but it seems that it doesn't work becasue JBoss doesn't take into account the value I set.

      I'am using JBoss 3.2.5 and Oracle 9 as DB. My problem is that in my oracle-ds.xml datasource descriptor I set the tag prepared-statement-cache-size to 500, but when I try to verify it with the JMX console, the prepared-statement-cache-size parameter has the value: Null.

      I also set the max-pool-size parameter to 50 (it is not the default value) and it is OK when I verify with the JMX console.

      Thanks in advance.

      Fabio.