JDBC javax.sql and Pooling with Tomcat

[Luis Andrei Cobo <va...@megapathdsl.net>]

Is there any known Issues regarding the use of javax.sql package with tomcat
3.1? Im attempting to integrate Poolman with tomcat
(http://www.codestudio.com/PoolMan/index.shtml)
which is a JDBC_2.0 Connection pooling manager which seems to require J2EE
classes or JDBC extentions.

If you've had any experience at all with this, please let me know.

My Current Configuration:

Apache 1.3/Tomcat 3.1 running on LinuxPPC R5 kernal 2.2.14
freetds driver for SQL server on NT (which if I use the standard
Class.forName(driver)) there is no problem ( except the fact that freetds
tends to want to override java.sql so I have to reference java.sql classes
in the long form)
SQL server on NT

Im hoping to integrate a pooling mechanism so as to allow for better garbage
collection overall.

Let me know.

Luis

RE: JDBC javax.sql and Pooling with Tomcat

[Bill Pfeiffer <ws...@tampabay.rr.com>]

I was using PoolMan in my servlet/JSP code to cache my JDBC connections to
MS SQL Server 6.5.  I was using the Jdbc-Odbc bridge for the connection.
This seemed to work fine.  However, when I was testing other jdbc drivers
for sql server (as I need to get a REAL jdbc driver for sql server), I ran
into a snag with it.  It appears that PoolMan does not support the
DriverManager.getConnection () method that takes a Properties object.  Some
of the drivers that I was working with REQUIRED that a properties object be
used to set up driver specific props. I added a couple of lines of code to
the com.codestudio.util.JDBCPool and com.codestudio.util.JDBCInfo classes to
add this functionality.

I recently changed out PoolMan for Minerva.  Minerva is a pooling lib that
comes with jBoss j2ee server, which I use with tomcat.  I figured I would
just take advantage of its pooling capabilites rather than use PoolMan to do
the same work.

BTW, how is the freetds driver working for you?  The last time I looked at
it, it was fairly incomplete.  I still have not found a good (cheap or free)
sql server driver!


Bill Pfeiffer
Arbitration Forums, Inc
wpfeiffe@arbfile.org
pfeiffer@gte.net

-----Original Message-----
From: Luis Andrei Cobo [mailto:valis@megapathdsl.net]
Sent: Sunday, August 13, 2000 12:25 AM
To: tomcat-user@jakarta.apache.org
Subject: JDBC javax.sql and Pooling with Tomcat


Is there any known Issues regarding the use of javax.sql package with tomcat
3.1? Im attempting to integrate Poolman with tomcat
(http://www.codestudio.com/PoolMan/index.shtml)
which is a JDBC_2.0 Connection pooling manager which seems to require J2EE
classes or JDBC extentions.

If you've had any experience at all with this, please let me know.

My Current Configuration:

Apache 1.3/Tomcat 3.1 running on LinuxPPC R5 kernal 2.2.14
freetds driver for SQL server on NT (which if I use the standard
Class.forName(driver)) there is no problem ( except the fact that freetds
tends to want to override java.sql so I have to reference java.sql classes
in the long form)
SQL server on NT

Im hoping to integrate a pooling mechanism so as to allow for better garbage
collection overall.

Let me know.

Luis