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

Reply via email to