Springboot启动失败，报错'hibernate.dialect' not set

你的名字 2023-07-18 02:52 22阅读 0赞

### 报错信息： ###

今天启动了一个工程，报错信息如下：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk2ODIzNA_size_16_color_FFFFFF_t_70]

重点信息：

Caused by: org.hibernate.service.spi.ServiceException: 
    Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
    ...
    Caused by: org.hibernate.HibernateException: 
    Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

### 报错原因： ###

是因为没有加Hibernate SQL方言导致的

### 解决方案： ###

增加一行配置

spring.jpa.database-platform=org.hibernate.dialect.MySQLDialect

### 附件 ###

其他Hibernate SQL方言

<table> 
 <thead> 
  <tr> 
   <th>数据库</th> 
   <th align="center">方言</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>DB2</td> 
   <td align="center">org.hibernate.dialect.DB2Dialect</td> 
  </tr> 
  <tr> 
   <td>DB2 AS/400</td> 
   <td align="center">org.hibernate.dialect.DB2400Dialect</td> 
  </tr> 
  <tr> 
   <td>DB2 OS390</td> 
   <td align="center">org.hibernate.dialect.DB2390Dialect</td> 
  </tr> 
  <tr> 
   <td>PostgreSQL</td> 
   <td align="center">org.hibernate.dialect.PostgreSQLDialect</td> 
  </tr> 
  <tr> 
   <td>MySQL</td> 
   <td align="center">org.hibernate.dialect.MySQLDialect</td> 
  </tr> 
  <tr> 
   <td>MySQL with InnoDB</td> 
   <td align="center">org.hibernate.dialect.MySQLInnoDBDialect</td> 
  </tr> 
  <tr> 
   <td>MySQL with MyISAM</td> 
   <td align="center">org.hibernate.dialect.MySQLMyISAMDialect</td> 
  </tr> 
  <tr> 
   <td>Oracle (any version)</td> 
   <td align="center">org.hibernate.dialect.OracleDialect</td> 
  </tr> 
  <tr> 
   <td>Oracle 9i/10g</td> 
   <td align="center">org.hibernate.dialect.Oracle9Dialect</td> 
  </tr> 
  <tr> 
   <td>Sybase</td> 
   <td align="center">org.hibernate.dialect.SybaseDialect</td> 
  </tr> 
  <tr> 
   <td>Sybase Anywhere</td> 
   <td align="center">org.hibernate.dialect.SybaseAnywhereDialect</td> 
  </tr> 
  <tr> 
   <td>Microsoft SQL Server</td> 
   <td align="center">org.hibernate.dialect.SQLServerDialect</td> 
  </tr> 
  <tr> 
   <td>SAP DB</td> 
   <td align="center">org.hibernate.dialect.SAPDBDialect</td> 
  </tr> 
  <tr> 
   <td>Informix</td> 
   <td align="center">org.hibernate.dialect.InformixDialect</td> 
  </tr> 
  <tr> 
   <td>HypersonicSQL</td> 
   <td align="center">org.hibernate.dialect.HSQLDialect</td> 
  </tr> 
  <tr> 
   <td>Ingres</td> 
   <td align="center">org.hibernate.dialect.IngresDialect</td> 
  </tr> 
  <tr> 
   <td>Progress</td> 
   <td align="center">org.hibernate.dialect.ProgressDialect</td> 
  </tr> 
  <tr> 
   <td>Mckoi SQL</td> 
   <td align="center">org.hibernate.dialect.MckoiDialect</td> 
  </tr> 
  <tr> 
   <td>Interbase</td> 
   <td align="center">org.hibernate.dialect.InterbaseDialect</td> 
  </tr> 
  <tr> 
   <td>Pointbase</td> 
   <td align="center">org.hibernate.dialect.PointbaseDialect</td> 
  </tr> 
  <tr> 
   <td>FrontBase</td> 
   <td align="center">org.hibernate.dialect.FrontbaseDialect</td> 
  </tr> 
  <tr> 
   <td>Firebird</td> 
   <td align="center">org.hibernate.dialect.FirebirdDialect</td> 
  </tr> 
 </tbody> 
</table>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk2ODIzNA_size_16_color_FFFFFF_t_70]: /images/20230528/5165505bc109409786995ca920f56195.png