I guess it is there to keep physical connection alive. Regards, PQ "This Guy Thinks He Knows Everything" "This Guy Thinks He Knows What He Is Doing"
-----Original Message----- From: awc [mailto:[EMAIL PROTECTED]] Sent: February 21, 2003 9:28 AM To: Tomcat Users List Subject: Re: setting up jndi jdbc tomcat and postgres Hi Chris, where does this validationQuery goes?? on every connect?? Thanks .anil Chris Catton wrote: > The tomcat documentation on jndi and datasources > http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples > -howto.html asks for feedback on setup with postgres. We finally got > it working using java 1.4, tomcat 4.1.18 on linux, postgres 7.2.1 on > linux with pg73jdbc2ee.jar. The instructions miss one crucial thing - > on our system we were getting a datasource created, but on trying to get > a connection from the datasource the system seemed to hang. A look at > the postgres log showed repeated attempts to connect. Problem > eventually solved by putting 'select 1;' in the validationQuery > > Seems the postgres driver wants the database to confirm the connection > is valid before handing it back .. > > Hope this saves someone else some headscratching - pls stick it in the > docs! > > C > > > > Chris Catton > BioImage Database Development Manager > Department of Zoology > University of Oxford > OX1 3PS > > Tel: +44 (0) 1865 281993 > email: [EMAIL PROTECTED] > web site: www.bioimage.org > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
