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]
