Hi Chris, I agree with you on using container managed connection pool. I have already setup the required configuration to use container connection pool.
But I am still wondering, if there was connection timeout and the first user gets an error. Why should the whole application go down? I mean no other user can use the application after the error. Any idea on this? Thanks Uma On Dec 13, 2007 3:38 AM, Christopher Schultz <[EMAIL PROTECTED]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Uma, > > Uma Kalluru wrote: > > I am using Struts1.x with Tomcat 5.5 and I see lots of problems in the > > log file. Actually I am using Struts data source manager to create > > connection pool at the startup of the server. > > It's a bit off topic, but you should stop doing that. Struts stopped > supporting DataSource configuration /years/ ago in favor of > container-manager data sources. > > > The application works fine for some time but after some time the > > connection object is null. I am not sure how this would happen. Can > > any one help me out please? This is urgent. > > Your pooled database connections are probably timing out. After the > first error, do you get continuous errors afterward, or do the > connections reconnect or anything like that? > > Your best bet is to configure your data source through Tomcat. See > http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html > (specifically, the "Context Configuration" section) for a simple example > of how to enable container-managed data sources. Just put the <Resource> > element into your META-INF/context.xml file (you /are/ using a > META-INF/context.xml file, right?!). Remember to set a "validation > query" so that connections will be tested for connectivity before they > are handed over to your application. > > - -chris > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.7 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFHYFv49CaO5/Lv0PARAjOpAKCeXoGIO6GN6ASHcRZ1SMU2zXr4fwCeLDCs > q/80HzjltPsB0Er2AgTqw5s= > =no2p > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]