Re: Java and Relations DBs..

["John Taylor" <jtaylor@xxxxxxxxxxxx>]

Brad,

Have you considered creating an "SQLManager" class that is responsible for
maintaining your connections, and constructing and returning SQLDataSet
objects as required?


John Taylor

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


> Ok, here's my question now.
>
> To create a container, I return a result set to the
> container class from an "SQLDataSet" class.  This SQL class
> does the query and returns the result set so I can load my
> container class.
>
> I'm finding that (and suspected this) that connection
> pooling really isn't helping me here.  Since I create a new
> SQLDataSet class for each creation of the container.  This
> means a new connection pool is created each time, etc.
>
> Any hints?