List of JDBC Driver


 

List of JDBC Driver

In this tutorial you will see different drivers for different database applications

In this tutorial you will see different drivers for different database applications

List of JDBC Drivers

JDBC driver is a software component, which enables the java application to connect to a database. There are so many good database applications are present today, to connect a java application to any particular database we need its JDBC driver. Therefore we requires JDBC driver for database application. It gives the connection to the database and implements the protocol for querying and transferring data between application and database.

The table given below shows the list of JDBC drivers-

Database Name
Driver
Driver Class
IBM DB2 dbc:db2://<HOST>:<PORT>/<DB> COM.ibm.db2.jdbc.app.DB2Driver
JDBC-ODBC Bridge jdbc:odbc:<DB> sun.jdbc.odbc.JdbcOdbcDriver
Microsoft SQL Server jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT> weblogic.jdbc.mssqlserver4.Driver
Oracle Thin jdbc:oracle:thin:@<HOST>:<PORT>:<SID> oracle.jdbc.driver.OracleDriver
PointBase Embedded Server jdbc:pointbase://embedded[:<PORT>]/<DB> com.pointbase.jdbc.jdbcUniversalDriver
Cloudscape jdbc:cloudscape:<DB> COM.cloudscape.core.JDBCDriver
Cloudscape RMI jdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB> RmiJdbc.RJDriver
Firebird (JCA/JDBC Driver) jdbc:firebirdsql:[//<HOST>[:<PORT>]/]<DB> org.firebirdsql.jdbc.FBDriver
IDS Server jdbc:ids://<HOST>:<PORT>/conn?dsn='<ODBC_DSN_NAME>' ids.sql.IDSDriver
Informix Dynamic Server jdbc:informix-sqli://<HOST>:<PORT>/<DB>:
INFORMIXSERVER=<SERVER_NAME>
com.informix.jdbc.IfxDriver
InstantDB (v3.13 and earlier) jdbc:idb:<DB> jdbc.idbDriver
InstantDB (v3.14 and later) jdbc:idb:<DB> org.enhydra.instantdb.jdbc.idbDriver
Interbase (InterClient Driver) jdbc:interbase://<HOST>/<DB> interbase.interclient.Driver
Hypersonic SQL (v1.2 and earlier) jdbc:HypersonicSQL:<DB> hSql.hDriver
Hypersonic SQL (v1.3 and later) jdbc:HypersonicSQL:<DB> org.hsql.jdbcDriver
Microsoft SQL Server (JTurbo Driver) jdbc:JTurbo://<HOST>:<PORT>/<DB> com.ashna.jturbo.driver.Driver
Microsoft SQL Server (Sprinta Driver) jdbc:inetdae:<HOST>:<PORT>?database=<DB> com.inet.tds.TdsDriver
Microsoft SQL Server 2000 (Microsoft Driver) jdbc:microsoft:sqlserver://<HOST>:<PORT>
[;DatabaseName=<DB>]

com.microsoft.sqlserver.jdbc. SQLServerDriver

MySQL (MM.MySQL Driver) jdbc:mysql://<HOST>:<PORT>/<DB> org.gjt.mm.mysql.Driver
Oracle OCI 8i jdbc:oracle:oci8:@<SID> oracle.jdbc.driver.OracleDriver
Oracle OCI 9i jdbc:oracle:oci:@<SID> oracle.jdbc.driver.OracleDriver
PostgreSQL (v6.5 and earlier) jdbc:postgresql://<HOST>:<PORT>/<DB> postgresql.Driver
PostgreSQL (v7.0 and later) jdbc:postgresql://<HOST>:<PORT>/<DB> org.postgresql.Driver
Sybase (jConnect 4.2 and earlier) jdbc:sybase:Tds:<HOST>:<PORT> com.sybase.jdbc.SybDriver
Sybase (jConnect 5.2) jdbc:sybase:Tds:<HOST>:<PORT> com.sybase.jdbc2.jdbc.SybDriver

 

Ads