RE: AS400 objects from a connection pool

Gary,

I was afraid that would be the answer - I can't see any way of getting a
reference to the pool itself either.

Libraries are not the problem on the JDBC connection, as you can configure
these as a property of the JDBC url. The problem is setting the LDA for a
new connection. (The lda needs to be set as triggers on some files cause
legacy programs to be invoked, which assume the lda is configured. The long
term answer is to code out the lda, but for know we're stuck with it.)

Thanks,
Chris.

 

 -----Original Message-----
From:   Gary L Peskin [mailto:garyp@xxxxxxxxxxxx] 
Sent:   12 May 2003 18:04
To:     'Java Programming on and around the iSeries / AS400'
Subject:        RE: AS400 objects from a connection pool

You need to look here at who is creating the connection.  As far as I can
tell with AS400JDBCConnectionPool, there is no way to get a reference to the
AS400JDBCConnectionPool object from an AS400JDBCPooledConnection contained
in that pool.  This is because there is no reference to the containing
AS400JDBCConnectionPool.  For these, I think you'll have to call
setLibraries each time you work with the DataSource unles your AppServer
tool gives you a way to set these properties ahead of time.

HTH,
Gary