[ 
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

_______________________________________________
richfaces-issues mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/richfaces-issues

Reply via email to