java - hbm2ddl update is giving error in spring boot -
i using spring boot application entity manager persist data in oracle database. application.properties follows
hibernate.dialect: org.hibernate.dialect.oracle9idialect hibernate.show_sql: true hibernate.hbm2ddl.auto: update entitymanager.packagestoscan: com.abc.xyz
my configuration file contains bean follows
@bean public localcontainerentitymanagerfactorybean entitymanagerfactory() { localcontainerentitymanagerfactorybean entitymanagerfactory = new localcontainerentitymanagerfactorybean(); entitymanagerfactory.setdatasource(datasource); entitymanagerfactory.setpackagestoscan(env.getproperty("entitymanager.packagestoscan")); hibernatejpavendoradapter vendoradapter = new hibernatejpavendoradapter(); entitymanagerfactory.setjpavendoradapter(vendoradapter); properties additionalproperties = new properties(); additionalproperties.put("hibernate.dialect", env.getproperty("hibernate.dialect")); additionalproperties.put("hibernate.show_sql", env.getproperty("hibernate.show_sql")); additionalproperties.put("hibernate.hbm2ddl.auto", env.getproperty("hibernate.hbm2ddl.auto")); entitymanagerfactory.setjpaproperties(additionalproperties); return entitymanagerfactory; }
i getting following error
2016-08-23 19:35:13.633 info 20368 --- [ main] org.hibernate.tool.hbm2ddl.schemaupdate : hhh000228: running hbm2ddl schema update 2016-08-23 19:35:15.294 warn 20368 --- [ main] ationconfigembeddedwebapplicationcontext : exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.unsatisfieddependencyexception: error creating bean name 'databaseconfig': unsatisfied dependency expressed through field 'entitymanagerfactory': error creating bean name 'entitymanagerfactory' defined in class path resource [com/abc/xyz/configuration/databaseconfig.class]: invocation of init method failed; nested exception javax.persistence.persistenceexception: [persistenceunit: default] unable build hibernate sessionfactory; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'entitymanagerfactory' defined in class path resource [com/abc/xyz/configuration/databaseconfig.class]: invocation of init method failed; nested exception javax.persistence.persistenceexception: [persistenceunit: default] unable build hibernate sessionfactory 2016-08-23 19:35:15.322 error 20368 --- [ main] o.s.boot.springapplication : application startup failed org.springframework.beans.factory.unsatisfieddependencyexception: error creating bean name 'databaseconfig': unsatisfied dependency expressed through field 'entitymanagerfactory': error creating bean name 'entitymanagerfactory' defined in class path resource [com/abc/xyz/configuration/databaseconfig.class]: invocation of init method failed; nested exception javax.persistence.persistenceexception: [persistenceunit: default] unable build hibernate sessionfactory; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'entitymanagerfactory' defined in class path resource [com/abc/xyz/configuration/databaseconfig.class]: invocation of init method failed; nested exception javax.persistence.persistenceexception: [persistenceunit: default] unable build hibernate sessionfactory @ org.springframework.beans.factory.annotation.autowiredannotationbeanpostprocessor$autowiredfieldelement.inject(autowiredannotationbeanpostprocessor.java:569) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.annotation.injectionmetadata.inject(injectionmetadata.java:88) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.annotation.autowiredannotationbeanpostprocessor.postprocesspropertyvalues(autowiredannotationbeanpostprocessor.java:349) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.populatebean(abstractautowirecapablebeanfactory.java:1214) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:543) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:482) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractbeanfactory$1.getobject(abstractbeanfactory.java:306) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:230) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:302) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:197) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.constructorresolver.instantiateusingfactorymethod(constructorresolver.java:372) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.instantiateusingfactorymethod(abstractautowirecapablebeanfactory.java:1123) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbeaninstance(abstractautowirecapablebeanfactory.java:1018) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:510) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:482) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractbeanfactory$1.getobject(abstractbeanfactory.java:306) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:230) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:302) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:202) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.context.support.postprocessorregistrationdelegate.registerbeanpostprocessors(postprocessorregistrationdelegate.java:228) ~[spring-context-4.3.2.release.jar:4.3.2.release] @ org.springframework.context.support.abstractapplicationcontext.registerbeanpostprocessors(abstractapplicationcontext.java:697) ~[spring-context-4.3.2.release.jar:4.3.2.release] @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:526) ~[spring-context-4.3.2.release.jar:4.3.2.release] @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:122) ~[spring-boot-1.4.0.release.jar:1.4.0.release] @ org.springframework.boot.springapplication.refresh(springapplication.java:759) [spring-boot-1.4.0.release.jar:1.4.0.release] @ org.springframework.boot.springapplication.refreshcontext(springapplication.java:369) [spring-boot-1.4.0.release.jar:1.4.0.release] @ org.springframework.boot.springapplication.run(springapplication.java:313) [spring-boot-1.4.0.release.jar:1.4.0.release] @ org.springframework.boot.springapplication.run(springapplication.java:1185) [spring-boot-1.4.0.release.jar:1.4.0.release] @ org.springframework.boot.springapplication.run(springapplication.java:1174) [spring-boot-1.4.0.release.jar:1.4.0.release] @ com.jci.tips.tipsapplication.main(tipsapplication.java:10) [classes/:na] caused by: org.springframework.beans.factory.beancreationexception: error creating bean name 'entitymanagerfactory' defined in class path resource [com/abc/xyz/configuration/databaseconfig.class]: invocation of init method failed; nested exception javax.persistence.persistenceexception: [persistenceunit: default] unable build hibernate sessionfactory @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1578) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:545) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:482) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractbeanfactory$1.getobject(abstractbeanfactory.java:306) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:230) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:302) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:202) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.config.dependencydescriptor.resolvecandidate(dependencydescriptor.java:207) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.defaultlistablebeanfactory.findautowirecandidates(defaultlistablebeanfactory.java:1214) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.defaultlistablebeanfactory.doresolvedependency(defaultlistablebeanfactory.java:1054) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.defaultlistablebeanfactory.resolvedependency(defaultlistablebeanfactory.java:1019) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.annotation.autowiredannotationbeanpostprocessor$autowiredfieldelement.inject(autowiredannotationbeanpostprocessor.java:566) ~[spring-beans-4.3.2.release.jar:4.3.2.release] ... 28 common frames omitted caused by: javax.persistence.persistenceexception: [persistenceunit: default] unable build hibernate sessionfactory @ org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl.persistenceexception(entitymanagerfactorybuilderimpl.java:954) ~[hibernate-entitymanager-5.0.9.final.jar:5.0.9.final] @ org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl.build(entitymanagerfactorybuilderimpl.java:882) ~[hibernate-entitymanager-5.0.9.final.jar:5.0.9.final] @ org.springframework.orm.jpa.vendor.springhibernatejpapersistenceprovider.createcontainerentitymanagerfactory(springhibernatejpapersistenceprovider.java:60) ~[spring-orm-4.3.2.release.jar:4.3.2.release] @ org.springframework.orm.jpa.localcontainerentitymanagerfactorybean.createnativeentitymanagerfactory(localcontainerentitymanagerfactorybean.java:338) ~[spring-orm-4.3.2.release.jar:4.3.2.release] @ org.springframework.orm.jpa.abstractentitymanagerfactorybean.buildnativeentitymanagerfactory(abstractentitymanagerfactorybean.java:373) ~[spring-orm-4.3.2.release.jar:4.3.2.release] @ org.springframework.orm.jpa.abstractentitymanagerfactorybean.afterpropertiesset(abstractentitymanagerfactorybean.java:362) ~[spring-orm-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeinitmethods(abstractautowirecapablebeanfactory.java:1637) ~[spring-beans-4.3.2.release.jar:4.3.2.release] @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1574) ~[spring-beans-4.3.2.release.jar:4.3.2.release] ... 39 common frames omitted caused by: java.lang.illegalargumentexception: name cannot null @ org.hibernate.boot.model.relational.qualifiednameparser$nameparts.<init>(qualifiednameparser.java:34) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.boot.model.relational.qualifiednameimpl.<init>(qualifiednameimpl.java:24) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.boot.model.relational.qualifiedsequencename.<init>(qualifiedsequencename.java:16) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.tool.schema.extract.internal.sequenceinformationextractorlegacyimpl.extractmetadata(sequenceinformationextractorlegacyimpl.java:51) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.tool.schema.extract.internal.databaseinformationimpl.initializesequences(databaseinformationimpl.java:64) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.tool.schema.extract.internal.databaseinformationimpl.<init>(databaseinformationimpl.java:60) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.tool.hbm2ddl.schemaupdate.execute(schemaupdate.java:123) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.tool.hbm2ddl.schemaupdate.execute(schemaupdate.java:101) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.internal.sessionfactoryimpl.<init>(sessionfactoryimpl.java:470) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.boot.internal.sessionfactorybuilderimpl.build(sessionfactorybuilderimpl.java:444) ~[hibernate-core-5.0.9.final.jar:5.0.9.final] @ org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl.build(entitymanagerfactorybuilderimpl.java:879) ~[hibernate-entitymanager-5.0.9.final.jar:5.0.9.final] ... 45 common frames omitted
if change hbm2ddl auto update create-drop working drops , creates tables.
please me here
answering question. using oracle 9i ojdbc7, changed ojdbc6 resolved issue.
ojdbc7 not support oracle 9i.
Comments
Post a Comment