it is succesful on 2.0.2 appfuse-basic-struts (change database to h2)
but 2.0.2 appfuse-modular-struts is failure
2.1 + both basic and modular is failure
johnydz wrote:
>
> 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-tp954926p955004.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
