RE: ConnectionPool example?

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

David --

I think the piece that you're missing is that
AS400JDBCConnectionPoolDataSource extends AS400JDBCDataSource.  This
crucial piece of information is not mentioned in the javadoc.  What it
means is that you can call any of the AS400JDBCDataSource methods on
your dataSource object.

I'd do this before your create your AS400JDBCConnectionPool.  Just
include a statement like:

  dataSource.setLibraries("*LIBL MYLIB");

Of course, you can call any of the other AS400JDBCDataSource methods as
well.

HTH,
Gary



> -----Original Message-----
> From: java400-l-admin@midrange.com
> [mailto:java400-l-admin@midrange.com] On Behalf Of David Gibbs
> Sent: Friday, January 18, 2002 8:40 AM
> To: 'JAVA400 List'
> Subject: RE: ConnectionPool example?
>
>
> > Does anyone have a good example of using a ConnectionPool
> for JDBC to
> > the 400?
>
> I think I can narrow my question down a bit... I think I've
> got the basics for the connection pool, but have a specific
> question...
>
> Here's my code...
>
> ----------
> AS400JDBCConnectionPoolDataSource dataSource =
>       new AS400JDBCConnectionPoolDataSource(
>       systemName, userid, passwd);
>
> AS400JDBCConnectionPool pool =
>       new AS400JDBCConnectionPool(dataSource);
>
> pool.fill(10);
>
> Connection c = pool.getConnection();
> ----------
>
> Ok, this code will create a data source and connect it to a
> connection pool for the specified system, using a userid & password.
>
> How do I specify the library my data lives in?  If I just use
> a jdbc url, it's easy to specify the library (library list).
>
> All I want to do is pre-establish a connection to a database
> (or system) so my JDBC requests are faster.
>
> Any suggestions would be appreciated.
>
> Thanks!
>
> david