> It sounds plausible to hold onto the DataSource once you had it.
I do, with PostgreSQL. > And then there is an issue of synchronization? Hmm... You got me thinking there :-) I have always assumed that a DataSource reference retrieved from a JNDI lookup is a singleton - IOW the connection pool created by Tomcat in response to a Context-Resource element in '/conf/server.xml' only contains one DataSource object. If that assumption is correct, then it seems logical to assume that vendor DataSource implementations *must* ensure their 'getConnection' methods are synchronized. But I do not like living with such assumptions (!) so I wonder if anyone might be kind enough to confirm whether or not JNDI DataSource references are singletons? Harry Mantheakis --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]