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

David,

I havent tried this yet myself, but what about using JTA?  The following
link focuses on destributed transactions, but has some possibilities:

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzaha/distrans.htm

Note the section discussing setLockTimeout and setTransactionTimeout.  Looks
promising.


Alex Garrison

----- Original Message -----
From: "David Gibbs" <david@xxxxxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Saturday, March 08, 2003 11:03 AM
Subject: How to get JDBC to DB2400 to wait on a locked object?


> 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
>
>
>
> --
> | Internet: david@xxxxxxxxxxxx
> | WWW: http://david.fallingrock.net
> | AIM: MidrangeMan
> |
> | We're not in the middle of nowhere...
> |   we're on the outskirts of everywhere!
> | - DMRoth (adapted)
>
>
>
>
>
>
>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>