jeudi 30 septembre 2021

Issue in application migration to Spring 5 Hibernate 5

I am currently working to upgrade an existing web application from Spring 4 to 5.3.9 and Hibernate 4 to 5.5.7 DB2 database is being used. After the new jar files are replaced, an SQLGrammarException exception thrown which is caused by inaccessible of the database object SYSCAT.SEQUENCES object. This is never an issue with hibernate 4 and I am not sure why hibernate try to access this database object. Is there a way to avoid this issue?

com.ibm.websphere.ce.cm.StaleConnectionException: SYSCAT.SEQUENCES IS AN UNDEFINED NAME

Thanks a lot for the help.

Following is a more details in the log.

Caused by: org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.internal.Helper.buildDatabaseInformation(Helper.java:189) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:61) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:200) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:81) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:327) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:471) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1410) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1845) ~[spring-beans-5.3.9.jar:5.3.9] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782) ~[spring-beans-5.3.9.jar:5.3.9] ... 41 more Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: SYSCAT.SEQUENCES IS AN UNDEFINED NAME. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.19.49 at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.handleStaleStatement(WSJdbcUtil.java:1006) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.spi.ServerFunction.handleStaleStatement(ServerFunction.java:712) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2285) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1191) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:1065) ~[com.ibm.ws.runtime.jar:?] at org.hibernate.tool.schema.extract.internal.SequenceInformationExtractorLegacyImpl.extractMetadata(SequenceInformationExtractorLegacyImpl.java:42) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.initializeSequences(DatabaseInformationImpl.java:65) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.(DatabaseInformationImpl.java:59) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.internal.Helper.buildDatabaseInformation(Helper.java:181) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:61) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:200) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:81) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:327) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:471) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1410) ~[hibernate-core-5.5.7.Final%20(1).jar:5.5.7.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.3.9.jar:5.3.9] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1845) ~[spring-beans-5.3.9.jar:5.3.9] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782) ~[spring-beans-5.3.9.jar:5.3.9] ... 41 more




Aucun commentaire:

Enregistrer un commentaire