Connection Pooled  
Author Message
Shinya Koizumi





PostPosted: 2007-1-18 19:23:00 Top

java-programmer, Connection Pooled I want to use connection pool just like those mensioned in the following
link but for MSSQL
and MySQL. Do I have to depend on the vendor package?

http://www.lc.leidenuniv.nl/awcourse/oracle/java.920/a96654/connpoca.htm#1057365

SK


 
ck





PostPosted: 2007-1-18 21:29:00 Top

java-programmer >> Connection Pooled Shinya Koizumi wrote:
> I want to use connection pool just like those mensioned in the following
> link but for MSSQL
> and MySQL. Do I have to depend on the vendor package?
>
> http://www.lc.leidenuniv.nl/awcourse/oracle/java.920/a96654/connpoca.htm#1057365
>
> SK

You would need Driver for ms sql which you can get from
http://jtds.sourceforge.net and you would need to specify the ms sql
databaseName and dataSourceName. The article you referred to is
specific to Oracle.

 
Manish Pandit





PostPosted: 2007-1-19 2:54:00 Top

java-programmer >> Connection Pooled
Shinya Koizumi wrote:
> I want to use connection pool just like those mensioned in the following
> link but for MSSQL
> and MySQL. Do I have to depend on the vendor package?
>
> http://www.lc.leidenuniv.nl/awcourse/oracle/java.920/a96654/connpoca.htm#1057365
>
> SK

Give Apache DBCP a look - it is a pretty good and robust connection
pooling. I use it with mySQL and have not faced any problems so far.

Link: http://jakarta.apache.org/commons/dbcp/

-cheers,
Manish