Don't forget, however, that JDBC 2.0 does provide for Connection-pooling
"under the hood", so some database drivers may not need explicit pool
management:
"3.6 Connection Pooling
"The JDBC 2.0 API contains `hooks' that allow connection pooling to be
implemented on top of the JDBC driver layer. This allows for a single
connection cache that spans the different JDBC drivers that may be in use.
Since creating and destroying database connections is expensive, connection
pooling is important for achieving good performance, especially for server
applications."
-- JDBC Specification (<jdk1.2.2
documentation>/docs/guide/jdbc/spec2/jdbc2.0.frame3.html#284645)
With that caveat, however, George, I'm certain many people will find your
code useful, and until those JDBC-driver writers catch up to the JDBC 2.0
Spec, explicit Connection-management is still the order of the day! :)
Ted Neward
CTO, WebRaiser ( http://www.webraiser.com )
Java Instructor, DevelopMentor ( http://www.develop.com )
Patterns/C++/Java/CORBA/EJB/COM-DCOM spoken here
http://www.javageeks.com/~tneward
-----Original Message-----
From: George Ter-Saakov <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, November 08, 1999 12:02 PM
Subject: Do you need database Pool.
>Hello.
>
>I wrote database pool. It shrinks/grows when need to. You can download it
>with sources from http://template.da.ru. ( button "Cool staff") Also it
>includes "Thread Function" manager and servlet to allow you monitor pool.
>
>It's easy to use. You must instead of DriverManager.getConnection(...)
>PoolDbManager.getConnection( ... ).
>When you close connections Pool will not close it. Connection will be
>released for reuse.
>
>You can modify sources as you want to.
>If you have any problem with it please use button "FeedBack" and I'll help
>to resolve problem.
>
>I hope it will be helpful.
>George.
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
