You may also want to put in a validation query, it adds overhead, but it forces a reconnection.. I had a similar problem with postgres where the pooled connections didn't know they were no longer properly connected. By adding the validation query, it forces the manager to verify connection before handing the connection down to the requesting code.
-Art -----Original Message----- From: Philipp Taprogge [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:47 AM To: Tomcat Users List Subject: Re: Tomcat reconnect to database server? Hi! I don't know MSSQL in particular, but in princible it should be as simple as adding ?autoreconnect=true to the driver URL. Phil Derek Mahar wrote: > How can I configure Tomcat 5.0.16 to reconnect to a Microsot SQL > Server after a server restart? I have configured Tomcat to use JNDI > datasources (through <Resource> and <ResourceParam> elements within > <GlobalNamingResources>). I presume that at startup, Tomcat connects > to the server and creates a pool of connections for later use. > However, when we restart our server, Tomcat loses its connection(s) > and does not re-establish these connections. -- And on the seventh day, He exited from append mode. (Book of create(2), line 255) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
