I solved the problem. It seems I had maven-torque-plugin-3.1.1-dev.jar. I replaced that with maven-torque-plugin-3.1.1.jar and everything else worked ok.
It was a coincidence that I had the same wrong plugin at my client's site. -----Original Message----- From: Bob Fleischman [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 4:58 PM To: 'Jetspeed Developers List' Subject: RE: Problem with J2 build and HSQLDB drop table command syntax I did a checkout from CVS, in eclipse, just a few weeks ago and then an update last night. I also tried this at a client with a fresh check out and got the same error. -----Original Message----- From: David Sean Taylor [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 12:20 PM To: Jetspeed Developers List Subject: Re: Problem with J2 build and HSQLDB drop table command syntax Bob Fleischman wrote: > When I run the maven allClean allBuild I get the following error: > > [sql] [ERROR] Failed to execute: drop table if exists OJB_HL_SEQ > BUILD FAILED > File...... D:\eclipseworkspace\jakarta-jetspeed-2\maven.xml > Element... sql > Line...... 355 > Column.... 39 > java.sql.SQLException: Table not found: IF in statement [drop table if > exists OJB_HL_SEQ] > > I traced this back to a syntax problem in > target\src\sql\hsql\phase3ojb-schema.sql. > > This file is using > > drop table if exists OJB_HL_SEQ > > HSQLDB Syntax should be > drop table OJB_HL_SEQ if exists. > Strange, my generated HSQL phase3ojb-schema.sql file has: drop table OJB_HL_SEQ if exists; looks like you have MySQL syntax. I don't know why that is... (im working from cvs head) -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
