A List of JDBC Driver classes and URIs

We can connect to any database using java.To do that first we need to establish a connection with that respective database . We can connect to database using one of FOUR types of JDBC drivers.

1. JDBC-ODBC bridge
2. Native-API Driver
3. Network-Protocol Driver(MiddleWare Driver)
4. Database-Protocol Driver(Pure Java Driver)

Industry uses Type 4 extensively. as they written completely in Java, type 4 drivers are thus platform independent.

And, database driver requires the following input to connect to the respective DB.

• Driver Class
• URI (Includes database instance and port number).

Here you can figure out information of different databases of different vendors.

SNO	DataBase Driver	Driver Class	URI
1	JDBC-ODBC Bridge	sun.jdbc.odbc.JdbcOdbcDriver	jdbc:odbc:<DB>
2	Oracle Thin	oracle.jdbc.driver.OracleDriver	jdbc:oracle:thin:@<HOST>:<PORT>:<SID>
3	IBM DB2	COM.ibm.db2.jdbc.app.DB2Driver	jdbc:db2://<HOST>:<PORT>/<DB>
4	Oracle OCI 8i	oracle.jdbc.driver.OracleDriver	jdbc:oracle:oci8:@<SID>
5	Oracle OCI 9i	oracle.jdbc.driver.OracleDriver	jdbc:oracle:oci:@<SID>
6	Microsoft SQL Server (JTurbo Driver)	com.ashna.jturbo.driver.Driver	jdbc:JTurbo://<HOST>:<PORT>/<DB>
7	Microsoft SQL Server (Sprinta Driver)	com.inet.tds.TdsDriver	jdbc:inetdae:<HOST>:<PORT>?database=<DB>
8	Microsoft SQL Server 2000 (Microsoft Driver)	com.microsoft.sqlserver.jdbc.SQLServerDriver	jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]
9	Microsoft SQL Server	weblogic.jdbc.mssqlserver4.Driver	jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>
10	MySQL (MM.MySQL Driver)	org.gjt.mm.mysql.Driver	jdbc:mysql://<HOST>:<PORT>/<DB>
11	PostgreSQL (v6.5 and earlier)	postgresql.Driver	jdbc:postgresql://<HOST>:<PORT>/<DB>
12	PostgreSQL (v7.0 and later)	org.postgresql.Driver	jdbc:postgresql://<HOST>:<PORT>/<DB>
13	Sybase (jConnect 4.2 and earlier)	com.sybase.jdbc.SybDriver	jdbc:sybase:Tds:<HOST>:<PORT>
14	Sybase (jConnect 5.2)	com.sybase.jdbc2.jdbc.SybDriver	jdbc:sybase:Tds:<HOST>:<PORT>
15	PointBase Embedded Server	com.pointbase.jdbc.jdbcUniversalDriver	jdbc:pointbase://embedded[:<PORT>]/<DB>
16	Cloudscape	COM.cloudscape.core.JDBCDrive	jdbc:cloudscape:<DB>
17	Cloudscape RMI	RmiJdbc.RJDriver	jdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB>
18	Firebird (JCA/JDBC Driver)	org.firebirdsql.jdbc.FBDriver	jdbc:firebirdsql:[//<HOST>[:<PORT>]/]<DB>
19	IDS Server	ids.sql.IDSDriver	jdbc:ids://<HOST>:<PORT>/conn?dsn='<ODBC_DSN_NAME>'
20	Informix Dynamic Server	com.informix.jdbc.IfxDriver	jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME>
21	InstantDB (v3.13 and earlier)	jdbc.idbDriver	jdbc:idb:<DB>
22	InstantDB (v3.14 and later)	org.enhydra.instantdb.jdbc.idbDriver	jdbc:idb:<DB>
23	Interbase (InterClient Driver)	interbase.interclient.Driver	jdbc:interbase://<HOST>/<DB>
24	Hypersonic SQL (v1.2 and earlier)	hSql.hDriver	jdbc:HypersonicSQL:<DB>
25	Hypersonic SQL (v1.3 and later)	org.hsql.jdbcDriver	jdbc:HypersonicSQL:<DB>