I've just posted to the patches list, a patch that finally brings Thread
safety to the driver.
This is mainly of use for Servlet authors, as they don't need to manage a
pool of open connections any more, but they can use a single connection
without the risk of the backend getting confused.
The patch accomplishes this by syncronising network activity to the
PG_Stream object, which is unique for each active connection. Both the
Connection.ExecSQL() and FastPath.fastpath() methods do this, and so far,
my tests haven't yet broken it.
Peter
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf