[jira] [Created] (WW-4370) Facing Connection Issues when runing struts 2.3.16.3 Application on Apache Tomcat 7.0.33

[farrukh hasan (JIRA)]

farrukh hasan created WW-4370:
---------------------------------

             Summary: Facing Connection Issues when runing struts 2.3.16.3 
Application on Apache Tomcat 7.0.33
                 Key: WW-4370
                 URL: https://issues.apache.org/jira/browse/WW-4370
             Project: Struts 2
          Issue Type: Bug
          Components: Other
    Affects Versions: 2.3.16.3
         Environment: Operating System RedHat 4.1.2-44 , 
64-Bit Quard Core Machine, Intel Xeon X3440 @2.35GH,
12 Gb Ram,
            Reporter: farrukh hasan
            Priority: Critical


We are running our struts 2.3.16.3 Application on Apache Tomcat 7.0.33.
Jdk Version is : jdk1.6.0_27
Oracle 11g as Database.

We are facing connection issues. Following is the stack Trace

java.sql.SQLException: Closed Connection
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
        at 
oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:946)
        at 
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:853)
        at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
        at 
org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
        at 
org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
        at $Proxy6.prepareStatement(Unknown Source)

Connections which are used from Connection pool are not returned to
pool due to which connection become unavailable to other requests. 

For connection Pooling we are using 
org.apache.tomcat.jdbc.pool.DataSourceFactory as factory in context.xml
Configurations are as :

<Resource removeAbandonedTimeout="2" removeAbandoned="true" auth="Container" 
driverClassName="oracle.jdbc.OracleDriver" 
        factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" maxActive="30" 
maxIdle="10" maxWait="300" name="jdbc/DSTest" password="test"
        type="javax.sql.DataSource" url="jdbc:oracle:thin:@127.0.0.1:1521:xyz"
        username="test" />
        <ResourceLink global="jdbc/DSTest" name="jdbc/DSTest"
                type="javax.sql.DataSource" />


Connector Setting in Server.xml :

<Connector port="8088" connectionTimeout="200000" redirectPort="8443" 
protocol="org.apache.coyote.http11.Http11NioProtocol" 
                socket.appReadBufSize="1024" socket.appWriteBufSize="1024" 
bufferSize="1024"
                maxThreads="5000" />

Heap Size is defined as following in catalina.sh
JAVA_OPTS="-Xms2048m -Xmx3072m"



--
This message was sent by Atlassian JIRA
(v6.2#6252)