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

Connection Pool

Huang Jin

Joined: Feb 01, 2001
Posts: 3
Hi guys,
I am trying to get into more study on JDBC connection pooling, could anyone of you give me more pointers regarding this topic on the web?
I have a developement environment with Win2000, Oracle8.0.5 and JDK1.3. Oracle thin drive is used. Is this configuration enough to try out some code on JDBC connection pooling?
Thanks a lot.
John Bateman
Ranch Hand

Joined: Mar 09, 2000
Posts: 320
If you want to start playing with connection pooling you need to lookup (no pun intended) JNDI.
Also, you need some kind of "service provider" that will provide a mechanism to control the resource you are pooling. In this case it's DB connections. Most Apllication Servers do this for you. Ex: Jrun, Weblogin, WebShpere etc etc). Personally if you want to just use something that has a pool, I suggest Resin. ( It's a Servlet Engine that allows Datasource connection pooling.
If you are not looking at a web based application I think you would have to look more to one of the above mentioned App Servers.
That is unless someone else can sadd to this conversation...
Hope this gets you started anyway.
P.S. Maybe Oracle 8i has some method for pooling connections but I am not an Oracle expert.

SOURCE CODE should be SURROUNDED by "code" tags.
Huang Jin

Joined: Feb 01, 2001
Posts: 3
Thanks so much. You are very helpful.
I agree. Here's the link:
subject: Connection Pool
It's not a secret anymore!