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
