# Dialect is null. What dialect we use for ElasticSearch

**URL:** <https://discourse.hibernate.org/t/dialect-is-null-what-dialect-we-use-for-elasticsearch/4680>\
**Category:** Hibernate ORM\
**Created:** [October 21, 2020, 4:20pm UTC](https://discourse.hibernate.org/t/dialect-is-null-what-dialect-we-use-for-elasticsearch/4680 "2020-10-21T16:20:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![schoppara](https://avatars.discourse-cdn.com/v4/letter/s/3be4f8/32.png) [@schoppara](https://discourse.hibernate.org/u/schoppara)\
**Post date:** [October 21, 2020, 4:20pm UTC](https://discourse.hibernate.org/t/dialect-is-null-what-dialect-we-use-for-elasticsearch/4680/1 "2020-10-21T16:20:43Z")

</div>

Hi,

I am facing the following error which says the hibernate.dialect is null. But my application.properties has the dialect property. Can someone let me know, what was missing in the configuration or what is wrong with the properties that were specified in application.properties. Your help is really appriciated.

Application.properties are listed below and the error that i get is listed below the application.properties.

application.properties

spring.jpa.show-sql=true  
spring.jpa.properties.hibernate.format\_sql=true

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.H2Dialect

logging.level.org.hibernate.SQL=DEBUG  
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE

logging.level.org.springframework.jdbc.core.JdbcTemplate=DEBUG  
logging.level.org.springframework.jdbc.core.StatementCreatorUtils=TRACE

# Hibernate ddl auto (create, create-drop, validate, update)

spring.jpa.hibernate.ddl-auto=update

spring.datasource.hikari.maximum-pool-size=3  
spring.datasource.hikari.connectionTimeout=30000  
spring.datasource.hikari.idleTimeout=30000  
spring.datasource.hikari.maxLifetime=1800000  
spring.datasource.hikari.minimum-idle=1

#####################################################################################

spring.data.elasticsearch.repositories.enabled=true  
spring.data.elasticsearch.cluster-nodes=localhost:9300  
spring.data.elasticsearch.cluster-name=elasticsearch

spring.data.jest.uri=http://localhost:9200

# Specify the DirectoryProvider to use (the Lucene Directory)

spring.jpa.properties.hibernate.search.default.directory\_provider = filesystem

# Using the filesystem DirectoryProvider you also have to specify the default

# base directory for all indexes (make sure that the application have write

# permissions on such directory)

spring.jpa.properties.hibernate.search.default.indexBase = D:/work/indexes

spring.jpa.properties.hibernate.search.default\_backend=elasticsearch  
spring.jpa.properties.hibernate.search.backends.elasticsearch.type=elasticsearch  
spring.jpa.properties.hibernate.search.backends.elasticsearch.hosts=localhost:9200  
spring.jpa.properties.hibernate.search.backends.elasticsearch.protocol=http  
spring.jpa.properties.hibernate.search.backends.elasticsearch.index\_defaults.schema\_management.minimal\_required\_status=yellow  
spring.jpa.properties.hibernate.search.default.elasticsearch.index\_management\_wait\_timeout=60s

spring.jpa.properties.hibernate.search.backends.elasticsearch.request\_timeout=90000  
spring.jpa.properties.hibernate.search.backends.elasticsearch.connection\_timeout=30000  
spring.jpa.properties.hibernate.search.backends.elasticsearch.read\_timeout=90000  
spring.jpa.properties.hibernate.search.backends.elasticsearch.log.json\_pretty\_printing=true

Error:  
Error starting ApplicationContext. To display the conditions report re-run your application with ‘debug’ enabled.  
2020-10-21 21:41:17.943 ERROR 39296 — [main] o.s.boot.SpringApplication : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘entityManagerFactory’ defined in com.a.b.c.NosqlApplication: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:874) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) ~[spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]  
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]  
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]  
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]  
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]  
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]  
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]  
at com.a.b.c.NosqlApplication.main(NosqlApplication.java:20) ~[classes/:na]  
Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]  
at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:275) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.(InFlightMetadataCollectorImpl.java:176) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:118) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:473) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:84) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:689) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.springframework.orm.hibernate5.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:616) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.orm.hibernate5.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:600) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]  
… 17 common frames omitted  
Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set  
at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java:100) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:54) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:137) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
… 34 common frames omitted

Thanks,  
Srikanth C

---

<div class="post-metadata">

**Author:** ![yrodiere](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/yrodiere/32/1760_2.png) [@yrodiere](https://discourse.hibernate.org/u/yrodiere)\
**Post date:** [October 21, 2020, 4:29pm UTC](https://discourse.hibernate.org/t/dialect-is-null-what-dialect-we-use-for-elasticsearch/4680/2 "2020-10-21T16:29:50Z")

</div>

Moving to Hibernate ORM.

Even though you’re using Hibernate Search, this error clearly is related to Hibernate ORM, and Hibernate Search does not care (at all) what dialect you use to communicate with your database.

Regarding your error… I would bet on a configuration problem in Spring Boot.

Make sure you don’t create the `EntityManagerFactory`/`SessionFactory` yourself, but leave that to Spring Boot. You mentioned [here](https://discourse.hibernate.org/t/error-creating-bean-with-name-entitymanagerfactory-defined-in-class-path-resource/4675/2) that you declared an `EntityManagerFactory` bean, and I’m almost certain this wasn’t a good idea.

See [my answer](https://discourse.hibernate.org/t/error-creating-bean-with-name-entitymanagerfactory-defined-in-class-path-resource/4675/3) to solve the problem you had before declaring that bean.