mysql database.dialect_JDBC各种数据库的连接驱动及url、dialect
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
111111
5、连接db2驱动类：com.ibm.db2.jdbc.app.db2driver连接字符串：jdbc:db2://192.168.1.10/50000:rdb(这里192.168.1.10为数据库所在服务器ip地址，而50000为db2连接服务的端口号)6、链接sybase驱动类：com.sybase.jdbc3.jdbc.sybdriver连接字符串：jdbc:sybase:tds:192.168.100.252:4500/mydb(这里192.168.100.252为数据库所在服务器ip地址，而4500为sybase连接服务的端口号mydb为数据库的名字)7、链接informix驱动类：com.informix.jdbc.ifxdriver
3.dialect
DB2org.hibernate.dialect.DB2Dialect
DB2 AS/400org.hibernate.dialect.DB2400Dialect
DB2 OS390org.hibernate.dialect.DB2390Dialect
PostgreSQLorg.hibernate.dialect.PostgreSQLDialect
MySQLorg.hibernate.dialect.MySQLDialect
MySQL with InnoDBorg.hibernate.dialect.MySQLInnoDBDialect
MySQL with MyISAMorg.hibernate.dialect.MySQLMyISAMDialect
Oracle (any version)org.hibernate.dialect.OracleDialect
Oracle 9i/10gorg.hibernate.dialect.Oracle9Dialect
Sybaseorg.hibernate.dialect.SybaseDialect
Sybase Anywhereorg.hibernate.dialect.SybaseAnywhereDialect
Microsoft SQL Serverorg.hibernate.dialect.SQLServerDialect
SAP DBorg.hibernate.dialect.SAPDBDialect
Informixorg.hibernate.dialect.InformixDialect
HypersonicSQLorg.hibernate.dialect.HSQLDialect
Ingresorg.hibernate.dialect.IngresDialect
Progressorg.hibernate.dialect.ProgressDialect
Mckoi SQLorg.hibernate.dialect.MckoiDialect
Interbaseorg.hibernate.dialect.InterbaseDialect
Pointbaseorg.hibernate.dialect.PointbaseDialect
FrontBaseorg.hibernate.dialect.FrontbaseDialect
Firebirdorg.hibernate.dialect.FirebirdDialect