Hi,

I, as a java developer, find myself constantly switching among
different DBMS.

The JDBC easies it greatly, but I am thinking about a Portable DATA
Layer kind of functionality to aliviate the problems when you must do
that.

Notice I am not talking aobut connection pooling or persistence
manager!

Here are some of the problems I would like to rid of my mind:

1._ A change of DBMS should only require a one-line change in a
properties files

DataLayer DL = new DataLayer("_.propeties");


2._ SQL statements should be declared outside the code entirely, so
that admin people and DBAs can look at the damage we devs are doing

3._ Changes in the SQL statements ('We' constantly change the Data
Tables and Structures during dev)
I don't want to have to touch the code if I change the Data layer.
Say, a new column is included in the Table

4._ I would love to query a DBMS like you call a method, without
having to worry about getInt's, and getString's things;

something like:

ResultSetRecordsObjs[] RSO02 = DL.preparedStat("SELECT
...").getRecordObjects();

 Then you would simply go:

 . Request.setAttribute("RSO02Ar", RSO02);

 . grab the array of objects containing the returned records
information in a jSP and display the results.

Notice that only the JSP would have to be changed possibly by a
knowledgable designer.

Do you know of something like that already out there (preferably open
source :-))?