Mag Gam wrote:
nice tutorial!
I agree -- it's very nicely laid out and easy to follow (and actually
turns out to be a terrific maven tutorial at the same time). I
especially like how they add a link for each step to a wiki page for
feedback.
context that dropped out of this thread;
http://db.apache.org/torque/releases/torque-3.2-rc2/runtime/tutorial/index.html
-jean
On 10/5/05, Jean T. Anderson <[EMAIL PROTECTED]> wrote:
Jean T. Anderson wrote:
...
======
Step 3
======
...
--------------------
Creating the tables
--------------------
There's an issue with the project-schema.sql script that torque generates;
it creates a BOOK table that references two tables that don't exist yet
(publisher and author). You could edit the file to swap the CREATE
statements
around, or run the table creates twice. I'll mention this issue to the
torque developers.
Actually there's a natural solution for this that doesn't require any
hacks. Step 2 specifies the schema in the src/schema/project-schema.xml
file. It looks like Torque generates DDL for those objects in order. I
moved the BOOK definition to the end of project-schema.xml and, voila,
the SQL generated works well in derby without hacks.
-jean
