[
https://issues.apache.org/jira/browse/WW-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14056238#comment-14056238
]
Lukasz Lenart commented on WW-4370:
-----------------------------------
You cannot post your questions wherever you want and expect that someone will
help you. From my point of view you have inappropriate configuration for
Tomcat, it will be better to search/ask how to configure JDBC pool under Tomcat.
> 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)
