RE: Java and Relations DBs..

["Richards, Etienne (CAP, PTL)" <Etienne.Richards@xxxxxxxxxx>]

Brad,

The connection pool API is defined by SUN. You do find different
implementation of this api and as long as they conform to the SUN standard
then you will not be tied to any single application server. We are running
the same code on the AS/400 using WebSphere and TomCat while only changing
the initial context that is used for the connection pool lookup. This shows
you that it is not going to tie you to any single application server.

Sun has a few samples of using JNDI and everything else you would require to
write your own connection pool. I could not find the link because I know it
is there, I have used it when writing my own (Just for fun).

Another thing to remember is that the WebSphere connection pool also
implements the caching of prepared statements which makes a very big
difference when you have queries that are executed more than once. If you
prepare the same query (select * from table where name = ?) then it will
only prepare the statement once for that connection. The next time you
execute that even if ? has a different value then it would not have to
prepare it again.

Etienne

-----Original Message-----
From: Brad Stone [mailto:brad@bvstools.com]
Sent: Wednesday, January 09, 2002 4:09 PM
To: java400-l@midrange.com
Subject: Re: Java and Relations DBs..


>
> Check out WebSphere.  I lose track of all the
> distinctions involved between
> the various levels of the product (since I don't have to
> pay for it ;-) ),
> but I think you'll find connection pooling is available
> in WebSphere and
> probably at all levels of it.
>

I would, but I don't want my applications to rely on
Websphere or any other package.  I want to make sure they'll
work (at least sufficiently) on all apps.  A smaller shop
may not have those resources, and use something like what I
am with MSAccess as the DB.

So I guess what I'm asking is, will it hurt anything if I do
write my own pooling procedures and the driver I'm using
already impements pooling?

I understand as the data grows, the performance will suffer,
but that is the case with almost any application (although I
must admit RPG and the iSeries do a pretty good job, since
the DB is so nice).
_______________________________________________
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.