This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Connection Pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Pool" Watch "Connection Pool" New topic
Author

Connection Pool

Huang Jin
Greenhorn

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
Hi
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. (http://www.caucho.com) 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.
Sorry.


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

Joined: Feb 01, 2001
Posts: 3
Thanks so much. You are very helpful.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection Pool
 
Similar Threads
suggest a concept for workshop
Problem with the JDBC driver.
Connection pooling...?
issue with datasource
Trying to make a connection pool with WebLogic 6.1 and SQL Server 2000