lock problem when dont commit

From: Mican Bican <mican58(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: lock problem when dont commit
Date: 2005-03-02 22:37:47
Message-ID: 915cd3880503021437382b001e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello

I use postgresql 8.0.1 under windows and jdbc3 with new java tiger...

i work on a database with manuel commits and rollback..

my problem is when 2 people work in on the same time on the database:

---table liefAdress-------------

pseudecode

client1:
...
conn.setAutoCommit(false)
insert into liefAdress(adress,postcode)
//id is autoincrement
insert into liefAdress(adress2,postcode2)
....

client2:
insert into liefAdress(adress3,postcode3)

--->here is the problem user1 dont commit his
transactions.. the client software are locked..
you can do nothing in the programm..!!

client1:
conn.commit()
//all the adresses are inserted

client2:
the adress is also inserted and the
java clientsoftware is unlocked...!

my question is why the java programm from client2 is locked???
can I say to the connection "when you must wait for the commit of the
other users
bring me a warning" or why the row from client2 are not inserted???? I
dont lock everything.. must i change the transaction mode?? I use the
default transaction mode..

thank you for your answers!!!

Mican Bican

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-03-02 23:24:47 Re: lock problem when dont commit
Previous Message Jan de Visser 2005-03-02 17:55:38 Re: Some Questions about JDBC