Re: Java and Relations DBs..

["Bruce Jin" <JIN007M@xxxxxxxxxxx>]

Many systems have built in connection pool (such as Websphere). Connection
pool is also very simple to program. I wrote my own. But here is one that is
ready to use

 http://archive.coreservlets.com/coreservlets/ConnectionPool.java

 Bruce



----- Original Message -----
From: "Brad Stone" <brad@bvstools.com>
To: <java400-l@midrange.com>
Sent: Wednesday, January 09, 2002 12:02 PM
Subject: Re: Java and Relations DBs..


> > You don't know that for sure.  It depends on a couple of
> > things:
> >
> > 1.  Whether you have a WHERE clause or not in your query.
>
> Yes, there is a where clause.  I can see why this would slow
> things down.
>
> >
> > 2.  Internal details of the data base and who implemented
> > what inside the
> > DB itself.
>
> It's a single table.  What would the rest of the DB have to
> do with it?  Or are you talking about indexes, and the like
> on the single table?  Or does DB=Table in this case (see, I
> called a table a DB on the iSeries too, but since it's
> confusing in the Java world, I try to stick to more
> "worldly" terms.. <bg>)
>
> I believe my biggest bottleneck, as David mentioned, is
> probably opening and closing a connection each time.  Since
> i'm accssing an Access DB I use an ODBC bridge.. not the
> best way to do things, but when it's all you've got to play
> with, it has to do.
>
> I've looked at connection pooling in the past, and see how
> it would help.  But, since it seems there are so many
> implentations of pooling, and how it could be built into the
> drivers, it's something that I don't care to get into.  No
> doubt should be handled by the Java environment, IMHO, and
> probably will one day.
>
> So do I really want to write pooling classes?  No.  May I
> try?  Yes, if decent examples could be found.  :)
> Implementing should be fairly easy and trasparent to the
> rest of my applications.
> _______________________________________________
> 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.
>
>