prepared-statement-cache-size problem

[restrepo]

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.

[genman]

Verify your -ds.xml files against the DTD, using a tool such as xmllint.

[dsldsl]

whats the DTD URL for oracle-ds.xml?

[dsldsl]

BTW, did you ever get this fixed? I have the same problem...

[lafr]

"dsldsl" wrote:
whats the DTD URL for oracle-ds.xml?

It's

<!DOCTYPE datasources
 PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.0//EN"^M
 "http://www.jboss.org/j2ee/dtd/jboss-ds_1_0.dtd">

for JBoss 3.x.x and it's

<!DOCTYPE datasources PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
 "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">

for JBoss 4.0.x.