Yup, running a DB in standalone/embed mode would work well, and I am doing so in production (my choice is McKoi, waiting for Cloudscape to be accepted/mature in open-source world outside of IBM). Hsql, McKoi, and Cloudscape for java-compatible. Would recommend McKoi or Cloudscape, issues with HSQL related to compound primary keys (more HSQL than Middlegen). If you want a little extra omph, also look at http://mogwai.sourceforge.net/ ERDesigner for modelling the standalone/embed java database file that you can keep with your project and from the modelling tool generate the DDL's for other database types (or commercial equiv DB modelling tool).
-D > -----Original Message----- > From: Erik Wright [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 10, 2004 9:29 AM > To: [EMAIL PROTECTED] > Subject: Re: [Middlegen-user] Using sql files instead of the DB itself > > > You could always load the SQL into a temporary schema/database, or a > Cloudscape/HSQLDB in-memory DB or something, and then point > Middlegen at > that. > > Our build process connects to Oracle, creates a user for the developer > performing the build (suffixes the user name with > '_${env.USER}'), which > automatically creates a schema for them, then connects as > that user and > inserts our schema via a SQL script. All that's left at that > point is to > run Middlegen. > > But if you don't have that kind of flexibility with your actual DB > platform, I suppose you could run a DB locally, either a Java > one (which > might be easier to configure as part of an integrated build) or MySQL, > PostgreSQL, etc. > > -Erik > > On Tue, 2004-08-10 at 01:36, Jonathan Scott wrote: > > Hi All, > > > > I am wondering if it is at all possible to read tables from > a SQL file instead of from the DB itself. The point being > that the SQL files will tell us the current structure of the > DB better than a possibly out of date schema, built only who > knows when. > > > > If there is such a way to get the schema from files instead > of the DB, please advise on how to do it, or where to look on > how to do it. > > > > Much appreciated, > > Jonathan Scott > ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
