I wouldn't expect any reasonably current Velocity JAR to have anything to do with these problems. More than likely, your Torque templates are not in sync with your code.
"sbelt" <[EMAIL PROTECTED]> writes: > 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
