lock problem when dont commit

Поиск
Список
Период
Сортировка
Искать
От
Mican Bican
Тема
lock problem when dont commit
Дата
Msg-id
915cd3880503021437382b001e@mail.gmail.com
Список
Дерево обсуждения
lock problem when dont commit Mican Bican <mican58@gmail.com>
Re: lock problem when dont commit Dave Cramer <pg@fastcrypt.com>
Re: lock problem when dont commit Tom Lane <tgl@sss.pgh.pa.us>
Re: lock problem when dont commit Dave Cramer <pg@fastcrypt.com>
Re: lock problem when dont commit Tom Lane <tgl@sss.pgh.pa.us>
Re: lock problem when dont commit Mican Bican <mican58@gmail.com>
Re: lock problem when dont commit Dave Cramer <pg@fastcrypt.com>
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 по дате отправления
От: Jan de Visser
Дата:
Сообщение: Re: Some Questions about JDBC
От: Dave Cramer
Дата:
FAQ