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]

Reply via email to