Tuesday, May 14, 2002 02:09 AM
Object to relational mapping is a quite well improved technique, so, getting benefits of relational database performances (for object persistency, like EJB) is not a bad idea, although I think Access is not the best (compared to Oracle, MySQL...).
I know two products, by ObjeXion
(but many others exists; see the OMG site
) that will make this for you. Model prototyper reads a Rose class diagram and turns it into an Access database; then Facsimile allows object creation / modification / destruction with a classic GUI or a COM interface.
Netsilon is more web-oriented in that it can generate PHP, Servlet or JSP, using databases MySQL, Oracle or PostgreSQL. You can imagine generate (full java code) only for class diagrams and use generated classes that will be auto-persistent in the database. You can also generate a web interface for object administration. Contact support at objexion.com for more informations.