You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Jakub Piechnik <pi...@wp.pl> on 2005/11/12 23:54:58 UTC
SQL generated schema
Hello
I've created scham.xml file - and invoked "maven torque" command - I saw
BUILD SUCCESSFUL, so I thought that everything'd gone oki. But when I
tried to execute sql scripts genereted by torque I've got full of errors
- especially when it comes to the table name - and finally there're 9
out of 12 tables created in my database. Has anyone had such bug before
- if so - how to solve it?
Greetings
Jakub Piechnik
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: SQL generated schema
Posted by Jakub Piechnik <pi...@wp.pl>.
Hi
I managed to deal with this error - it wasn't torque fault. Sorry for interrupting.
Greetings
Jakub Piechnik
Dnia 14-11-2005 o godz. 10:30 Thomas Fischer napisał(a):
>
>
>
>
> Hi,
>
> As you did not provide details of the sql errors, just a wild guess:
> Some template sets for databases do not allow forward declarations on
> foreign key. So you have to make sure that the referenced table is before
> the referencing table in the schema.xml
>
> If this is not the cause of the error, it would really help to know the
> Torque version you use and the message of the sql error when the tables
> are
> created.
>
> Thomas
>
> Jakub Piechnik <pi...@wp.pl> schrieb am 12.11.2005 23:54:58:
>
> > Hello
> >
> > I've created scham.xml file - and invoked "maven torque" command - I
> saw
> > BUILD SUCCESSFUL, so I thought that everything'd gone oki. But when I
> > tried to execute sql scripts genereted by torque I've got full of
> errors
> > - especially when it comes to the table name - and finally there're 9
> > out of 12 tables created in my database. Has anyone had such bug before
> > - if so - how to solve it?
> >
> > Greetings
> > Jakub Piechnik
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
----------------------------------------------------
Moscow City Ballet - od 29 listopada do 27 grudnia w Polsce,
sprawdź czy także w Twoim mieście - Kliknij:
http://klik.wp.pl/?adr=http%3A%2F%2Fadv.reklama.wp.pl%2Fas%2Fmcb11.html&sid=569
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: SQL generated schema
Posted by Thomas Fischer <fi...@seitenbau.net>.
Hi,
As you did not provide details of the sql errors, just a wild guess:
Some template sets for databases do not allow forward declarations on
foreign key. So you have to make sure that the referenced table is before
the referencing table in the schema.xml
If this is not the cause of the error, it would really help to know the
Torque version you use and the message of the sql error when the tables are
created.
Thomas
Jakub Piechnik <pi...@wp.pl> schrieb am 12.11.2005 23:54:58:
> Hello
>
> I've created scham.xml file - and invoked "maven torque" command - I saw
> BUILD SUCCESSFUL, so I thought that everything'd gone oki. But when I
> tried to execute sql scripts genereted by torque I've got full of errors
> - especially when it comes to the table name - and finally there're 9
> out of 12 tables created in my database. Has anyone had such bug before
> - if so - how to solve it?
>
> Greetings
> Jakub Piechnik
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org