You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by Bob Fleischman <bo...@mindspring.com> on 2005/02/16 05:27:14 UTC
Problem with J2 build and HSQLDB drop table command syntax
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.
Has anyone else noticed this?
Am I doing something wrong?
Bob
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
RE: Problem with J2 build and HSQLDB drop table command syntax
Posted by Bob Fleischman <bo...@mindspring.com>.
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:david@bluesunrise.com]
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
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
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
Re: Problem with J2 build and HSQLDB drop table command syntax
Posted by David Sean Taylor <da...@bluesunrise.com>.
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