I just tried the latest cvs from jakarta-velocity. I get the same behavior.
Steve B. ----- Original Message ----- From: "Martin Poeschl" <[EMAIL PROTECTED]> To: "Turbine Users List" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 10:59 AM Subject: Re: Torque Outside Turbine - bug? > sbelt wrote: > > > I am using Torque outside of Turbine. I am using a CVS-version from Dec. > > 26th on Linux. I am also using Postgresql as my database. I created my own > > schema.xml which creates 6 tables and several Foreign Keys among them. In > > getting this running, I found 2 issues: > > > > 1) The .sql created by ant adds commas to the end of the last column which > > causes the .sql to fail. For example, torque generated: > > > > drop table table1; > > CREATE TABLE table1 > > ( > > x1 serial, > > x2 varchar (256), > > PRIMARY KEY(x1), <-- this is the troublesome comma > > ); > > > > Postgres does not like the comma after the PRIMARY KEY definition when I run > > this .sql using psql. I got around this by editing the .sql to remove these > > extra commas. Now the .sql works. > > > i'm generating sql with torque multiple times a day for different rdbms .. and it works fine for me > ... which version ov velocity are you using?? try to update your velocity.jar > > > > > > 2) The comments at the end of the generated .sql incorrectly label the > > foreign key defintions. The keys generated for table-3 are labeled as "-- > > table-2". The SQL commands are actually correct (so you do not need to > > modify the .sql if you don't want), it is just the commented labels which > > are incorrect. > > > i'll take a look at this > > martin > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
