You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by bu...@apache.org on 2015/11/15 10:16:40 UTC
[Bug 58610] New: Oracle DB connections not releasing from connection
pool in Tomcat 8
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: dev@tomcat.apache.org
Reporter: rajakarunanidi@gmail.com
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: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
[Bug 58610] Oracle DB connections not releasing from connection pool
in Tomcat 8
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58610
--- Comment #3 from RajKaruna <ra...@gmail.com> ---
Konstantin Kolinko.. you are a life saver for me... Works like a charm...
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
[Bug 58610] Oracle DB connections not releasing from connection pool
in Tomcat 8
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58610
Michael Osipov <19...@gmx.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from Michael Osipov <19...@gmx.net> ---
Oracle 10g is dead and out of support. Why are you still relying on this?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
[Bug 58610] Oracle DB connections not releasing from connection pool
in Tomcat 8
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58610
Konstantin Kolinko <kn...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |INVALID
--- Comment #2 from Konstantin Kolinko <kn...@gmail.com> ---
Try adding closeMethod="close" to your <Resource>
https://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html#Resource_Definitions
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
[Bug 58610] Oracle DB connections not releasing from connection pool
in Tomcat 8
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58610
RajKaruna <ra...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|INVALID |FIXED
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
[Bug 58610] Oracle DB connections not releasing from connection pool
in Tomcat 8
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58610
RajKaruna <ra...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |Windows Server 2008
CC| |rajakarunanidi@gmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
[Bug 58610] Oracle DB connections not releasing from connection pool
in Tomcat 8
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58610
Chuck Caldarale <ch...@unisys.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|FIXED |INVALID
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org