John R Pierce wrote:
> I'm curious what common practice is for threads that do nothing but
> SELECTS... do folks just enable auto_commit, thereby preventing pgJDBC
> from doing BEGIN; ? Do they lace their code with COMMIT() calls?
We were bitten by this problem too, and my solution was to suggest our
developer to do and explicit: "ABORT" after the connection, and do
explicit "BEGIN" "END" instead of rely on the jdbc interface.
Regards
Gaetano Mendola