db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mag Gam <magaw...@gmail.com>
Subject Re: How to run the Apache DB Torque tutorial with Derby
Date Thu, 06 Oct 2005 10:28:22 GMT
nice tutorial!

On 10/5/05, Jean T. Anderson <jta@apache.org> 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
>
>
>
Mime
View raw message