portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bob Fleischman" <bob.fleisch...@mindspring.com>
Subject RE: Problem with J2 build and HSQLDB drop table command syntax
Date Thu, 17 Feb 2005 04:52:07 GMT
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:bob.fleischman@mindspring.com]
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: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




---------------------------------------------------------------------
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