Subject Re: [Firebird-Java] Can you use PreparedStatements together with connection pooling?
Author Mark Rotteveel
> In theory it should work to some extent. JDBC specification requires
> every driver to support multithreaded access to one connection. This is
> also implemented in Jaybird, but there were also reports of some
> NullPointerExceptions under heavy load, which might be related to the
> multithreaded access (though none of these issues can be reproduced
> under normal load, so most likely many factors are responsible for that).

I recently looked at that piece of code to see if I could reproduce it. I haven't been able yet, but the synchronisation there looks iffy (especially because for some classes the getSynchronisationObject() returns a new object on every call (if the connection is autocommit I believe).
-- - Österreichs FreeMail-Dienst mit über 2 Mio Mitgliedern
E-Mail, SMS & mehr! Kostenlos: