tested with MySQL and looking for others to review & suggest.

We have been getting pretty frustrated at having to setup OJB, rewrite the 
repository and java files every time an architecture change is made.


We sat down and tried to come up with a 'nice' way of doing it.

the factors considered were:
 versioning of the schema

 regeneration of the SQL schema / database initialization
 non-clobbering of code
 non-clobbering of manual repository.xml additions.

 obvious compile errors when schema changes result in OBJ object 
  definition changes

 portability


AutoBaseJDBCSchemaDumper:
 converts JDBC's DatabaseMetaData to XML
 it annotates some fields to make xsl stuff easier

AutoBaseInterface.xsl:
 this creates a java file which can be used for proxy, etc.

AutoBaseObject.xsl:
 this creates a java file which can be subclasses / instantiated

AutoBaseRepository.xsl:
 this creates a repository.xml fragment

AutoBaseSQL.xsl:
 this creates a SQL script of create tables, etc
 [ not done yet ]




http://www.pyerotechnics.com/products/AutoBase.tgz




-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                   http://www.pyerotechnics.com   -
- Partner & Sr. Manager         Pyerotechnics Development, Inc. -
- +1 (443) 451-2697             500 West University Parkway #1S -
- +1 (410) 808-6646 (c)         Baltimore, Maryland  21210-3253 -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to