Re: Connection Pooling Solution

Because the MySql driver is a javax.sql.DataSource and that's what gets passed back by the pool, making the pool transparent (no pun intended). That way you can later change the driver or the pooling details without changing your code (assuming the SQL dialect still works). Rick - Original

Re: Connection Pooling Solution

At 03:43 PM 5/30/02 -0400, Rick Fincher wrote: Because the MySql driver is a javax.sql.DataSource and that's what gets passed back by the pool, making the pool transparent (no pun intended). That way you can later change the driver or the pooling details without changing your code (assuming the

Re: Connection Pooling Solution

javax.sql.DataSource itself is not returning Connections. DataSource is an interface -- what this means in practice is that some random class (in this case, BasicDataSource) is implementing that interface. You're actually asking that class for a Connection, and you know that you can call any

Re: Connection Pooling Solution

fillup, At 01:28 PM 5/30/02 -0700, Phillip Morelock wrote: javax.sql.DataSource itself is not returning Connections. DataSource is an interface -- what this means in practice is that some random class (in this case, BasicDataSource) is implementing that interface. You're actually asking that

Re: Connection Pooling Solution

On 5/30/02 2:05 PM, Cindy Ballreich [EMAIL PROTECTED] wrote: Yes, much more so. Thanks! I was misunderstanding the whole relationship. I Cool! Yeah, if you look at the packages: javax.servlet.http and javax.sql and java.sql I think you'll start to see how powerful the concept of interfaces

RE: Connection Pooling Solution

. Thanks Les -Original Message- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: 24 May 2002 18:37 To: [EMAIL PROTECTED] Subject: Re: Connection Pooling Solution Thanks a million Les, This is very helpful. Quick question: I didn't see a jar in th DBCP nightly build after I

RE: Connection Pooling Solution

) the answer will end up in the mail archives. Thanks Les -Original Message- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: 24 May 2002 18:37 To: [EMAIL PROTECTED] Subject: Re: Connection Pooling Solution Thanks a million Les, This is very helpful. Quick

RE: Connection Pooling Solution

Pooling Solution Thanks a million Les, This is very helpful. Quick question: I didn't see a jar in th DBCP nightly build after I downloaded it, how do you build this thing? Thanks again, Rick - Original Message - Hi all, Having felt

Re: Connection Pooling Solution

PROTECTED]] Sent: 24 May 2002 18:37 To: [EMAIL PROTECTED] Subject: Re: Connection Pooling Solution Thanks a million Les, This is very helpful. Quick question: I didn't see a jar in th DBCP nightly build after I downloaded it, how do you build this thing? Thanks again, Rick - Original

Connection Pooling Solution

Hi all, Having felt the pain in getting connection pooling to work with TC 4.0.3 I've knocked up a simple howto. This is for TC 4.0.3 JDK 1.4, mySQL 4.0 Alpha so YMMV. Enjoy, Les I Downloaded: Tomcat 4.0.3 LE JDK 1.4 Build mySQL4.0.1 alpha mm.mysql 2.0.14 Jakarta-Commons projects DBCP