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

[David Gibbs <david@xxxxxxxxxxxx>]

At 01:53 PM 3/8/2003, you wrote:
> > > How about invoking a stored procedure that does an ALCOBJ, David?
> > Not an option ... this is a java only application... only AS400 component
> > is the database itself.
> Well, that's a pretty draconian corner you're painting yourself into.  Why
> wouldn't you allow a native stored procedure?  But okay, let's assume that
> you have a valid business reason for not using a native stored procedure.
> There are alternatives.

The main reason is that this is not an AS400 application ... the only thing 
AS400 about it is the database.  The people who develop & maintain this 
code do not understand one lick about the as400.

> If you know you're talking to an AS/400, you can always use the JTOpen
> toolbox to attempt an ALCOBJ command.  This is AS/400-specific, but 100%
> Pure Java.

True ... however (always a however), we have no problem allocating the 
object using the LOCK TABLE sql command ... what I want to do is make OTHER 
sql accesses wait a period of time for the table to be available.  I cannot 
issue a ALCOBJ command every single time I want to access that particular 
table.

> If that option is not valid, then I think you're stuck with an untenable set
> of design decisions - you want to do things differently for the AS/400, yet
> you don't want AS/400-specific code.

Rock & hard place ... rock & a hard place.  I'm just hoping there is a 
little sand I can put between to make it slide a bit.

david