portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Sean Taylor <da...@bluesunrise.com>
Subject Re: Problem with J2 build and HSQLDB drop table command syntax
Date Wed, 16 Feb 2005 17:20:28 GMT
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
david@bluesunrise.com
[office] +01 707 773-4646
[mobile] +01 707 529 9194

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message