Skip to content
Advertisement

Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set Spring Boot SqlServer

I can not connect Spring boot with SQL Server

spring.datasource.url=jdbc:sqlserver://192.168.134.92;databaseName=Attendance_Device
spring.datasource.username=emon
spring.datasource.password=1234
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
#spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2018Dialect
spring.jpa.hibernate.ddl-auto = false

Advertisement

Answer

I recommend check 3 things

  1. Gradle or pom.xml dependency setting check.
    • Make sure dependencies of SQL set what you using
  2. DB server firewall check
    • Check your server or router. Firewall could be block networking
  3. DB server address or id/pw check
    • Check your DB infos
User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement