Hi I've an web application (Application + Hibernate + DBCP datasource + Oracle) deployed in tomcat.
Problem: I've written a thread program where in the run method I'm opening an HTTPURLConnection and feeding a valid input and reading the server response. Running the program for as many as 600 threads with no delay inbetween thread-calls I can get all the 600 requests processed without any issue. However, when I run the wget command (wget --post-file=ac.xml --header=Content-Type:text/xml http://10.227.30.204:9090/ABCService/ABCService) in a loop of 300 iteration to load-test the application I see that the application is failing after request 297 with the following error java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded BTW, my application calls a stored procedure which in turn uses an oracle SYS_REFCURSOR. As I know ref cursor can not be closed through code. Once the error is encountered the application is not recovering until the application is restarted. If anybody can help me out on the aforesaid issue My Environment : Tomcat 6.0.20 Hiberanet 3 Oracle 11g Configurations: 1. hibernate.cfg.xml <hibernate-configuration> <session-factory> <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="hibernate.connection.datasource">java:comp/env/jdbc/accdb</property> <property name="current_session_context_class">thread</property> <property name="show_sql">true</property> <mapping class="com.abacus.ac.abcevaluation.db.bean.GroupMapping" /> <mapping class="com.abacus.ac.abcevaluation.db.bean.GroupMappingPK" /> </session-factory> </hibernate-configuration> 2. DBCP configuration <Resource name="jdbc/accdb" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@1.2.3.4:1521:DB1" schema="schema_name2" username="user_name2" password="********" password="password1$" initialSize ="5" maxActive="40" maxIdle="5" maxWait="-1" removeAbandoned = "true" removeAbandonedTimeout = "60" validationQuery="select 1 from dual" /> -- View this message in context: http://old.nabble.com/tomcat-issue-with-DBCP-connection-pool-tp31199494p31199494.html Sent from the Tomcat - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org