you can specify maxactive, minidle etc on dbcp ( http://tomee.apache.org/common-datasource-configurations.html + http://commons.apache.org/proper/commons-dbcp/configuration.html)
if min = max it shouldn't move a lot ;) *Romain Manni-Bucau* *Twitter: @rmannibucau <https://twitter.com/rmannibucau>* *Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/> *LinkedIn: **http://fr.linkedin.com/in/rmannibucau* *Github: https://github.com/rmannibucau* 2013/4/3 BKumar <[email protected]> > Ok I got you what you are saying.Your help is really awesome . > > One more thing when I am using dbcp pool then why the cursor count > increase > in data base abruptly, although it come down when process ends. So, based > on > this behavior i cannot fix the size of cursor in database because when my > process size increase it will increase the open cursor. > > So, my question is if I am using DBCP then is there any way to supply my > values to dbcp pool? > Because, when I run my process on jboss the active cursor size is > static > it does not even increase by one and it is also using DBCP only. > > > > -- > View this message in context: > http://openejb.979440.n4.nabble.com/maximum-open-cursors-exceeded-in-entity-bean-tp4661896p4661954.html > Sent from the OpenEJB User mailing list archive at Nabble.com. >
