tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From awc <...@drytel.net>
Subject Re: setting up jndi jdbc tomcat and postgres
Date Fri, 21 Feb 2003 14:28:12 GMT
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: chris.catton@zoology.oxford.ac.uk
> web site: www.bioimage.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message