Re: Transaction handling through java - Mailing list pgsql-jdbc

From Guillaume Cottenceau
Subject Re: Transaction handling through java
Date
Msg-id 87bq0yw943.fsf@mnc.ch
Whole thread Raw
In response to Transaction handling through java  (nalini <nalini@nic.in>)
Responses Re: Transaction handling through java  (nalini <nalini@nic.in>)
List pgsql-jdbc
Hi,

> 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 may be missing something, but it seems to me that the problem
is your application wrongly assuming that queries taking a long
time to finish are assumed to be already committed?

--
Guillaume Cottenceau

pgsql-jdbc by date:

Previous
From: nalini
Date:
Subject: Transaction handling through java
Next
From: Pushker Chaubey
Date:
Subject: Re: Transaction handling through java