[sql] DAO pattern?

[Neeme Praks <ne...@apache.org>]

http://java.sun.com/blueprints/patterns/DAO.html

I would be interested in implementing the DAO pattern for commons-sql:
* based on database schema, generate:
     * bean interfaces
     * simple bean implementations (private fields, getters and setters)
     * optionally also abstract classes for entity beans (v2)
* based on some query descriptor, generate:
     * factory interfaces
     * factory implementations: OJB,Torque,hibernate,entity beans v2...

This would allow people to use more-or-less pluggable persistence APIs. 
I'm currently considering converting by applications from Torque to OJB, 
so I'm probably going to implement this anyway...

Would this be in the scope of the commons SQL project?
As this is kind of persistence abstraction (e.g. commons-logging), then 
I guess it seems to be a fit for commons, no?

Any pointers are helpful, as there seems to be zero docs available 
currently (only docs I could find were copy-paste from torque). I saw 
that there are a bunch of jelly scripts for DDL generation, but how do 
they actually integrate with the rest of the stuff and how do I invoke 
them...?

Rgds,
Neeme


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org