Transaction handling through java
- From: nalini <nalini(at)nic(dot)in>
- To: pgsql-jdbc(at)postgresql(dot)org
- Subject: Transaction handling through java
- Date: Wed, 16 Jul 2008 12:21:43 +0500
- Message-id: <5b2b89135586bc69.487de7d7@nic.in> <text/plain>
I am facing the following problem.
Our application sends a block of queries to postgres in a begin end block. If one of the queries take a long time to finish the whole transaction is assumed to be committed by the application even though the query is still running . This results in failure of all subsequent transactions.
Although the application is programmed to catch all exceptions , it somehow is not able to figure out that the transaction is still not complete.
I am using postgres 8.3
with regards
Nalini
Home |
Main Index |
Thread Index