Hibernate 支持的数据库方言

曾经终败给现在 2022-07-11 12:20 262阅读 0赞

转自：

[https://my.oschina.net/zimingforever/blog/216909][https_my.oschina.net_zimingforever_blog_216909]

<table> 
 <tbody> 
 <tr> 
 <td> 
 <table style="width:386pt; border-collapse:collapse"> 
 <tbody> 
 <tr style="height:15pt"> 
 <td style="border:1pt solid windowtext; width:141pt; height:15pt; background-color:transparent"> DB2</td> 
 <td style="border-width:1pt 1pt 1pt 0px; border-style:solid solid solid none; border-color:windowtext windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.DB2Dialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> DB2 AS/400</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.DB2400Dialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> DB2 OS390</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.DB2390Dialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> PostgreSQL</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.PostgreSQLDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> MySQL</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.MySQLDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> MySQL with InnoDB</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.MySQLInnoDBDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> MySQL with MyISAM</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.MySQLMyISAMDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Oracle (any version)</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.OracleDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Oracle 9i/10g</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.Oracle9Dialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Sybase</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.SybaseDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Sybase Anywhere</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.SybaseAnywhereDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Microsoft SQL Server</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.SQLServerDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> SAP DB</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.SAPDBDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Informix</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.InformixDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> HypersonicSQL</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.HSQLDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Ingres</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.IngresDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Progress</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.ProgressDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Mckoi SQL</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.MckoiDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Interbase</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.InterbaseDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Pointbase</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.PointbaseDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> FrontBase</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.FrontbaseDialect</td> 
 </tr> 
 <tr style="height:15pt"> 
 <td style="border-width:0px 1pt 1pt; border-style:none solid solid; border-color:black windowtext windowtext; width:141pt; height:15pt; background-color:transparent"> Firebird</td> 
 <td style="border-width:0px 1pt 1pt 0px; border-style:none solid solid none; border-color:black windowtext windowtext black; width:245pt; background-color:transparent"> org.hibernate.dialect.FirebirdDialect</td> 
 </tr> 
 </tbody> 
 </table> </td> 
 </tr> 
 </tbody> 
</table>

[https_my.oschina.net_zimingforever_blog_216909]: https://my.oschina.net/zimingforever/blog/216909