Problem with prepared-statement-cache-size datasource config
matt__b May 23, 2012 11:10 AMHi,
We are facing an issue similar to this old unanswered one:
https://community.jboss.org/message/192271
We are using jboss eap 5.1.1 and jdbc oracle driver 11.1.0.7
When we try to activate prepared statement cache by setting the prepared-statement-cache-size parameter to 100 as follows :
<local-tx-datasource>
<jndi-name>jdbc/****</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:oracle:thin:@****</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>****</user-name>
<password>****</password>
<min-pool-size>2</min-pool-size>
<max-pool-size>30</max-pool-size>
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
<prepared-statement-cache-size>100</prepared-statement-cache-size>
<query-timeout>20</query-timeout>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>
And we are getting this SQL exception :
java.sql.SQLException : Instruction fermée
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.OracleClosedStatement.setString(OracleClosedStatement.java:479)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:278)
If we reset the prepared-statement-cache-size param to its default value (0) everything works fine again...
Could anyone shed some lights on this issue and how to solve/debug it ?
Many thanks in advance,
--Matt