To interfaces,
Could you guys include link to
Osage Persistence Plus XML
http://osage.sourceforge.net on your interfaces page.
A description from the web page follows:
--------------------------------------------
JDBC-based object-relational mapping that allows
experienced Java developers to quickly implement
database access in their applications. It generates
SQL for retreiving, saving, and deleting objects.
Osage provides a mapping of objects to a JDBC
relational database. Using the mapping, you may
implement object relationships. The system can be
configured to automatically generate keys. It
implements the criteria, mapping, and SQL statement
classes described by Scott Ambler in his white paper
<a
href="http://www.ambysoft.com/persistenceLayer.pdf">
The Design of a Robust Persistence Layer for
Relational Databases</a>.
------------------------------------------------------
It's mostly a system to allow using mapping to replace
SQL programming.
It's similar in concept, but more low-level and less
fully featured (on OQL), to castor's
(castor.exolab.org) JDO.
I don't know of another open-source, free
Obejct-to-Relational mapping system that uses class
maps dynamically. Enhydra's DODS uses inheritance and
code generation to statically generate sql.
It allows use of multi-keys, transactions spanning
various db. Objects can span dbs too, but simple
types of any class must be from 1 db. Simple types
may span tables so you can model views.
Of course, I use PostgreSQL for my development and
Peter Mount's JDBC driver.
Regards, george
__________________________________________________
Do You Yahoo!?
Yahoo! Mail � Free email you can access from anywhere!
http://mail.yahoo.com/