Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Katilie, Katilie, John wrote: | Basically, I have a web application that communicates with Teradata | under Tomcat using a DBCP pooled connection. In my context.xml file I | have: [snip] | validationQuery="Select 1" [snip] | Via JNDI we get

RE: Connection Pooling and Teradata

2008-06-18 Thread Katilie, John
er Schultz [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2008 9:46 AM To: Tomcat Users List Subject: Re: Connection Pooling and Teradata -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Katilie, Katilie, John wrote: | Basically, I have a web application that communicates with Teradata | un

Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John, Katilie, John wrote: | Chris, Thanks for your reply. I'll do some more testing. May i ask a | dumb question? How did you turn on your tracing to get: I used the tracing provided by my JDBC driver (Connector/J), so you won't have this exact opt

RE: Connection Pooling and Teradata

2008-06-18 Thread Katilie, John
Regards, John Katilie. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2008 1:16 PM To: Tomcat Users List Subject: Re: Connection Pooling and Teradata -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John, Katilie, John wrote: | Chris, Thanks

Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John, Katilie, John wrote: | Chris, 1st I tried adding log4j.properies [...] Take a look at all the messages running around the list this week about logging. Apparently, it's rocket science. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.

Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John, Katilie, John wrote: | Chris, 1st I tried adding log4j.properies [...] I use log4j, and have it correctly configured to use log4j in my application, so I added: log4j.category.org.apache.tomcat.dbcp=ALL to my log4j.properties file, and that

Re: Connection Pooling and Teradata

2008-06-18 Thread David Smith
There real unfortunate part with regard to log4j is the actual manual has to be purchased. The site docs are horribly lacking. Having said that ... I suspect because the DBCP pool is created by tomcat in tomcat's internal code, it has a different log factory instance and as a result, a diffe

RE: Connection Pooling and Teradata

2008-06-18 Thread Caldarale, Charles R
> From: Christopher Schultz [mailto:[EMAIL PROTECTED] > Subject: Re: Connection Pooling and Teradata > > Perhaps it's because DBCP is loaded by TC before my > webapp, so it's using a differently-configured logger. I believe that's the case - different classloade

Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John, Christopher Schultz wrote: | I use log4j, and have it correctly configured to use log4j in my | application, so I added: | | log4j.category.org.apache.tomcat.dbcp=ALL I followed the instructions on this page (http://tomcat.apache.org/tomcat-5.

RE: Connection Pooling and Teradata

2008-06-18 Thread Katilie, John
, jfk -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2008 4:05 PM To: Tomcat Users List Subject: Re: Connection Pooling and Teradata -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John, Christopher Schultz wrote: | I use log4j, and have it corr