Well, usually, it comes from the ratio pooledPreparedStatements and the number of connections. Here you are running with default, so it should be 8 connections. As per the way Oracle actually works, the cursor can remain opened with the preparedStatement.
Jean-Louis 2013/4/2 BKumar <[email protected]> > In tomee.xml I have set resource as below.But still no luck. Is any other > property I am missing here? Which will stop holding cursor by the > container. > > <Resource id="RageDataSource" type="DataSource"> > JdbcDriver oracle.jdbc.driver.OracleDriver > JdbcUrl jdbc:oracle:thin:@<ID>:5584:PLTDEV > UserName test > Password test > JtaManaged true > DataSourceCreator = dbcp > PoolPreparedStatements true > maxOpenPreparedStatements 200 > </Resource> > > <Resource id="RageNoTxDataSource" type="DataSource"> > JdbcDriver oracle.jdbc.driver.OracleDriver > JdbcUrl jdbc:oracle:thin:@<ID>:5584:PLTDEV > UserName test > Password test > JtaManaged false > DataSourceCreator = dbcp > PoolPreparedStatements true > maxOpenPreparedStatements 200 > </Resource> > > > > -- > View this message in context: > http://openejb.979440.n4.nabble.com/maximum-open-cursors-exceeded-in-entity-bean-tp4661896p4661902.html > Sent from the OpenEJB User mailing list archive at Nabble.com. > -- Jean-Louis
