|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
