dbgate is free, open-source object relational mapping framework that provides complete control over how the persistence/retrieval takes place at entity level.
dbgate does this by means of overriding/implementing methods provided in the base entity classes.
In addition, dbgate can be set to be smart, where it can handle core functions of a modern ORM like data integrity checks/change tracking.
dbgate is a cross-platform utility capable of running on any operating system that comes with Java support (e.g. Mac OS X, Windows, Linux).
Detailed instructions on how to install and use the dbgate utility on your Mac are available HERE.
Here are some key features of "dbgate":
· Core relationships (One to One, One to Many, Inheritance)
· Change tracking
· Data verification on persisting
· Lazy loading
· Data migration
· Strong query language
· Parallel operation with multiple databases
· Cam be easily used with legacy databases
Requirements:
· Java