1.驱动
mysql----->com.mysql.jdbc.Driver
oracle----->oracle.jdbc.driver.OracleDriver
sql server----->
2000----com.microsoft.jdbc.sqlserver.SQLServerDriver
2005----com.microsoft.sqlserver.jdbc.SQLServerDriver
postgre----->org.postgresql.Driver
2.连接url
mysql----->jdbc:mysql://127.0.0.1:3306/test
root
1234
oracle----->jdbc:oracle:thin:@127.0.0.1:1521:test
root
root
sql server----->
2000-----jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test
2005-----jdbc:sqlserver://localhost:1433; DatabaseName=test
sa
(空字符串)
postgre----->jdbc:postgresql://127.0.0.1:5432/test
postgres
mysql----->com.mysql.jdbc.Driver
oracle----->oracle.jdbc.driver.OracleDriver
sql server----->
2000----com.microsoft.jdbc.sqlserver.SQLServerDriver
2005----com.microsoft.sqlserver.jdbc.SQLServerDriver
postgre----->org.postgresql.Driver
2.连接url
mysql----->jdbc:mysql://127.0.0.1:3306/test
root
1234
oracle----->jdbc:oracle:thin:@127.0.0.1:1521:test
root
root
sql server----->
2000-----jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test
2005-----jdbc:sqlserver://localhost:1433; DatabaseName=test
sa
(空字符串)
postgre----->jdbc:postgresql://127.0.0.1:5432/test
postgres
111111
3.dialect
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 |