You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@struts.apache.org by "Lukasz Lenart (JIRA)" <ji...@apache.org> on 2014/07/09 15:45:11 UTC
[jira] [Closed] (WW-4370) Facing Connection Issues when runing
struts 2.3.16.3 Application on Apache Tomcat 7.0.33
[ 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)