[
https://issues.apache.org/jira/browse/WW-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukasz Lenart closed WW-4370.
-----------------------------
Resolution: Not a Problem
I'm closing this as unrelated to the Struts project
> 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)
