Macam - Macam Koneksi Database JDBC - Java dan Library

Bahasa pemrograman yang sangat dinamis yaitu bahasa promgraman yg dapat terkoneksi ke berbagai macam database. Salah satu bahasa pemrograman tersebut adalah JAVA. Artikel ini menyajikan beberapa macam JDBC (Java Database Connectivity) atau koneksi database java berikut dengan Library yang dibutuhkan.

 

IBM DB2

Koneksi = jdbc:db2://:/

Library = COM.ibm.db2.jdbc.app.DB2Driver

JDBC-ODBC Bridge

Koneksi = jdbc:odbc:

Library = sun.jdbc.odbc.JdbcOdbcDriver

Microsoft SQL Server

Koneksi = jdbc:weblogic:mssqlserver4:@:

Library = weblogic.jdbc.mssqlserver4.Driver

Oracle Thin

Koneksi = jdbc:oracle:thin:@::

Library = oracle.jdbc.driver.OracleDriver

PointBase Embedded Server

Koneksi = jdbc:pointbase://embedded[:]/

Library = com.pointbase.jdbc.jdbcUniversalDriver

Cloudscape

Koneksi = jdbc:cloudscape:

Library = COM.cloudscape.core.JDBCDriver

Cloudscape RMI

Koneksi = jdbc:rmi://:/jdbc:cloudscape:

Library = RmiJdbc.RJDriver

Firebird (JCA/JDBC Driver)

Koneksi = jdbc:firebirdsql:[//[:]/]

Library = org.firebirdsql.jdbc.FBDriver

IDS Server

Koneksi = jdbc:ids://:/conn?dsn=”

Library = ids.sql.IDSDriver

Informix Dynamic Server

Koneksi = jdbc:informix-sqli://:/:INFORMIXSERVER=

Library = com.informix.jdbc.IfxDriver

InstantDB (v3.13 and earlier)

Koneksi = jdbc:idb:

Library = jdbc.idbDriver

InstantDB (v3.14 and later)

Koneksi = jdbc:idb:

Library = org.enhydra.instantdb.jdbc.idbDriver

Interbase (InterClient Driver)

Koneksi = jdbc:interbase:///

Library = interbase.interclient.Driver

Hypersonic SQL (v1.2 and earlier)

Koneksi = jdbc:HypersonicSQL:

Library = hSql.hDriver

Hypersonic SQL (v1.3 and later)

Koneksi = jdbc:HypersonicSQL:

Library = org.hsql.jdbcDriver

Microsoft SQL Server (JTurbo Driver)

Koneksi = jdbc:JTurbo://:/

Library = com.ashna.jturbo.driver.Driver

Microsoft SQL Server (Sprinta Driver)

Koneksi = jdbc:inetdae::?database=

Library = com.inet.tds.TdsDriver

Microsoft SQL Server 2000 (Microsoft Driver)

Koneksi = jdbc:microsoft:sqlserver://:[;DatabaseName=]

Library = com.microsoft.jdbc.sqlserver.SQLServerDriver

MySQL (MM.MySQL Driver)

Koneksi = jdbc:mysql://:/

Library = org.gjt.mm.mysql.Driver

Oracle OCI 8i

Koneksi = jdbc:oracle:oci8:@

Library = oracle.jdbc.driver.OracleDriver

Oracle OCI 9i

Koneksi = jdbc:oracle:oci:@

Library = oracle.jdbc.driver.OracleDriver

PostgreSQL (v6.5 and earlier)

Koneksi = jdbc:postgresql://:/

Library = postgresql.Driver

PostgreSQL (v7.0 and later)

Koneksi = jdbc:postgresql://:/

Library = org.postgresql.Driver

Sybase (jConnect 4.2 and earlier)

Koneksi = jdbc:sybase:Tds::

Library = com.sybase.jdbc.SybDriver

Sybase (jConnect 5.2)

Koneksi = jdbc:sybase:Tds::

Library = com.sybase.jdbc2.jdbc.SybDriver