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 11:31:04 GMT

    [ https://issues.apache.org/jira/browse/WW-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14056117#comment-14056117
] 

Lukasz Lenart commented on WW-4370:
-----------------------------------

How is this related to Struts?

> 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