JDBC transactions

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC transactions
Date: 1998-01-07 14:08:50
Message-ID: l03110703b0d93b50fe62@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I wanted to make sure before I attempt it:

If I'm using the JDBC driver, I don't have to use explicit transaction
calls. That is, I don't have to sent the statements "BEGIN TRANSACTION" and
"END".

Instead, I have to do con.setAutoCommit(false), and then, the next SQL call
will initiate a transaction, which I end by using con.commit() or
con.rollback().

That's the documented behavior of JDBC, and what I'm asking is whether (a)
I'm correct in my interpretation, and (b) whether the current JDBC driver
provided with PostgreSQL 6.2.1 in fact behaves like this.

Herouth

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Constantin Teodorescu 1998-01-07 14:30:19 Re: [QUESTIONS] pgaccess (libpgtcl) on Solaris?
Previous Message The Hermit Hacker 1998-01-06 14:56:24 New Mailing List/Newsgroup