https://bz.apache.org/bugzilla/show_bug.cgi?id=58610
Bug ID: 58610
Summary: Oracle DB connections not releasing from connection
pool in Tomcat 8
Product: Tomcat 8
Version: 8.0.26
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: Manager
Assignee: [email protected]
Reporter: [email protected]
We are migrating Tomcat6, java 6 and Oracle 10g web-applications to Tomcat 8,
Java 8 and Oracle 10g. Our applications working fine after migrated, but
initial connections (initialSize="5") available in connection pool not released
after Tomcat shut down. When second time starting tomcat, its creating 5 more
initial connections to pool. I am using below resource configuration in
server.xml
<Resource name="TestAppDataSource" auth="Container"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
initialSize="5" maxActive="40" maxIdle="40" minIdle="5"
timeBetweenEvictionRunsMillis="30000" minEvictableIdleTimeMillis="30000"
maxWait="10000" testWhileIdle="true" testOnBorrow="true"
testOnReturn="false"
validationQuery="SELECT 1 from dual" validationInterval="30000"
logAbandoned="true" removeAbandonedTimeout="30"
removeAbandonedOnBorrow="true" removeAbandonedOnMaintenance="true"
suspectTimeout="300" maxAge="60000"
url="jdbc:oracle:thin:@//IP_ADDRESS:1521/SCHEMA_NAME"
username="USER_NAME" password="PASSWORD"
/>
And below resource link configuration in application META_INF/context.xml
<ResourceLink
name="APP_TEST" global="TestAppDataSource"
type="javax.sql.DataSource"
/>
I am using ojdbc7.jar for oracle driver. Please help whether i missed any
configuration..
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
