java - HibernateException when trying to access embedded Derby db -
i have deployed embedded derby database intellij in project 
i want access spring application, create hibernate config
@configuration @enabletransactionmanagement public class hibernateconfig { @autowired @bean public sessionfactory getsessionfactory(final datasource datasource) { final localsessionfactorybuilder sessionbuilder = new localsessionfactorybuilder(datasource); sessionbuilder.scanpackages("com.em.daas.entity"); return sessionbuilder.buildsessionfactory(); } } wher com.em.daas location of entity classes, , datasource config:
@configuration @propertysource(testapplication.properties_path) public class localdatasourceconfig { @bean public drivermanagerdatasource derbydatasource() { final drivermanagerdatasource datasource = new drivermanagerdatasource(); datasource.setdriverclassname("org.apache.derby.jdbc.embeddeddriver"); datasource.seturl("jdbc:derby:c:/users/timofb/documents/diploma/daas/src/test/resources/db/metadatastorage"); datasource.setusername(""); datasource.setpassword("123"); return datasource; } } and add application.properties
spring.jpa.database-platform=org.hibernate.dialect.derbydialect spring.jpa.show-sql=false spring.jpa.hibernate.ddl-auto=create (changing derbytenfivedialect, derbytensixdialect , derbytensevendialect doesn't help) exception:
caused by: org.hibernate.service.spi.serviceexception: unable create requested service [org.hibernate.engine.jdbc.env.spi.jdbcenvironment] @ org.hibernate.service.internal.abstractserviceregistryimpl.createservice(abstractserviceregistryimpl.java:244) @ org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:208) @ org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:189) @ org.hibernate.engine.jdbc.internal.jdbcservicesimpl.configure(jdbcservicesimpl.java:51) @ org.hibernate.boot.registry.internal.standardserviceregistryimpl.configureservice(standardserviceregistryimpl.java:94) @ org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:217) @ org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:189) @ org.hibernate.boot.model.process.spi.metadatabuildingprocess.handletypes(metadatabuildingprocess.java:352) @ org.hibernate.boot.model.process.spi.metadatabuildingprocess.complete(metadatabuildingprocess.java:111) @ org.hibernate.boot.model.process.spi.metadatabuildingprocess.build(metadatabuildingprocess.java:83) @ org.hibernate.boot.internal.metadatabuilderimpl.build(metadatabuilderimpl.java:418) @ org.hibernate.boot.internal.metadatabuilderimpl.build(metadatabuilderimpl.java:87) @ org.hibernate.cfg.configuration.buildsessionfactory(configuration.java:692) @ org.hibernate.cfg.configuration.buildsessionfactory(configuration.java:724) @ org.springframework.orm.hibernate4.localsessionfactorybuilder.buildsessionfactory(localsessionfactorybuilder.java:372) @ com.emc.daas.config.hibernateconfig.getsessionfactory(hibernateconfig.java:24) @ com.emc.daas.config.hibernateconfig$$enhancerbyspringcglib$$f623976c.cglib$getsessionfactory$0(<generated>) @ com.emc.daas.config.hibernateconfig$$enhancerbyspringcglib$$f623976c$$fastclassbyspringcglib$$8ece3a4e.invoke(<generated>) @ org.springframework.cglib.proxy.methodproxy.invokesuper(methodproxy.java:228) @ org.springframework.context.annotation.configurationclassenhancer$beanmethodinterceptor.intercept(configurationclassenhancer.java:309) @ com.emc.daas.config.hibernateconfig$$enhancerbyspringcglib$$f623976c.getsessionfactory(<generated>) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:497) @ org.springframework.beans.factory.support.simpleinstantiationstrategy.instantiate(simpleinstantiationstrategy.java:162) ... 36 more caused by: org.hibernate.hibernateexception: access dialectresolutioninfo cannot null when 'hibernate.dialect' not set how can solve this?
i've changed hibernateconfig class like
public sessionfactory getsessionfactory(final datasource datasource) { final localsessionfactorybuilder sessionbuilder = new localsessionfactorybuilder(datasource); properties properties = new properties(); properties.setproperty("hibernate.dialect", "org.hibernate.dialect.derbydialect"); sessionbuilder.addproperties(properties); sessionbuilder.scanpackages("com.em.daas.entity"); return sessionbuilder.buildsessionfactory(); } 
Comments
Post a Comment