I know it.
I change
<jdbc.url><![CDATA[jdbc:${java.io.tmpdir}/h2/myproject]]></jdbc.url>
to
<jdbc.url><![CDATA[jdbc:h2:~/h2/myproject]]></jdbc.url>
then it 's build successful.
i guess java.io.tmpdir contains "blank" or"/" character,and maven dont
support it.
johnydz wrote:
>
> first,i install appfuse 2.0.2:
> mvn archetype:generate -B -DarchetypeGroupId=org.appfuse.archetypes
> -DarchetypeArtifactId=appfuse-basic-struts -DarchetypeVersion=2.0.2
> -DgroupId=com.mycompany -DartifactId=myproject
> it 's sucessful!
>
> second,as http://raibledesigns.com/rd/entry/database_profiles_in_appfuse_2
>
> run mvn integration-test -Ph2
>
> it 's BUILD ERROR,How to change database on appfuse? thanks...
>
> C:\Users\Yen\workspace\myproject>mvn integration-test -Ph2
> [INFO] Scanning for projects...
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Building AppFuse Struts 2 Application
> [INFO] task-segment: [integration-test]
> [INFO]
> ------------------------------------------------------------------------
> [WARNING] POM for 'xfire:xfire-jsr181-api:pom:1.0-M1:compile' is invalid.
>
> Its dependencies (if any) will NOT be available to the current build.
> [INFO] [warpath:add-classes {execution: default}]
> [INFO] [aspectj:compile {execution: default}]
> [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}]
> [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}]
> [INFO] [resources:resources {execution: default-resources}]
> [WARNING] File encoding has not been set, using platform encoding GBK,
> i.e. buil
> d is platform dependent!
> [WARNING] Using platform encoding (GBK actually) to copy filtered
> resources, i.e
> . build is platform dependent!
> [INFO] Copying 12 resources
> [INFO] Copying 2 resources
> [INFO] Copying 27 resources
> [INFO] Copying 27 resources
> [INFO] [compiler:compile {execution: default-compile}]
> [INFO] Nothing to compile - all classes are up to date
> [INFO] [resources:testResources {execution: default-testResources}]
> [WARNING] File encoding has not been set, using platform encoding GBK,
> i.e. buil
> d is platform dependent!
> [WARNING] Using platform encoding (GBK actually) to copy filtered
> resources, i.e
> . build is platform dependent!
> [INFO] Copying 4 resources
> [INFO] Copying 4 resources
> [INFO] Preparing hibernate3:hbm2ddl
> [WARNING] Removing: hbm2ddl from forked lifecycle, to prevent recursive
> invocati
> on.
> [INFO] [warpath:add-classes {execution: default}]
> [INFO] [aspectj:compile {execution: default}]
> [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}]
> [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}]
> [INFO] [resources:resources {execution: default-resources}]
> [WARNING] File encoding has not been set, using platform encoding GBK,
> i.e. buil
> d is platform dependent!
> [WARNING] Using platform encoding (GBK actually) to copy filtered
> resources, i.e
> . build is platform dependent!
> [INFO] Copying 12 resources
> [INFO] Copying 2 resources
> [INFO] Copying 27 resources
> [INFO] Copying 27 resources
> [INFO] Copying 27 resources
> [INFO] Copying 27 resources
> [INFO] [hibernate3:hbm2ddl {execution: default}]
> [INFO] Configuration XML file loaded:
> file:/C:/Users/Yen/workspace/myproject/src
> /main/resources/hibernate.cfg.xml
> log4j:WARN Continuable parsing error 57 and column 64
> log4j:WARN Attribute value "com.opensymphony.xwork2.util.OgnlValueStack"
> of type
> ID must be unique within the document.
> [INFO] Configuration XML file loaded:
> file:/C:/Users/Yen/workspace/myproject/src
> /main/resources/hibernate.cfg.xml
> [INFO] Configuration Properties file loaded:
> C:\Users\Yen\workspace\myproject\ta
> rget\classes\jdbc.properties
> alter table user_role drop constraint FK143BF46A4FD90D75;
> alter table user_role drop constraint FK143BF46AF503D155;
> drop table app_user if exists;
> drop table role if exists;
> drop table user_role if exists;
> create table app_user (id bigint generated by default as identity,
> account_expir
> ed bit not null, account_locked bit not null, address varchar(150), city
> varchar
> (50) not null, country varchar(100), postal_code varchar(15) not null,
> province
> varchar(100), credentials_expired bit not null, email varchar(255) not
> null uniq
> ue, account_enabled bit, first_name varchar(50) not null, last_name
> varchar(50)
> not null, password varchar(255) not null, password_hint varchar(255),
> phone_numb
> er varchar(255), username varchar(50) not null unique, version integer,
> website
> varchar(255), primary key (id));
> create table role (id bigint generated by default as identity, description
> varch
> ar(64), name varchar(20), primary key (id));
> create table user_role (user_id bigint not null, role_id bigint not null,
> primar
> y key (user_id, role_id));
> alter table user_role add constraint FK143BF46A4FD90D75 foreign key
> (role_id) re
> ferences role;
> alter table user_role add constraint FK143BF46AF503D155 foreign key
> (user_id) re
> ferences app_user;
> [WARNING] 2 errors occurred while performing <hbm2ddl>.
> [ERROR] Error #1: org.h2.jdbc.JdbcSQLException: Table USER_ROLE not found;
> SQL s
> tatement: alter table user_role drop constraint FK143BF46A4FD90D75
> [42S02-34]
> [ERROR] Error #1: org.h2.jdbc.JdbcSQLException: Table USER_ROLE not found;
> SQL s
> tatement: alter table user_role drop constraint FK143BF46AF503D155
> [42S02-34]
> [INFO] [compiler:testCompile {execution: default-testCompile}]
> [INFO] Compiling 1 source file to
> C:\Users\Yen\workspace\myproject\target\test-c
> lasses
> [INFO] [dbunit:operation {execution: test-compile}]
> [INFO]
> ------------------------------------------------------------------------
> [ERROR] BUILD ERROR
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Error executing database operation: CLEAN_INSERT
>
> Embedded error: user_role
> [INFO]
> ------------------------------------------------------------------------
> [INFO] For more information, run Maven with the -e switch
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Total time: 15 seconds
> [INFO] Finished at: Tue Dec 08 09:21:00 CST 2009
> [INFO] Final Memory: 29M/56M
> [INFO]
> ------------------------------------------------------------------------
> C:\Users\Yen\workspace\myproject>
>
--
View this message in context:
http://n4.nabble.com/how-to-change-database-on-appfuse-tp954926p954938.html
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net
For additional commands, e-mail: users-h...@appfuse.dev.java.net
