[richfaces-issues] [JBoss JIRA] (RF-13483) Photoalbum: Hibernate error during deployment
Jiří Štefek (JIRA)
issues at jboss.org
Wed Jan 15 04:03:32 EST 2014
[ https://issues.jboss.org/browse/RF-13483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiří Štefek updated RF-13483:
-----------------------------
Description:
# build photoalbum and deploy to EAP 6.1.1
result:
* there is error during deployment
* the application and basic functionality works
{code}
09:42:16,051 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000227: Running hbm2ddl schema export
09:42:16,058 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Album drop constraint FK3C68E4F938C4E8E
09:42:16,058 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "ALBUM" not found; SQL statement:
alter table Album drop constraint FK3C68E4F938C4E8E [42102-168]
09:42:16,058 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Album drop constraint FK3C68E4F1C054E63
09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "ALBUM" not found; SQL statement:
alter table Album drop constraint FK3C68E4F1C054E63 [42102-168]
09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Comment drop constraint FK9BDE863F390C8611
09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "COMMENT" not found; SQL statement:
alter table Comment drop constraint FK9BDE863F390C8611 [42102-168]
09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Comment drop constraint FK9BDE863FE13B4C3
09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "COMMENT" not found; SQL statement:
alter table Comment drop constraint FK9BDE863FE13B4C3 [42102-168]
09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Event drop constraint FK403827A3EBF919D
09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "EVENT" not found; SQL statement:
alter table Event drop constraint FK403827A3EBF919D [42102-168]
09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Event drop constraint FK403827A756B16E3
09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "EVENT" not found; SQL statement:
alter table Event drop constraint FK403827A756B16E3 [42102-168]
09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Event drop constraint FK403827A1C054E63
09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "EVENT" not found; SQL statement:
alter table Event drop constraint FK403827A1C054E63 [42102-168]
09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Event_remoteAlbumIds drop constraint FK13ED749451AFB863
09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "EVENT_REMOTEALBUMIDS" not found; SQL statement:
alter table Event_remoteAlbumIds drop constraint FK13ED749451AFB863 [42102-168]
09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Image drop constraint FK437B93B9C30AC43
09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "IMAGE" not found; SQL statement:
alter table Image drop constraint FK437B93B9C30AC43 [42102-168]
09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Image_MetaTag drop constraint FKA5ED44315922EB44
09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "IMAGE_METATAG" not found; SQL statement:
alter table Image_MetaTag drop constraint FKA5ED44315922EB44 [42102-168]
09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Image_MetaTag drop constraint FKA5ED4431D066A86
09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "IMAGE_METATAG" not found; SQL statement:
alter table Image_MetaTag drop constraint FKA5ED4431D066A86 [42102-168]
09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Shelf drop constraint FK4C26E0A51AFB863
09:42:16,062 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "SHELF" not found; SQL statement:
alter table Shelf drop constraint FK4C26E0A51AFB863 [42102-168]
09:42:16,062 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Shelf drop constraint FK4C26E0A443A43E9
09:42:16,062 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "SHELF" not found; SQL statement:
{code}
was:
# build photoalbum and deploy to EAP 6.1.1
result:
* there is error during deployment
* when you open http://localhost:8080/richfaces-photoalbum, you can see application and basic functionality works, however you cannot create a new user
{quote}
17:10:35,171 INFO [org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator] (ServerService Thread Pool -- 48) HHH000130: Instantiating explicit connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
17:10:35,346 INFO [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 48) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
17:10:35,361 WARN [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 48) HHH000431: Unable to determine H2 database version, certain features may not work
17:10:35,389 INFO [org.hibernate.engine.transaction.internal.TransactionFactoryInitiator] (ServerService Thread Pool -- 48) HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jta.CMTTransactionFactory
17:10:35,392 INFO [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 48) HHH000397: Using ASTQueryTranslatorFactory
17:10:35,444 INFO [org.hibernate.validator.internal.util.Version] (ServerService Thread Pool -- 48) HV000001: Hibernate Validator 4.3.1.Final-redhat-1
17:10:35,866 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000227: Running hbm2ddl schema export
17:10:35,874 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000389: Unsuccessful: alter table Album drop constraint FK_maso23c869ch22pa5q0sh6tok
17:10:35,874 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) Table "ALBUM" not found; SQL statement:
alter table Album drop constraint FK_maso23c869ch22pa5q0sh6tok [42102-168]
17:10:35,875 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000389: Unsuccessful: alter table Album drop constraint FK_j8gbvffe8l1pvbewibj4ft62m
17:10:35,875 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) Table "ALBUM" not found; SQL statement:
alter table Album drop constraint FK_j8gbvffe8l1pvbewibj4ft62m [42102-168]
17:10:35,875 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000389: Unsuccessful: alter table Comment drop constraint FK_j94pith5sd971k29j6ysxuk7
17:10:35,875 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) Table "COMMENT" not found; SQL statement:
alter table Comment drop constraint FK_j94pith5sd971k29j6ysxuk7 [42102-168]
17:10:35,875 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000389: Unsuccessful: alter table Comment drop constraint FK_qh25b5js0rt4fqv9syhyjv781
17:10:35,876 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) Table "COMMENT" not found; SQL statement:
alter table Comment drop constraint FK_qh25b5js0rt4fqv9syhyjv781 [42102-168]
17:10:35,876 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000389: Unsuccessful: alter table Image drop constraint FK_62s883scl1tf1fl7357bbtxy9
17:10:35,876 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) Table "IMAGE" not found; SQL statement:
alter table Image drop constraint FK_62s883scl1tf1fl7357bbtxy9 [42102-168]
17:10:35,876 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000389: Unsuccessful: alter table Image_MetaTag drop constraint FK_qw6hpgbun1gnhr0nimrao8gxc
17:10:35,877 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) Table "IMAGE_METATAG" not found; SQL statement:
alter table Image_MetaTag drop constraint FK_qw6hpgbun1gnhr0nimrao8gxc [42102-168]
17:10:35,877 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000389: Unsuccessful: alter table Image_MetaTag drop constraint FK_rb6l6aoyv7bss6hto77wqnvfg
17:10:35,877 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) Table "IMAGE_METATAG" not found; SQL statement:
alter table Image_MetaTag drop constraint FK_rb6l6aoyv7bss6hto77wqnvfg [42102-168]
17:10:35,877 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000389: Unsuccessful: alter table Shelf drop constraint FK_3unm5rbreqkjurmy4hpfl89yr
17:10:35,878 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) Table "SHELF" not found; SQL statement:
alter table Shelf drop constraint FK_3unm5rbreqkjurmy4hpfl89yr [42102-168]
17:10:36,026 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 48) HHH000230: Schema export complete
{quote}
> Photoalbum: Hibernate error during deployment
> ---------------------------------------------
>
> Key: RF-13483
> URL: https://issues.jboss.org/browse/RF-13483
> Project: RichFaces
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: examples
> Affects Versions: 4.3.5
> Reporter: Jiří Štefek
> Assignee: Michal Petrov
> Labels: photoalbum
>
> # build photoalbum and deploy to EAP 6.1.1
> result:
> * there is error during deployment
> * the application and basic functionality works
> {code}
> 09:42:16,051 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000227: Running hbm2ddl schema export
> 09:42:16,058 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Album drop constraint FK3C68E4F938C4E8E
> 09:42:16,058 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "ALBUM" not found; SQL statement:
> alter table Album drop constraint FK3C68E4F938C4E8E [42102-168]
> 09:42:16,058 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Album drop constraint FK3C68E4F1C054E63
> 09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "ALBUM" not found; SQL statement:
> alter table Album drop constraint FK3C68E4F1C054E63 [42102-168]
> 09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Comment drop constraint FK9BDE863F390C8611
> 09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "COMMENT" not found; SQL statement:
> alter table Comment drop constraint FK9BDE863F390C8611 [42102-168]
> 09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Comment drop constraint FK9BDE863FE13B4C3
> 09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "COMMENT" not found; SQL statement:
> alter table Comment drop constraint FK9BDE863FE13B4C3 [42102-168]
> 09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Event drop constraint FK403827A3EBF919D
> 09:42:16,059 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "EVENT" not found; SQL statement:
> alter table Event drop constraint FK403827A3EBF919D [42102-168]
> 09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Event drop constraint FK403827A756B16E3
> 09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "EVENT" not found; SQL statement:
> alter table Event drop constraint FK403827A756B16E3 [42102-168]
> 09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Event drop constraint FK403827A1C054E63
> 09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "EVENT" not found; SQL statement:
> alter table Event drop constraint FK403827A1C054E63 [42102-168]
> 09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Event_remoteAlbumIds drop constraint FK13ED749451AFB863
> 09:42:16,060 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "EVENT_REMOTEALBUMIDS" not found; SQL statement:
> alter table Event_remoteAlbumIds drop constraint FK13ED749451AFB863 [42102-168]
> 09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Image drop constraint FK437B93B9C30AC43
> 09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "IMAGE" not found; SQL statement:
> alter table Image drop constraint FK437B93B9C30AC43 [42102-168]
> 09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Image_MetaTag drop constraint FKA5ED44315922EB44
> 09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "IMAGE_METATAG" not found; SQL statement:
> alter table Image_MetaTag drop constraint FKA5ED44315922EB44 [42102-168]
> 09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Image_MetaTag drop constraint FKA5ED4431D066A86
> 09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "IMAGE_METATAG" not found; SQL statement:
> alter table Image_MetaTag drop constraint FKA5ED4431D066A86 [42102-168]
> 09:42:16,061 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Shelf drop constraint FK4C26E0A51AFB863
> 09:42:16,062 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "SHELF" not found; SQL statement:
> alter table Shelf drop constraint FK4C26E0A51AFB863 [42102-168]
> 09:42:16,062 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) HHH000389: Unsuccessful: alter table Shelf drop constraint FK4C26E0A443A43E9
> 09:42:16,062 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 4) Table "SHELF" not found; SQL statement:
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the richfaces-issues
mailing list