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
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 |