Database Types and JDBC Drivers

oracle.jdbc.driver.OracleDriver

For more information on Oracle JDBC drivers, refer to: http://www.oracle.com/technetwork/topics/jdbc-faq-090281.html

ojdbc5.jar (JRE 5.x)

ojdbc6.jar (JRE 6.x, 7.x)

jdbc:oracle:thin:@<HOST>:<PORT>:<SID>

-

1521

oracle.jdbc.driver.OracleDriver  

ojdbc6.jar (JRE 6.x)

ojdbc7.jar (JRE 7.x and 8.x)

jdbc:oracle:thin:@<HOST>:<PORT>:<SID>

-

1521

com.microsoft.sqlserver.jdbc.SQLServerDriver

For more information on Microsoft SQL Server drivers, refer to:
https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver

sqljdbc41.jar (JRE 1.7)

sqljdbc42.jar (JRE 1.8)

jdbc: sqlserver://<HOST>:<PORT>

sa

1433

com.sybase.jdbc4.jdbc.SybDriver

jconn4.jar

jdbc:sybase:Tds:<HOST>:<PORT>?CHARSET=iso_1

sa

5000

com.mysql.jdbc.Driver

mysql-connector-java-5.1.7-bin.jar

jdbc:mysql://localhost:3306/information_schema

root

3306

com.ibm.db2.jcc.DB2Driver

For more information on IBM DB2 drivers, refer to:

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_cjvintro.html

db2jcc4.jar and db2jcc_license_cu.jar

jdbc:db2://localhost:50000/<DB>

db2admin

446 or

6789 or

50000

com.ibm.db2.jcc.DB2Driver

(Type 2 Driver with IBM DB2 Client Software)

db2jcc4.jar

jdbc:db2://localhost:50000/<DB>

db2admin

446 or

6789 or

50000

com.ibm.db2.jdbc.net.DB2Driver

(Type 3 Driver with IBM DB2 Client Software)

db2jcc4.jar/db2jcc.jar

jdbc:db2://localhost:50000/<DB>

db2admin

446 or

6789 or

50000

org.postgresql.Driver

postgresql-42.2.8.jar

jdbc:postgresql://localhost:5432/

postgres