tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Gregg" <john.gr...@techarch.com>
Subject RE: JDBC Error
Date Fri, 28 Jun 2002 14:55:11 GMT
I use JDBCPool also.  A sample of what my code looks like is here:

http://marc.theaimsgroup.com/?l=tomcat-user&m=102433567131466&w=2

I obtain a connection like this:

Class.forName(driverName);
conn = DriverManager.getConnection(alias, username, password);
conn.setAutoCommit(false);

Once I set the pool up, I don't futz with it.  My code doesn't even know
there's a pool in use.  The only issue I have with JDBCPool is that it
doesn't pool Statements correctly, IMO, but I don't think that's the cause
of your problem.

john

-----Original Message-----
From:
tomcat-user-return-24384-john.gregg=techarch.com@jakarta.apache.org
[mailto:tomcat-user-return-24384-john.gregg=techarch.com@jakarta.apache.
org]On Behalf Of Roger Maltby
Sent: Friday, June 28, 2002 9:33 AM
To: 'Tomcat Users List'
Subject: RE: JDBC Error



Ralph,

I am using a connection pool manager from BitMechanics ( www.bitmechanic.com
).  The sequence if my handleRequest( .. ) is to call the connection pool
manager to get a connection, run the processQuery ( .. ), and then finally
issue close().

Sound right?  Do you have a connection manager that you would recommend?

Thanks
Roger



--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message