Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group