JDBC: List of Drivers for Databases

In previous post you learn about   JDBC: Drivers Types and Uses. Here are JDBC supported database drivers and connection URL format. You can also check corresponding examples for more detail on it.

JDBC Supported Database Drivers List and URLs

Relational DatabaseDriver Name
(Qualified Class Name)
Database URL & Example
Oraclecom.mysql.jdbc.Driverjdbc:oracle:thin:@<server>
:<port>:<databaseName>
Eg: jdbc:oracle:thin:@localhost
:1521:xe
MySQLcom.mysql.jdbc.Driverjdbc:mysql://<server>
:<port>/<databaseName>
Eg: jdbc:mysql://localhost
:3306/myDBName
IBM DB2 Appcom.ibm.db2.jdbc.app.DB2Driverjdbc:db2:<databaseName>
Eg: jdbc:db2:FacingIssuesOnITDb
IBM DB2 Netcom.ibm.db2.jdbc.net.DB2Driverjdbc:db2//<server>
:<port>/<databasebName>
Eg: jdbc:db2://localhost:6789/FacingIssuesOnITDb
Sybasecom.sybase.jdbc.SybDriverjdbc:sybase:Tds:<server>
:<port>/<databaseName>
Eg:jdbc:sybase:Tds:localhost
:4100/FacingIssuesOnITDb
Microsoft SQL Servercom.microsoft.sqlserver
.jdbc.SQLServerDriver
jdbc:sqlserver://<server>
:<port>/databaseName=<databaseName>
Eg:jdbc:sqlserver://localhost
:1433;databaseName=FacingIssuesOnITDb
Postgreorg.postgresql.Driverjdbc:postgresql://<server>
:<port>/<databaseName>
<b>Eg:</b> jdbc:postgresql://localhost
:5432/FacingIssuesOnITDb
MS Access (JDBC-ODBC Bridge)sun.jdbc.odbc.JdbcOdbcDriverjdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};
DBQ=<myDBName.mdb>;
Eg: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};
DBQ=FacingIssuesOnITDb.mdb;
Teradatacom.teradata.jdbc.TeraDriverjdbc:teradata://<server>
/database=<databaseName>
,tmode=ANSI,charset=UTF8

Eg:jdbc:teradata://localhost
/database=FacingIssuesOnITDb
, tmode=ANSI, charset=UTF8
Elasticsearchjdbc:es://[http|https]?[host[:port]]*/[prefix]*[?[option=value]&]*

eg: jdbc:es://http://server:3456/timezone=UTC&page.size=250

Elasticsearch driver introduce in Elasticsearch 6+ version  and support with Java 8+. You can see more detail on it on Elasticsearch Tutorial.

More on JDBC

Follow below links to know more on JDBC and solving JDBC issues :

JDBC Tutorial

JDBC Sample Code

JDBC Issues and Solutions

JDBC Interview Questions And Answers

Advertisements

This site uses Akismet to reduce spam. Learn how your comment data is processed.