Agreed w/ Jean-Louis. Usually we do 10x the max open statements to get the max open cursors to configure the DB with. Plus x the number of app servers.
On Tue, Apr 2, 2013 at 7:59 AM, Jean-Louis MONTEIRO <[email protected]>wrote: > 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 >
