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]
