You are viewing a plain text version of this content. The canonical link for it is here.
Posted to graffito-dev@incubator.apache.org by "Andreas Weder (JIRA)" <ji...@apache.org> on 2006/10/05 15:03:19 UTC

[jira] Created: (GRFT-107) Maven goal "allDeployHead" fails for HSQL db

Maven goal "allDeployHead" fails for HSQL db
--------------------------------------------

                 Key: GRFT-107
                 URL: http://issues.apache.org/jira/browse/GRFT-107
             Project: Graffito
          Issue Type: Bug
          Components: Project Build
         Environment: Windows XP SP2, Java 5, current trunk of Jetspeed2 (rev.  452795), current trunk of Apache Graffito (rev. 451266)
            Reporter: Andreas Weder
            Priority: Blocker


Running "maven allDeployHead" fails with the following error:

db.create:
db.execute:
    [echo] Execute SQL script : ./target/src/sql/hypersonic/graffitostore-schema
.sql -- ON ERROR = abort
    [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\target\sr
c\sql\hypersonic\graffitostore-schema.sql
    [sql] 31 of 31 SQL statements executed successfully

db.execute:
    [echo] Execute SQL script : ./src/sql/GraffitoServer/insert-db.sql -- ON ERR
OR = abort
    [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\src\sql\G
raffitoServer\insert-db.sql
    [sql] 9 of 9 SQL statements executed successfully


db.execute:
    [echo] Execute SQL script : ./src/sql/GraffitoServer/delete-j2-security.sql
-- ON ERROR = abort
    [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\src\sql\G
raffitoServer\delete-j2-security.sql
    [sql] [ERROR] Failed to execute: DELETE FROM PRINCIPAL_PERMISSION WHERE PRIN
CIPAL_ID = 6 AND PERMISSION_ID =  20

BUILD FAILED
File...... c:\Projects\Apache_Graffito_trunk\maven.xml
Element... maven:reactor
Line...... 197
Column.... 28
Unable to obtain goal [db.reinit.production] -- c:\Projects\Apache_Graffito_trun
k\components\maven.xml:294:38: <sql> java.sql.SQLException: Table not found in s
tatement [DELETE FROM PRINCIPAL_PERMISSION]
Total time: 7 seconds
Finished at: Thu Oct 05 16:58:21 CEST 2006



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (GRFT-107) Maven goal "allDeployHead" fails for HSQL db

Posted by "Andreas Weder (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/GRFT-107?page=comments#action_12440157 ] 
            
Andreas Weder commented on GRFT-107:
------------------------------------

I will try to change maven.xml in "components" as it seems to me that delete-j2-security.sql should not get executed on a release built with jetspeed2 support.

> Maven goal "allDeployHead" fails for HSQL db
> --------------------------------------------
>
>                 Key: GRFT-107
>                 URL: http://issues.apache.org/jira/browse/GRFT-107
>             Project: Graffito
>          Issue Type: Bug
>          Components: Project Build
>         Environment: Windows XP SP2, Java 5, current trunk of Jetspeed2 (rev.  452795), current trunk of Apache Graffito (rev. 451266)
>            Reporter: Andreas Weder
>            Priority: Blocker
>         Attachments: build.properties
>
>
> Running "maven allDeployHead" fails with the following error:
> db.create:
> db.execute:
>     [echo] Execute SQL script : ./target/src/sql/hypersonic/graffitostore-schema
> .sql -- ON ERROR = abort
>     [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\target\sr
> c\sql\hypersonic\graffitostore-schema.sql
>     [sql] 31 of 31 SQL statements executed successfully
> db.execute:
>     [echo] Execute SQL script : ./src/sql/GraffitoServer/insert-db.sql -- ON ERR
> OR = abort
>     [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\src\sql\G
> raffitoServer\insert-db.sql
>     [sql] 9 of 9 SQL statements executed successfully
> db.execute:
>     [echo] Execute SQL script : ./src/sql/GraffitoServer/delete-j2-security.sql
> -- ON ERROR = abort
>     [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\src\sql\G
> raffitoServer\delete-j2-security.sql
>     [sql] [ERROR] Failed to execute: DELETE FROM PRINCIPAL_PERMISSION WHERE PRIN
> CIPAL_ID = 6 AND PERMISSION_ID =  20
> BUILD FAILED
> File...... c:\Projects\Apache_Graffito_trunk\maven.xml
> Element... maven:reactor
> Line...... 197
> Column.... 28
> Unable to obtain goal [db.reinit.production] -- c:\Projects\Apache_Graffito_trun
> k\components\maven.xml:294:38: <sql> java.sql.SQLException: Table not found in s
> tatement [DELETE FROM PRINCIPAL_PERMISSION]
> Total time: 7 seconds
> Finished at: Thu Oct 05 16:58:21 CEST 2006

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (GRFT-107) Maven goal "allDeployHead" fails for HSQL db

Posted by "Andreas Weder (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/GRFT-107?page=comments#action_12440165 ] 
            
Andreas Weder commented on GRFT-107:
------------------------------------

My build went through with the following patch


Index: C:/Projects/Apache_Graffito_trunk/components/maven.xml
===================================================================
--- C:/Projects/Apache_Graffito_trunk/components/maven.xml	(revision 451266)
+++ C:/Projects/Apache_Graffito_trunk/components/maven.xml	(working copy)
@@ -1,7 +1,6 @@
 <!-- 
  Copyright 2002-2004 The Apache Software Foundation
 
- Licensed under the Apache License, Version 2.0 (the "License");
  you may not use this file except in compliance with the License.
  You may obtain a copy of the License at
 
@@ -189,9 +188,11 @@
 		<attainGoal name="db.production.properties"/>
 		<attainGoal name="db.scripts.gen"/>
 		<attainGoal name="db.create"/>
-		<j:set var="database.arg.script" 
-			value="./src/sql/GraffitoServer/insert-j2-security.sql" />
-		<attainGoal name="db.execute" />
+		<j:if test="${jetspeed == 'falseX'}">
+			<j:set var="database.arg.script" 
+				value="./src/sql/GraffitoServer/insert-j2-security.sql" />
+			<attainGoal name="db.execute" />
+		</j:if>
 		
 	</goal>
 	<goal name="db.create">
@@ -220,8 +221,10 @@
 	<goal name="db.drop.production">
 		<attainGoal name="db.production.properties"/>
 		<attainGoal name="db.drop"/>
-		<j:set var="database.arg.script"  	value="./src/sql/GraffitoServer/delete-j2-security.sql" />
-		<attainGoal name="db.execute" />
+		<j:if test="${jetspeed == 'falseX'}">
+			<j:set var="database.arg.script"  	value="./src/sql/GraffitoServer/delete-j2-security.sql" />
+			<attainGoal name="db.execute" />
+		</j:if>
 		
 	</goal>
 	<goal name="db.drop">
@@ -248,7 +251,7 @@
 	<goal name="db.reinit.test">
 		<attainGoal name="db.test.properties"/>
 		<attainGoal name="db.scripts.gen"/>			
-                <attainGoal name="db.drop"/>		
+        <attainGoal name="db.drop"/>		
 		<attainGoal name="db.create"/>
 	</goal>
 	
@@ -257,14 +260,15 @@
 		<attainGoal name="db.scripts.gen"/>			
 		<attainGoal name="db.drop"/>		
 		<attainGoal name="db.create"/>
-		<j:set var="database.arg.script" 
-		       value="./src/sql/GraffitoServer/delete-j2-security.sql" />
-		<attainGoal name="db.execute" />
-		
-		<j:set var="database.arg.script" 
-		       value="./src/sql/GraffitoServer/insert-j2-security.sql" />
-		<attainGoal name="db.execute" />
-		
+		<j:if test="${jetspeed == 'falseX'}">
+			<j:set var="database.arg.script" 
+			       value="./src/sql/GraffitoServer/delete-j2-security.sql" />
+			<attainGoal name="db.execute" />
+			
+			<j:set var="database.arg.script" 
+			       value="./src/sql/GraffitoServer/insert-j2-security.sql" />
+			<attainGoal name="db.execute" />
+		</j:if>
 	</goal>
 	
 	<!-- ================================================================ -->


> Maven goal "allDeployHead" fails for HSQL db
> --------------------------------------------
>
>                 Key: GRFT-107
>                 URL: http://issues.apache.org/jira/browse/GRFT-107
>             Project: Graffito
>          Issue Type: Bug
>          Components: Project Build
>         Environment: Windows XP SP2, Java 5, current trunk of Jetspeed2 (rev.  452795), current trunk of Apache Graffito (rev. 451266)
>            Reporter: Andreas Weder
>            Priority: Blocker
>         Attachments: build.properties
>
>
> Running "maven allDeployHead" fails with the following error:
> db.create:
> db.execute:
>     [echo] Execute SQL script : ./target/src/sql/hypersonic/graffitostore-schema
> .sql -- ON ERROR = abort
>     [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\target\sr
> c\sql\hypersonic\graffitostore-schema.sql
>     [sql] 31 of 31 SQL statements executed successfully
> db.execute:
>     [echo] Execute SQL script : ./src/sql/GraffitoServer/insert-db.sql -- ON ERR
> OR = abort
>     [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\src\sql\G
> raffitoServer\insert-db.sql
>     [sql] 9 of 9 SQL statements executed successfully
> db.execute:
>     [echo] Execute SQL script : ./src/sql/GraffitoServer/delete-j2-security.sql
> -- ON ERROR = abort
>     [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\src\sql\G
> raffitoServer\delete-j2-security.sql
>     [sql] [ERROR] Failed to execute: DELETE FROM PRINCIPAL_PERMISSION WHERE PRIN
> CIPAL_ID = 6 AND PERMISSION_ID =  20
> BUILD FAILED
> File...... c:\Projects\Apache_Graffito_trunk\maven.xml
> Element... maven:reactor
> Line...... 197
> Column.... 28
> Unable to obtain goal [db.reinit.production] -- c:\Projects\Apache_Graffito_trun
> k\components\maven.xml:294:38: <sql> java.sql.SQLException: Table not found in s
> tatement [DELETE FROM PRINCIPAL_PERMISSION]
> Total time: 7 seconds
> Finished at: Thu Oct 05 16:58:21 CEST 2006

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (GRFT-107) Maven goal "allDeployHead" fails for HSQL db

Posted by "Andreas Weder (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/GRFT-107?page=all ]

Andreas Weder updated GRFT-107:
-------------------------------

    Attachment: build.properties

Build file I'm using.

> Maven goal "allDeployHead" fails for HSQL db
> --------------------------------------------
>
>                 Key: GRFT-107
>                 URL: http://issues.apache.org/jira/browse/GRFT-107
>             Project: Graffito
>          Issue Type: Bug
>          Components: Project Build
>         Environment: Windows XP SP2, Java 5, current trunk of Jetspeed2 (rev.  452795), current trunk of Apache Graffito (rev. 451266)
>            Reporter: Andreas Weder
>            Priority: Blocker
>         Attachments: build.properties
>
>
> Running "maven allDeployHead" fails with the following error:
> db.create:
> db.execute:
>     [echo] Execute SQL script : ./target/src/sql/hypersonic/graffitostore-schema
> .sql -- ON ERROR = abort
>     [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\target\sr
> c\sql\hypersonic\graffitostore-schema.sql
>     [sql] 31 of 31 SQL statements executed successfully
> db.execute:
>     [echo] Execute SQL script : ./src/sql/GraffitoServer/insert-db.sql -- ON ERR
> OR = abort
>     [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\src\sql\G
> raffitoServer\insert-db.sql
>     [sql] 9 of 9 SQL statements executed successfully
> db.execute:
>     [echo] Execute SQL script : ./src/sql/GraffitoServer/delete-j2-security.sql
> -- ON ERROR = abort
>     [sql] Executing file: C:\Projects\Apache_Graffito_trunk\components\src\sql\G
> raffitoServer\delete-j2-security.sql
>     [sql] [ERROR] Failed to execute: DELETE FROM PRINCIPAL_PERMISSION WHERE PRIN
> CIPAL_ID = 6 AND PERMISSION_ID =  20
> BUILD FAILED
> File...... c:\Projects\Apache_Graffito_trunk\maven.xml
> Element... maven:reactor
> Line...... 197
> Column.... 28
> Unable to obtain goal [db.reinit.production] -- c:\Projects\Apache_Graffito_trun
> k\components\maven.xml:294:38: <sql> java.sql.SQLException: Table not found in s
> tatement [DELETE FROM PRINCIPAL_PERMISSION]
> Total time: 7 seconds
> Finished at: Thu Oct 05 16:58:21 CEST 2006

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira