以下提供的代码,可以实现Hibernate多数据库的连接方言。
- < session-factory>< property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver< /property>
- < property name="connection.url">jdbc:jtds:sqlserver://ALEX:1134/News< /property>
- < !--for oracle 9
- < property name="dialect">org.hibernate.dialect.Oracle9Dialect< /property>
- -->
- < !--for Mysql
- < property name="dialect">org.hibernate.dialect.MySQLDialect< /property>
- -->
- < !--for Ms SQL Server-->
- < property name="dialect">org.hibernate.dialect.SQLServerDialect< /property>
- < property name="connection.username">sa< /property>
- < property name="connection.password">sa< /property>
- < property name="show_sql">true< /property>< /session-factory>
RDBMS 方言
- DB2 org.hibernate.dialect.DB2Dialect
- DB2 AS/400 org.hibernate.dialect.DB2400Dialect
- DB2 OS390 org.hibernate.dialect.DB2390Dialect
- PostgreSQL org.hibernate.dialect.PostgreSQLDialect
- MySQL org.hibernate.dialect.MySQLDialect
- MySQL with InnoDB org.hibernate.dialect.MySQLInnoDBDialect
- MySQL with MyISAM org.hibernate.dialect.MySQLMyISAMDialect
- Oracle (any version) org.hibernate.dialect.OracleDialect
- Oracle 9i/10g org.hibernate.dialect.Oracle9Dialect
- Sybase org.hibernate.dialect.SybaseDialect
- Sybase Anywhere org.hibernate.dialect.SybaseAnywhereDialect
- Microsoft SQL Server org.hibernate.dialect.SQLServerDialect
- SAP DB org.hibernate.dialect.SAPDBDialect
- Informix org.hibernate.dialect.InformixDialect
- HypersonicSQL org.hibernate.dialect.HSQLDialect
- Ingres org.hibernate.dialect.IngresDialect
- Progress org.hibernate.dialect.ProgressDialect
- Mckoi SQL org.hibernate.dialect.MckoiDialect
- Interbase org.hibernate.dialect.InterbaseDialect
- Pointbase org.hibernate.dialect.PointbaseDialect
- FrontBase org.hibernate.dialect.FrontbaseDialect
- Firebird org.hibernate.dialect.FirebirdDialect
【编辑推荐】