Database 管理

JDBC 驱动及使用

Relational Database	Driver Name (qualified class name)	Database URL & Example
MySQL	com.mysql.jdbc.Driver	`jdbc:mysql://<server>:<port>/<databaseName>` Eg: `jdbc:mysql://localhost:3306/myDBName`
H2
Sqlite
TDSQL
MariaDB		jdbc:mariadb://localhost:3306/camunda
Postgre	org.postgresql.Driver	`jdbc:postgresql://<server>:<port>/<databaseName>` Eg: jdbc:postgresql://localhost:5432/myDBName
Oracle	oracle.jdbc.driver.OracleDriver	`jdbc:oracle:thin:@<server>:<port>:<databaseName>` Eg: jdbc:oracle:thin:@localhost:1521:xe
IBM DB2 App	com.ibm.db2.jdbc.app.DB2Driver	`jdbc:db2:<databaseName>` Eg: jdbc:db2:myDBName
IBM DB2 Net	com.ibm.db2.jdbc.net.DB2Driver	`jdbc:db2//<server>:<port>/<databasebName>` Eg: jdbc:db2://localhost:6789/myDBName
Sybase	com.sybase.jdbc.SybDriver	`jdbc:sybase:Tds:<server>:<port>/<databaseName>`Eg: jdbc:sybase:Tds:localhost:4100/myDBName
Teradata	com.teradata.jdbc.TeraDriver	`jdbc:teradata://<server>/database=<databaseName>,tmode=ANSI,charset=UTF8` Eg: jdbc:teradata://localhost/database=myDBName, tmode=ANSI, charset=UTF8
Microsoft SQL Server	com.microsoft.sqlserver.jdbc.SQLServerDriver	`jdbc:sqlserver://<server>:<port>;databaseName=<databaseName>` Eg: jdbc:sqlserver://localhost:1433;databaseName=myDBName
MS Access (JDBC-ODBC Bridge)	sun.jdbc.odbc.JdbcOdbcDriver	`jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=<myDBName.mdb>;` Eg: jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=myDBName.mdb;