sorry for post too many mvn build log.
I only want point H2 dbunit runs error, but Mysql or Oracle (I just try the
two db) runs successful.
mvn -Ph2 ---- get error
mvn ,or mvn -Poracle ---- get successful
mraible wrote:
>
> Don't know if it will help, but I've learned there's issues with trying to
> activate two profiles at once with activeByDefault. I'd suggest replacing
> all your <jdbc.*> properties with the ones from the h2 profile.
>
> On Mon, Dec 7, 2009 at 10:33 PM, johnydz <yanda...@msn.com> wrote:
>
>>
>> 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
>>
>>
>
>
--
View this message in context:
http://n4.nabble.com/how-to-change-database-on-appfuse-tp954926p955492.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
