Hi Ng,

still the old object persistency problem. I'd like to have generator
support for accessing rdbm's.
Maybe some of you can give me a hint what to use.

I've allready looked at several projects like
- OTL,
- DTL (would be nice if it worked with postgres)
- sqlWraped / sql2class
- soci
- mygeneration
- Libodbc++
but none of them seemd to fit perfectly :-}

The tool or toolchain should (as a ideal solution :-) generate the
following from a Data-Dictionary or any other kind of meta-data repository:

- ddl (create/drop/alter table, indexes,foreign keys) for different
target rdbm's.
- c-Structs or c++ classes (flat) representing the table layout.
- access-methods to the tables for select,insert,update,delete with
paramterized where conditions (preferably via odbc)
- for types like: int,short,bool,varchar,timestamp including NULL's
maybe enum's
- need to handle multiple dbm-connections in one process (no embedded sql)
- loosing the db-connection should be recoverable
- lib or generator should be stable for win32 and linux.
- nice to have: user defined templates for the generator to adjust output
- nice to have: gui based design tool like mysql-Workbench
- nice to have: strawberry-taste


Maybe i have to write a generator myself. In that case: does somebody
know a powerfull and easy to use template engine?

Regards,

Michael

btw: i didn't find a faq for this ng