Re: ConnectionPool example?

["Bharath V.S. Dhurjati" <bharath@xxxxxxxxxxxxxx>]

Just to share what we are doing in our current project:

We have multiple connection pools.
We use a different pool for each library.
Each pool's connections are established one user ID specific to a library.
The user ID used to connect each pool has the appropriate library as the
default/current library.
Thus, if we have N libraries, we have N user IDs and N connection pools,
each with a possibly different # of connections, depending upon usage.
Whenever a request comes in for a specific library, we use the appropriate
connection pool to obtain a connection.

We tried an earlier approach with one connection pool and switching
libraries on the fly after obtaining a connection, but this caused errors
because of open data paths to other libraries. So, this was abandoned.

Did anybody have success with using one connection pool with run-time
library switching, such that a connection can possibly  service more than
one library?

Thanks.

Regards,
Bharath.


----- Original Message -----
From: "Gary L Peskin" <garyp@firstech.com>
To: <java400-l@midrange.com>
Sent: Friday, January 18, 2002 12:06 PM
Subject: RE: ConnectionPool example?


> 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
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>