File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Tomcat and the fly likes JDBC Pooling intance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "JDBC Pooling intance" Watch "JDBC Pooling intance" New topic

JDBC Pooling intance

Ravi Shankar

Joined: Sep 05, 2006
Posts: 1
I setup the JDBC pooling successfully as mentioned in tomcat website. Put the context.xml in META-INF file. Everything is working fine, i am able to access database. The problem now is everytime i call
ds.getConnection(). It's creating a new intance in oracle under linux.

Is it normal??. And the isntances leave hanging eventhough i closed the connection successuly once i finished querying. Shouldn't it get the existing connection opened rather than creating another instance.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63548

"Phnatom Menace",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

JavaRanch Sheriff

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: JDBC Pooling intance
It's not a secret anymore!