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 <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
>>
>>
>>
|