Re: How to get JDBC to DB2400 to wait on a locked object?

[Dieter.Bender@xxxxxxxxxxx (Dieter Bender)]

Hi,

the java way would be:

use transaction isolation level serializable, that will put a write lock to 
the tables used in the transaction

as a conclusion all transactions with isolation level >  read uncommitted 
will wait untiol the locking transaction releases the locks

the wait time depends on the database (as400: waitfile - default *immed and 
waitrecord default 60) and maybe on your driver.

Dieter

On Saturday 08 March 2003 18:03, you wrote:
> Anyone know if it's possible to configure a JDBC connection to DB2400 so
> that, if a table has an exclusive lock, the database server will wait for a
> certain amount of time before returning a "Table in use" error (SQL0901)?
>
> I want to place an exclusive lock on a table while I alter it ... and I
> want any other connections that attempt to access it to wait for a little
> while before returning the error.
>
> Basically, I want to do the same as the OVRDBF WAITFILE parameter does.
>
> Thanks!
>
> david

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de