Uploaded image for project: 'Struts 2'
  1. Struts 2
  2. WW-4370

Facing Connection Issues when runing struts 2.3.16.3 Application on Apache Tomcat 7.0.33

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Not A Problem
    • Affects Version/s: 2.3.16.3
    • Fix Version/s: None
    • Component/s: Other
    • Labels:
      None
    • Environment:

      Operating System RedHat 4.1.2-44 ,
      64-Bit Quard Core Machine, Intel Xeon X3440 @2.35GH,
      12 Gb Ram,

      Description

      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"

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              farrukhhsn farrukh hasan
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: