lock problem when dont commit
От | Mican Bican |
---|---|
Тема | lock problem when dont commit |
Дата | |
Msg-id | 915cd3880503021437382b001e@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: lock problem when dont commit
|
Список | 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
В списке pgsql-jdbc по дате отправления: