Kostas Karadamoglou wrote:
Hello,

I am new to Derby and to Transactions in general.

I want to perform some tasks to my databases using one thread and lock the table that it uses from the remaining threads.

You may achieve what you want by proper usage of transaction isolation levels, instead of explicitly locking an entire table. This, of course, depends on what your application is trying to do. Anyway, if you are planning to read some literature on transactions, "isolation levels" should be on your menu.

--
Øyvind Bakksjø
Sun Microsystems, Database Technology Group
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43419 / +47 73842119, Fax: +47 73842101

Reply via email to