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]