Re: Java and Relations DBs..

["Brad Stone" <brad@xxxxxxxxxxxx>]

Let me see if I can try and describe my dillema...

They applications has a minimum of three layers..

1.  Data layer - This layer is used to retrieve data from
databases and return a result set to the caller.
2.  Container layer - This layer calls the data layer and
users the result sets returned to fill the containers
3.  Application layer - This layer user only containers.  It
knows nothing of the data layer, result sets, SQL objects,
databases, connections, connection pools, etc.

So, application code would look something like this..

MyContainer mc = new MyContainer();
mc.load();

The container code would look something like this:

public void load() {
//build and SQL Data Set
//Retrive the result set form the data set
//fill the container
}

And finally, the SQLDataSet code does all the connecting to
the DB, query running, etc.  (John Taylor, it's the one you
helped me with..)

You'll have to excuse me if I get frustrated with this.
Because it seems every time you want to do something, it
involves yet another layer.  :)