DataSource jdbc.pstmtmax>0 causes java.sql.SQLException: Ensemble de résultats épuisé
I have deployed a J2EE application that works fine as long as my DataSource doesn't use the prepared statement cache. To improve the performance of my application I have used this prepared statement cache setting the pstmtmax to 100. By doing so the application throws a " java.sql.SQLException: Ensemble de résultats épuisé".
The detailed configuration of my data source is :
jdbc.minconpool 10 jdbc.maxwaittime 5 datasource.classname oracle.jdbc.OracleDriver jdbc.connchecklevel 0 jdbc.maxconpool= 50 datasource.url jdbc:oracle:thin:@LRBDDFLD3:2483:RNEWFLD jdbc.maxwaiters 100 datasource.mapper rdb.oracle jdbc.connteststmt SELECT * FROM DUAL datasource.description DataSource pre prod Marange datasource.password h4r3c datasource.name DataSourcePRO datasource.username HERMES_USER jdbc.maxopentime 60 jdbc.connmaxage 1440 jdbc.pstmtmax 100