I got some trouble .. C:\Users\Yen\workspace\empi>mvn [INFO] Scanning for projects... [INFO] Reactor build order: [INFO] AppFuse Modular Application [INFO] AppFuse Modular Application - Core [INFO] AppFuse Modular Application - Web (Struts 2) [INFO] ------------------------------------------------------------------------ [INFO] Building AppFuse Modular Application [INFO] task-segment: [install] [INFO] ------------------------------------------------------------------------ [INFO] [site:attach-descriptor {execution: default-attach-descriptor}] [INFO] [install:install {execution: default-install}] [INFO] Installing C:\Users\Yen\workspace\empi\pom.xml to C:\Users\Yen\.m2\reposi tory\com\carefx\empi\empi\1.0-SNAPSHOT\empi-1.0-SNAPSHOT.pom [INFO] ------------------------------------------------------------------------ [INFO] Building AppFuse Modular Application - Core [INFO] task-segment: [install] [INFO] ------------------------------------------------------------------------ [INFO] [aspectj:compile {execution: default}] [INFO] [resources:resources {execution: default-resources}] [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 6 resources [INFO] [compiler:compile {execution: default-compile}] [INFO] Nothing to compile - all classes are up to date [INFO] [resources:testResources {execution: default-testResources}] [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 5 resources [INFO] Preparing hibernate3:hbm2ddl [WARNING] Removing: hbm2ddl from forked lifecycle, to prevent recursive invocati on. [INFO] [aspectj:compile {execution: default}] [INFO] [resources:resources {execution: default-resources}] [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 6 resources [INFO] [hibernate3:hbm2ddl {execution: default}] [INFO] Configuration XML file loaded: file:/C:/Users/Yen/workspace/empi/core/src /main/resources/hibernate.cfg.xml [INFO] Configuration XML file loaded: file:/C:/Users/Yen/workspace/empi/core/src /main/resources/hibernate.cfg.xml [INFO] Configuration Properties file loaded: C:\Users\Yen\workspace\empi\core\ta rget\test-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), country varchar(100), postal_code varchar(15), province varchar(100), cred entials_expired bit not null, email varchar(255) not null unique, account_enable d bit, first_name varchar(50) not null, last_name varchar(50) not null, password varchar(255) not null, password_hint varchar(255), phone_number varchar(255), u sername varchar(50) not null unique, version integer, website varchar(255), prim ary 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 [42102-79] [ERROR] Error #1: org.h2.jdbc.JdbcSQLException: Table USER_ROLE not found; SQL s tatement: alter table user_role drop constraint FK143BF46AF503D155 [42102-79] [INFO] [compiler:testCompile {execution: default-testCompile}] [INFO] Compiling 1 source file to C:\Users\Yen\workspace\empi\core\target\test-c lasses [INFO] [dbunit:operation {execution: test-compile}] 266 [main] INFO org.dbunit.database.DatabaseDataSet - database name=H2 database version=1.0.79 (2008-09-26) database major version=1 database minor version=0 jdbc driver name=H2 JDBC Driver jdbc driver version=1.0.79 (2008-09-26) jdbc driver major version=1 jdbc driver minor version=0
297 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=user_role newValue=USER_ROLE 297 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=role newValue=ROLE 328 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=app_user newValue=APP_USER [INFO] [surefire:test {execution: default-test}] [INFO] Surefire report directory: C:\Users\Yen\workspace\empi\core\target\surefi re-reports ------------------------------------------------------- T E S T S ------------------------------------------------------- Running com.carefx.empi.core.CoreTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.094 sec Results : Tests run: 1, Failures: 0, Errors: 0, Skipped: 0 [INFO] [jar:jar {execution: default-jar}] [INFO] Building jar: C:\Users\Yen\workspace\empi\core\target\core-1.0-SNAPSHOT.j ar [INFO] [install:install {execution: default-install}] [INFO] Installing C:\Users\Yen\workspace\empi\core\target\core-1.0-SNAPSHOT.jar to C:\Users\Yen\.m2\repository\com\carefx\empi\core\1.0-SNAPSHOT\core-1.0-SNAPSH OT.jar [INFO] ------------------------------------------------------------------------ [INFO] Building AppFuse Modular Application - Web (Struts 2) [INFO] task-segment: [install] [INFO] ------------------------------------------------------------------------ [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}] [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}] [INFO] [resources:resources {execution: default-resources}] [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 21 resources [INFO] Copying 37 resources [INFO] Copying 2 resources [INFO] Copying 71 resources [INFO] Copying 71 resources [INFO] [compiler:compile {execution: default-compile}] [INFO] Compiling 17 source files to C:\Users\Yen\workspace\empi\web\target\class es [INFO] [resources:testResources {execution: default-testResources}] [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 5 resources [INFO] Copying 11 resources [INFO] [compiler:testCompile {execution: default-testCompile}] [INFO] Compiling 8 source files to C:\Users\Yen\workspace\empi\web\target\test-c lasses [INFO] [dbunit:operation {execution: test-compile}] 12937 [main] INFO org.dbunit.database.DatabaseDataSet - database name=H2 database version=1.0.79 (2008-09-26) database major version=1 database minor version=0 jdbc driver name=H2 JDBC Driver jdbc driver version=1.0.79 (2008-09-26) jdbc driver major version=1 jdbc driver minor version=0 12937 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.Database TableMetaData. Corrected table name: oldValue=user_role newValue=USER_ROLE 12952 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.Database TableMetaData. Corrected table name: oldValue=role newValue=ROLE 12952 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.Database TableMetaData. Corrected table name: oldValue=app_user newValue=APP_USER [INFO] [surefire:test {execution: default-test}] [INFO] Surefire report directory: C:\Users\Yen\workspace\empi\web\target\surefir e-reports ------------------------------------------------------- T E S T S ------------------------------------------------------- Running com.carefx.empi.webapp.listener.StartupListenerTest DEBUG [main] StartupListener.contextInitialized(40) | Initializing context... DEBUG [main] StartupListener.contextInitialized(76) | authenticationManager bean not found, assuming test and ignoring... DEBUG [main] StartupListener.contextInitialized(84) | Remember Me Enabled? null DEBUG [main] StartupListener.contextInitialized(88) | Populating drop-downs... DEBUG [main] StartupListener.setupContext(105) | Drop-down initialization comple te [OK] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 5.501 sec Running com.carefx.empi.webapp.filter.LocaleFilterTest DEBUG [main] LocaleFilter.init(157) | Initializing filter '' DEBUG [main] LocaleFilter.init(182) | Filter '' configured successfully DEBUG [main] MockFilterChain.doFilter(37) | Forwarding to: DEBUG [main] LocaleFilter.init(157) | Initializing filter '' DEBUG [main] LocaleFilter.init(182) | Filter '' configured successfully DEBUG [main] MockFilterChain.doFilter(37) | Forwarding to: DEBUG [main] LocaleFilter.init(157) | Initializing filter '' DEBUG [main] LocaleFilter.init(182) | Filter '' configured successfully DEBUG [main] MockFilterChain.doFilter(37) | Forwarding to: DEBUG [main] LocaleFilter.init(157) | Initializing filter '' DEBUG [main] LocaleFilter.init(182) | Filter '' configured successfully DEBUG [main] MockFilterChain.doFilter(37) | Forwarding to: DEBUG [main] LocaleFilter.init(157) | Initializing filter '' DEBUG [main] LocaleFilter.init(182) | Filter '' configured successfully DEBUG [main] MockFilterChain.doFilter(37) | Forwarding to: Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.14 sec Running com.carefx.empi.webapp.action.SignupActionTest INFO [main] SignupActionTest.loadContextLocations(187) | Loading context for loc ations: classpath:/applicationContext-resources.xml,classpath:/applicationContex t-dao.xml,classpath:/applicationContext-service.xml,classpath*:/applicationConte xt.xml,/WEB-INF/applicationContext*.xml 2009-12-8 13:10:29 net.sf.ehcache.CacheManager detectAndFixDiskStorePathConflict 警告: Creating a new instance of CacheManager using the diskStorePath "C:\Users\ Yen\AppData\Local\Temp\" which is already used by an existing CacheManager. The source of the configuration was classpath. The diskStore path for this CacheManager will be set to C:\Users\Yen\AppData\Loc al\Temp\\ehcache_auto_created_1260249029634. To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache .xml) for each CacheManager instance. DEBUG [main] SignupActionTest.startNewTransaction(392) | Began transaction (1): transaction manager [org.springframework.orm.hibernate3.HibernateTransactionMana g...@5113f0]; rollback [true]. DEBUG [main] SignupAction.sendUserMessage(164) | sending e-mail to user [self-re giste...@raibledesigns.com]... DEBUG [main] SignupActionTest.endTransaction(360) | Rolled back transaction afte r execution of test [testExecute]. DEBUG [main] SignupActionTest.startNewTransaction(392) | Began transaction (1): transaction manager [org.springframework.orm.hibernate3.HibernateTransactionMana g...@5113f0]; rollback [true]. DEBUG [main] SignupActionTest.endTransaction(360) | Rolled back transaction afte r execution of test [testDisplayForm]. Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.496 sec Running com.carefx.empi.webapp.filter.StaticFilterTest DEBUG [main] MockFilterChain.doFilter(37) | Forwarding to: /editProfile.html Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.047 sec Running com.carefx.empi.webapp.action.PasswordHintActionTest DEBUG [main] PasswordHintActionTest.startNewTransaction(392) | Began transaction (1): transaction manager [org.springframework.orm.hibernate3.HibernateTransacti onmana...@5113f0]; rollback [true]. DEBUG [main] PasswordHintAction.execute(45) | Processing Password Hint... DEBUG [main] PasswordHintActionTest.endTransaction(360) | Rolled back transactio n after execution of test [testExecute]. Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.14 sec Running com.carefx.empi.webapp.action.UserActionTest DEBUG [main] UserActionTest.startNewTransaction(392) | Began transaction (1): tr ansaction manager [org.springframework.orm.hibernate3.HibernateTransactionManage r...@5113f0]; rollback [true]. DEBUG [main] UserActionTest.endTransaction(360) | Rolled back transaction after execution of test [testCancel]. DEBUG [main] UserActionTest.startNewTransaction(392) | Began transaction (1): tr ansaction manager [org.springframework.orm.hibernate3.HibernateTransactionManage r...@5113f0]; rollback [true]. DEBUG [main] UserAction.edit(111) | checking for remember me login... DEBUG [main] UserActionTest.endTransaction(360) | Rolled back transaction after execution of test [testEdit]. DEBUG [main] UserActionTest.startNewTransaction(392) | Began transaction (1): tr ansaction manager [org.springframework.orm.hibernate3.HibernateTransactionManage r...@5113f0]; rollback [true]. DEBUG [main] UserActionTest.endTransaction(360) | Rolled back transaction after execution of test [testSave]. DEBUG [main] UserActionTest.startNewTransaction(392) | Began transaction (1): tr ansaction manager [org.springframework.orm.hibernate3.HibernateTransactionManage r...@5113f0]; rollback [true]. DEBUG [main] UserActionTest.testSaveConflictingUser(65) | original version #: 2 DEBUG [main] UserActionTest.endTransaction(360) | Rolled back transaction after execution of test [testSaveConflictingUser]. DEBUG [main] UserActionTest.startNewTransaction(392) | Began transaction (1): tr ansaction manager [org.springframework.orm.hibernate3.HibernateTransactionManage r...@5113f0]; rollback [true]. DEBUG [main] UserActionTest.endTransaction(360) | Rolled back transaction after execution of test [testSearch]. DEBUG [main] UserActionTest.startNewTransaction(392) | Began transaction (1): tr ansaction manager [org.springframework.orm.hibernate3.HibernateTransactionManage r...@5113f0]; rollback [true]. DEBUG [main] UserActionTest.endTransaction(360) | Rolled back transaction after execution of test [testRemove]. Tests run: 6, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 2.543 sec <<< FA ILURE! Results : Tests in error: testSaveConflictingUser(com.carefx.empi.webapp.action.UserActionTest) Tests run: 17, Failures: 0, Errors: 1, Skipped: 0 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] There are test failures. Please refer to C:\Users\Yen\workspace\empi\web\target\surefire-reports for the individual test results. [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ [INFO] Total time: 40 seconds [INFO] Finished at: Tue Dec 08 13:10:34 CST 2009 [INFO] Final Memory: 44M/63M [INFO] ------------------------------------------------------------------------ C:\Users\Yen\workspace\empi> 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-tp954926p955000.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