Hi Erik,
Do you do anything in your build process to set up the equals() method, or
sequence names? Am having difficulty automating this...
cheers,
David
|---------+------------------------------------------>
| | Erik Wright |
| | <[EMAIL PROTECTED]> |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | ceforge.net |
| | |
| | |
| | 08/10/2004 09:28 AM |
| | Please respond to |
| | middlegen-user |
| | |
|---------+------------------------------------------>
>------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| 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
-------------------------------------------------------
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
