Memo - Drivers JDBC

Un petit mémo afin d'avoir la liste des configurations des drivers JDBC des principales bases de données. C'est toujours un casse tête pour retrouver ces configurations, un petit index est toujours utile.


IBM DB2

Driver Class: com.ibm.db2.jdbc.app.DB2Driver
Default Port: ???
JDBC URL: jdbc:db2://[host][:port]/[database]
Hibernate Dialect:
     org.hibernate.dialect.DB2Dialect
     org.hibernate.dialect.DB2400Dialect (DB2 AS/400)
     org.hibernate.dialect.DB2390Dialect (DB2 OS390)


HypersonicSQL

Driver Class:
     org.hsqldb.jdbcDriver (v1.x)
     org.hsqldb.jdbc.JDBCDriver (v2.x)
Default Port: 9001
JDBC URL: jdbc:hsqldb:hsql://[host][:port]/[database][;propertyName1=propertyValue1][;propertyName2=propertyValue2]...
Hibernate Dialect: org.hibernate.dialect.HSQLDialect


MySQL (Connector/J)

Driver Class: com.mysql.jdbc.Driver
Default Port: 3306
JDBC URL:
     jdbc:mysql://[host][,failoverhost...][:port]/[database]
     jdbc:mysql://[host][,failoverhost...][:port]/[database][?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...
Hibernate Dialect:
     org.hibernate.dialect.MySQLDialect
     org.hibernate.dialect.MySQLInnoDBDialect (InnoDB)
     org.hibernate.dialect.MySQLMyISAMDialect (MyIsam)


Oracle 9i/10g

Driver Class: oracle.jdbc.driver.OracleDriver
Default Port: 1521
JDBC URL: jdbc:oracle:thin:@[host]:[port]:[sid]
Hibernate Dialect:
     org.hibernate.dialect.OracleDialect (Toute version)
     org.hibernate.dialect.Oracle9iDialect (9i)
     org.hibernate.dialect.Oracle10gDialect (10g)