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

Reply via email to