tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From p...@shareowner.com
Subject RE: setting up jndi jdbc tomcat and postgres
Date Fri, 21 Feb 2003 15:07:31 GMT
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:awc@drytel.net] 
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: 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message