Re: Java and Relations DBs..

["Brad Stone" <brad@xxxxxxxxxxxx>]

Thanks, Bruce.  I'll check it out!

Brad

On Wed, 9 Jan 2002 15:14:45 -0800
 "Bruce Jin" <JIN007M@hotmail.com> wrote:
> 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.
> >
> >
> _______________________________________________
> 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.
>

Bradley V. Stone
BVS.Tools
www.bvstools.com