Re: JDBC executeBatch() hangs without error

Hi,we found that *operations affecting triggers require exclisive lock on the
related tables*.We got FE=>Sync hang up problem and looked exactly like you
described here. It should not be a network issue. It can be reproduced on
both windows and linux platforms. However, our script was dropping and
(re)creating triggers and not a batch insert that you reported here
earlier.The solution was to * *close the current connection* to postgres*
establish a new one and run the script to modify the triggers* at the end
*commit and close the connection** establsih a new connection to continue
the work.I post our solution here because this is the most recent thread on
this topic which I've found. I hope this can help others with this magic
connection hang.Cheers,L

--
View this message in context: http://postgresql.1045698.n5.nabble.com/JDBC-executeBatch-hangs-without-error-tp5772465p5791393.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.