Postgres Pro
Downloads
Home   >   mailing lists

commit after select - Mailing list pgsql-jdbc

From bob1234@pi.be (Bob Bie)
Subject commit after select
Date
Msg-id 3f58d24f.0404040924.16134fe4@posting.google.com
Whole thread Raw
Responses Re: commit after select  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Tree view 
Hello,

I'm writing a java program that uses transactions. For this reason I
turned of the autocimmit in java (sqlConnection.setAutocommit(false);)
This seems to work but now he also seems to lock the tables when I
only do a select. I can solve this bij doing a commit after each
select.

I only want to know if it is normal that I have to do a commit after a
select.
I use java 1.4.2_01 and postgres 7.3. The jdbc driver I use is called
pg73jdbc3.

Thanx in advance,
Bob

pgsql-jdbc by date:

Previous
From: jeff@amiel.net (Jeff Amiel)
Date:
Subject: Re: what is lslowing me down? JDBC or Postgresql itself?
Next
From: "brandon s"
Date:
Subject: Connection Pooling, JDBC and SSL