Transactions?

From: bala_tbn(at)yahoo(dot)com
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Transactions?
Date: 2002-03-07 09:13:54
Message-ID: 200203070913.g279DsQ21196@local.thinkbn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
I have a basic question on JDBC for postgresql.

Here's my scenario.

1) Start a transaction.
2) Get ONE OR MORE connections and perform operations(on different objects).
3) If anyone fails, rollback all the operations, else commit
all the operations.

I read that Postgresql doesn't support distributed transactions.
But that is not a problem for me. We are having all the operations
in the same database. Previously we were using EJB and Oracle and
it was working fine. Now, we have plain Java(not EJB) and postgresql.
So we thought of using some transaction managers like tyrex.
But they ask for JDBC drivers which support transaction(XA, I think).
I dont see any XA related files in JDBC driver I downloaded from
site.(jdbc.postgresql.org).

How to solve this problem?

Regards,
Balakrishnan.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kovács Péter 2002-03-07 10:30:33 Re: Transactions?
Previous Message # sriram # 2002-03-07 07:47:58 Help...Weird errors