struts-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lukasz Lenart (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (WW-4370) Facing Connection Issues when runing struts 2.3.16.3 Application on Apache Tomcat 7.0.33
Date Wed, 09 Jul 2014 13:43:05 GMT

    [ 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)

Mime
View raw message