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.

Relational DatabaseDriver NameDatabase URL & Example
Oraclecom.oracle.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://&lt;server&gt;
/database=&lt;databaseName&gt;
,tmode=ANSI,charset=UTF8
 
<b>Eg:</b>jdbc:teradata://localhost
/database=FacingIssuesOnITDb
, tmode=ANSI, charset=UTF8
Elasticsearchjdbc:es//[http|https]?[host[:port]]*/[prefix]*[?[option=value]&]*
Ex:
jdbc:es://http://server:3456/timezone-UTC&page.size=250
JDBC Supported Database Drivers

Learn More on JDBC

Follow below links to learn more on JDBC and solving JDBC related issues :

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s