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.
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.