RE: AS400 objects from a connection pool

["Gary L Peskin" <garyp@xxxxxxxxxxxx>]

Chris --

I think your solution, aside from doing your own connection pooling, is to
just use JDBC to call a program at the start of the connection to clear out
the LDA.

Gary

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Price, Chris
> Sent: Monday, May 12, 2003 12:01 PM
> To: 'Java Programming on and around the iSeries / AS400'
> Subject: 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
> 
> _______________________________________________
> 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.
>