1. MySQL:
DriverClass:com.mysql.jdbc.Driver
Org.gjt.mm.mysql.Driver
Jdbcurl:jdbc:mysql://192.168.0.1:3306/yourdbname
2. Oracle:
(Thin mode)
DriverClass:oracle.jdbc.driver.OracleDriver
Jdbcurl:jdbc:oracle:thin:@192.168.0.1:1521:yourdbname
3. SQL Server:
DriverClass:com.microsoft.sqlserver.jdbc.SQLServerDriver (version 2005 and later)
Com.microsoft.jdbc.sqlserver.SQLServerDriver (version 2000)
Jdbcurl:jdbc:sqlserver://192.168.0.1:1433;databasename=yourdbname
4. Sybase:
DriverClass:com.sybase.jdbc3.jdbc.SybDriver
Com.sysbase.jdbc.SybDriver
Jdbcurl:jdbc:sybase:tds:127.0.0.1:5007/mydb
5, DB2:
1) Db2java.zip
DriverClass:COM.ibm.db2.jdbc.net.DB2Driver
jdbcurl:jdbc:db2://127.0.0.1:5000/dbname
2) Db2jcc.jar
DriverClass:com.ibm.db2.jcc.DB2Driver
jdbcurl:jdbc:db2://127.0.0.1:5000/dbname
3) driverClass:com.ibm.db2.jdbc.app.DB2Driverjdbcurl:jdbc:db2://127.0.0.1:5000/yourdbname
6. Informix:
DriverClass:com.informix.jdbc.IfxDriver
Jdbcurl:jdbc:informix-sqli://127.0.0.1:1533/yourdbname:informixserver=myserver;user=test;password=test123
7. PostgreSQL:
DriverClass:org.postgresql.Driver
Jdbcurl:jdbc:postgresql://127.0.0.1:5432/yourdbname
8. Access:
DriverClass:sun.jdbc.odbc.JdbcOdbcDriver
JdbcUrl:jdbc:odbc:dataSourceName
9, Memcached:
Driverclass:
Jdbcurl:
10. MongoDB:
Driverclass:
Jdbcurl:
11. Redis:
Driverclass:
Jdbcurl:
12, SQLite:
Driverclass:
Jdbcurl:
Driverclass:
Jdbcurl:
Database connection driver class and JDBC URL Daquan