struts-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "farrukh hasan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (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:15:05 GMT
farrukh hasan created WW-4370:
---------------------------------

             Summary: 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