jdbc drivers and url

15
Cache Intersystems Cache JDBC The Cache JDBC Driver is a pure Java driver. Required File(s) CacheDB.jar Default Driver Class com.intersys.jdbc.CacheDriver JDBC URL Format jdbc:Cache://<host>:<port>/<namespace> More information and download Cache DaffodilDB DaffodilDBDriver - Embedded In the Embedded Edition of Daffodil DB (when invoked from an application running on the same JVM as Daffodil DB), the JDBC driver supports connections to a Daffodil DB database in the local mode. Network transport is not required to access the database. In Networked (Client/Server) mode, the client application dispatches JDBC requests to the Daffodil DB server over a network. Applications running in embedded mode use a different driver from that used by applications running in the client/server mode. Required File(s) DaffodilDB_Embedded.jar DaffodilDB_Common.jar Default Driver Class in.co.daffodil.db.jdbc.DaffodilDBDriver

Upload: satyanarayana

Post on 10-Apr-2015

2.113 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: Jdbc Drivers and Url

Cache

Intersystems Cache JDBC

The Cache JDBC Driver is a pure Java driver.

Required File(s)CacheDB.jar

Default Driver Classcom.intersys.jdbc.CacheDriver

JDBC URL Formatjdbc:Cache://<host>:<port>/<namespace>

More information and downloadCache

DaffodilDB

DaffodilDBDriver - Embedded

In the Embedded Edition of Daffodil DB (when invoked from an application running on the same JVM as Daffodil DB), the JDBC driver supports connections to a Daffodil DB database in the local mode. Network transport is not required to access the database. In Networked (Client/Server) mode, the client application dispatches JDBC requests to the Daffodil DB server over a network.

Applications running in embedded mode use a different driver from that used by applications running in the client/server mode.

Required File(s)DaffodilDB_Embedded.jarDaffodilDB_Common.jar

Default Driver Classin.co.daffodil.db.jdbc.DaffodilDBDriver

JDBC URL Formatjdbc:daffodilDB_embedded:<database>

Page 2: Jdbc Drivers and Url

More information and downloadDaffodilDB

NotesThe JDBC driver files are part of the database software

DaffodilDBDriver - Server

The Daffodil DB JDBC driver is a native protocol for all Java drivers (Type #4 among the categories defined by Sun Microsystems). Type 4 drivers are direct-to-database, pure Java drivers ("thin" driver). Type 4 drivers takes JDBC calls and translates them into the network protocol (proprietary protocol) used directly by any Database Management System (DBMS). Thus, client machines or application servers can make direct calls to the DBMS server. Type 4 drivers provide faster performance and direct access to DBMS features.

Required File(s)DaffodilDB_client.jar

Default Driver Classin.co.daffodil.db.rmi.RmiDaffodilDBDriver

JDBC URL Formatjdbc:daffodilDB://<host>:<port3456>/<database>

More information and downloadDaffodilDB

NotesThe JDBC driver files are part of the database software

DB2 for Windows/Linux

IBM DB2 JDBC Universal Driver

The IBM Data Server Driver for JDBC and SQLJ (formerly known as IBM Driver for JDBC and SQLJ) is a single application driver to support the most demanding Java applications. This agile driver can be used as in type 4 or type 2 mode.

This driver is co-packaged with DbVisualizer.

Required File(s)db2jcc.jar

Page 3: Jdbc Drivers and Url

db2jcc4.jardb2jcc_license_cu.jar (optional)

Default Driver Classcom.ibm.db2.jcc.DB2Driver

JDBC URL Formatjdbc:db2://<host>:<port50000>/<database>

More information and downloadIBM

NotesThe driver property retrieveMessagesFromServerOnGetMessage can be very useful to set. Its purpose is to tell the JDBC driver to present informative messages in the SQL Commander instead of anonymous codes. Add it to the driver properties list for the actual database connection. Set the value to true.

FrontBase

FrontBase JDBC Driver

FrontBase JDBC driver

Required File(s)frontbasejdbc.jar

Default Driver Classcom.frontbase.jdbc.FBJDriver

JDBC URL Formatjdbc:FrontBase://<host>:<port>/<database>

More information and downloadFrontBase

NotesDriver Read Me

HSQLDB

Page 4: Jdbc Drivers and Url

HSQLDB Database Engine Driver - Embedded

HSQLDB JDBC Driver

Required File(s)hsqldb.jar

Default Driver Classorg.hsqldb.jdbcDriver

JDBC URL Formatjdbc:hsqldb:<database>

More information and downloadHSQLDB Community

NotesThe JDBC driver file is part of the database software

HSQLDB Database Engine Driver - Server

HSQLDB JDBC Driver

Required File(s)hsqldb.jar

Default Driver Classorg.hsqldb.jdbcDriver

JDBC URL Formatjdbc:hsqldb:hsql://<host>:<port>

More information and downloadHSQLDB Community

NotesThe JDBC driver file is part of the database software

Informix

Page 5: Jdbc Drivers and Url

Informix JDBC Driver

A Java database connectivity (JDBC) driver -- the JavaSoft specification of a standard API that allows Java programs to access database management systems.

Required File(s)ifxjdbc.jar

Default Driver Classcom.informix.jdbc.IfxDriver

JDBC URL Formatjdbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>

More information and downloadIBM

NotesFollow the instructions provided with the downloaded file

JavaDB/Derby

Apache Derby

JavaDB/Derby is a full-featured, open source relational database management system (RDBMS) that is based on Javaâ„¢ and SQL.

This driver is co-packaged with DbVisualizer.

Required File(s)derbyclient.jar

Default Driver Classorg.apache.derby.jdbc.ClientDriver

JDBC URL Format

Page 6: Jdbc Drivers and Url

jdbc:derby:net://<host>:<port1527>/<databaseName>

More information and downloadApache Software Foundation

Microsoft SQL Server

SQL Server 2000 Driver for JDBC

The Microsoft SQL Server 2000 Driver for JDBC is a Type 4 JDBC driver that provides highly scalable and reliable connectivity for the enterprise Java environment. This driver provides JDBC access to SQL Server 2000 through any Java-enabled applet, application, or application server.

Required File(s)mssqlserver.jarmsbase.jarmsutil.jar

Default Driver Classcom.microsoft.jdbc.sqlserver.SQLServerDriver

JDBC URL Formatjdbc:microsoft:sqlserver://<host>:<port1433>;DatabaseName=<database>

More information and downloadMicrosoft

Microsoft SQL Server 2005 JDBC Driver

The SQL Server 2005 JDBC Driver is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000 and SQL Server 2005 from any Java application, application server, or Java-enabled applet. This driver is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs).

Required File(s)sqljdbc.jar

Default Driver Classcom.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC URL Format

Page 7: Jdbc Drivers and Url

jdbc:sqlserver://<host>[:<port1433>];databaseName=<database>

More information and downloadMicrosoft

jTDS JDBC Driver

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12, 15).

This driver is co-packaged with DbVisualizer.

Required File(s)jtds-1.2.2.jar

Default Driver Classnet.sourceforge.jtds.jdbc.Driver

JDBC URL Formatjdbc:jtds:microsoft://<host>[:<port>][/<database>]

Example:jdbc:jdtds:microsoft://localhost:5000/myDBjdbc:jdtds:microsoft://192.168.10.201:5000/SAMPLE

More information and downloadjTDS web site

NotesInstallation Notes: Download the jtds-nn-dist.zip file, unzip it and then load the jtds.jar file in the DbVisualizer Tools->Driver Manager or in the Tools->Connection Wizard.

Mimer

Mimer JDBC Driver

Mimer JDBC Drivers provide access to Mimer SQL databases from Java applications and applets.

This zip file contains documentation and jar file for the Mimer JDBC Driver, which supports the JDBC 3 specification. The provided guide describes how the mimjdbc3.jar driver should be used, some programming examples and a change history.

Page 8: Jdbc Drivers and Url

This driver is co-packaged with DbVisualizer.

Required File(s)mimjdbc3.jar

Default Driver Classcom.mimer.jdbc.Driver

JDBC URL Formatjdbc:mimer://<host>:<port>/<database>

More information and downloadMimer Information Technology

MySQL

MySQL Connector/J JDBC Driver

MySQL Connector/J is the official JDBC driver for MySQL.

This driver is co-packaged with DbVisualizer.

Required File(s)mysql-connector-java-nn-bin.jar

Default Driver Classcom.mysql.jdbc.Driver

JDBC URL Formatjdbc:mysql://<host>:<port3306>/<database>

Example:jdbc:mysql://localhost:3306/empdbjdbc:mysql://192.168.100.98:3306/store

More information and downloadMySQL

Oracle

Page 9: Jdbc Drivers and Url

Oracle Thin JDBC Driver

The JDBC Thin driver is a pure Java, Type IV driver that can be used in applications and applets. It is platform-independent and does not require any additional Oracle software on the client-side. The JDBC Thin driver communicates with the server using SQL*Net to access Oracle Database.

The JDBC Thin driver allows a direct connection to the database by providing an implementation of SQL*Net on top of Java sockets. The driver supports the TCP/IP protocol and requires a TNS listener on the TCP/IP sockets on the database server.

Required File(s)ojdbc15.jar (For Java 1.5)ojdbc16.jar (For Java 1.6)

Default Driver Classoracle.jdbc.OracleDriver

JDBC URL Formatjdbc:oracle:thin://<host>:<port>/<service><br> jdbc:oracle:thin:<host>:<port>:<SID><br> jdbc:oracle:thin:<TNSName> (from 10.2.0.1.0)

Example:jdbc:oracle:thin:@mimmi:1521:ORCL_SIDjdbc:oracle:thin:@192.168.1.12:1521/ORCL_SVCjdbc:oracle:thin:@(description=(address=(host=localhost)(protocol=tcp)(port=1521))(connect_data=(sid=ORCL)))jdbc:oracle:thin:@ML

More information and downloadOracle JDBC

NotesRead more in: Oracle JDBC Frequently Asked Question

To enable support for Oracles XMLTYPE in DbVisualizer Personal you need to load the xdb.jar and xmlparserv2.jar in the DbVisualizer Driver Manager. These files are available in the Oracle XML Developers Kit. Visit the Oracle web site for download.

Oracle OCI JDBC Driver

The JDBC OCI driver is a Type II driver used with Java applications. It requires an Oracle client installation and, therefore, is Oracle platform-specific. It supports all installed Oracle Net adapters, including interprocess communication (IPC), named pipes, TCP/IP, and Internetwork Packet Exchange/Sequenced Packet Exchange (IPX/SPX).

The JDBC OCI driver uses the OCI libraries, C-entry points, Oracle Net, core libraries, and other

Page 10: Jdbc Drivers and Url

necessary files on the client computer where it is installed.

Generally we recommend the Oracle Thin driver over the OCI driver since it works on any platform that supports Java. OCI requires client libraries and these are not available on all platforms.

Required File(s)ojdbc15.jar (For Java 1.5)ojdbc16.jar (For Java 1.6)

Default Driver Classoracle.jdbc.OracleDriver

JDBC URL Formatjdbc:oracle:oci://<host>:<port>/<service><br> jdbc:oracle:oci:<host>:<port>:<SID><br> jdbc:oracle:oci:<TNSName>

Example:jdbc:oracle:oci:@mimmi:1521:ORCL_SIDjdbc:oracle:oci:@192.168.1.12:1521/ORCL_SVCjdbc:oracle:oci:@(description=(address=(host=localhost)(protocol=tcp)(port=1521))(connect_data=(sid=ORCL)))jdbc:oracle:oci:ML

More information and downloadOracle JDBC Oracle Instant Client

NotesRead more in: Oracle JDBC Frequently Asked Question

To enable support for Oracles XMLTYPE in DbVisualizer Personal you need to load the xdb.jar and xmlparserv2.jar in the DbVisualizer Driver Manager. These files are available in the Oracle XML Developers Kit. Visit the Oracle web site for download.

Pervasive

Pervasive JDBC Driver

The Pervasive PSQL v10 JDBC driver is a Type 4, 100% Pure Java certified client driver. The driver supports the JDBCTM 2.0 standard. The driver works on all platforms that support the JVM.

Required File(s)

Page 11: Jdbc Drivers and Url

pvjdbc2.jar

Default Driver Classcom.pervasive.jdbc.v2.Driver

JDBC URL Formatjdbc:pervasive://<host>:<port>/<database>

Example:jdbc:pervasive://DBSERV:1583/DEMODATA

More information and downloadPervasive

PointBase

PointBase JDBC Driver - Embedded

PointBase JDBC Driver - Embedded

Required File(s)pbembedded.jar

Default Driver Classcom.pointbase.jdbc.jdbcUniversalDriver

JDBC URL Formatjdbc:pointbase:embedded:PBPUBLIC

More information and downloadPointBase

PointBase JDBC Driver - Server

PointBase JDBC Driver - Server

Required File(s)pbclient.jar

Default Driver Class

Page 12: Jdbc Drivers and Url

com.pointbase.jdbc.jdbcUniversalDriver

JDBC URL Formatjdbc:pointbase:server://<host>:<port>/<database>

More information and downloadPointBase

PointBase JDBC Driver - Micro

PointBase JDBC Driver - Micro

Required File(s)pbmicro.jar

Default Driver Classcom.pointbase.me.jdbc.jdbcDriver

JDBC URL FormatN/A

More information and downloadPointBase

PostgreSQL

JDBC PostgreSQL Driver

PostgreSQLâ„¢ provides a type 4 JDBC driver. Type 4 indicates that the driver is written in Pure Java, and communicates in the database system's own network protocol. Because of this, the driver is platform independent; once compiled, the driver can be used on any system.

This driver is co-packaged with DbVisualizer.

Required File(s)postgresql-nn.jdbc3.jar

Default Driver Classorg.postgresql.Driver

JDBC URL Format

Page 13: Jdbc Drivers and Url

jdbc:postgresql://<host>:<port5432>/<database>

More information and downloadPostgreSQL

Sybase SQL Anywhere

jConnect for JDBC

jConnect provides high performance native access to the complete family of Sybase products including Adaptive Server Enterprise, Adaptive Server Anywhere, Adaptive Server IQ, and Replication Server.

Required File(s)jconn3.jar

Default Driver Classcom.sybase.jdbc3.jdbc.SybDriver

JDBC URL Formatjdbc:sybase:Tds:<host>:<port>?ServiceName=<database_name>

Example:jdbc:sybase:Tds:192.168.2.19:7100?ServiceName=USER

More information and downloadSybase

NotesThe jConnect JDBC driver is usually delivered as zip file. First you need to unzip this file and locate then jconn3.jar file which usually is stored in the classes directory. In DbVisualizer make sure you load this jconn3.jar file.

Sybase ASE

jTDS JDBC Driver

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000

Page 14: Jdbc Drivers and Url

and 2005) and Sybase (10, 11, 12, 15).

This driver is co-packaged with DbVisualizer.

Required File(s)jtds-1.2.2.jar

Default Driver Classnet.sourceforge.jtds.jdbc.Driver

JDBC URL Formatjdbc:jtds:sybase://<host>[:<port>][/<database>]

Example:jdbc:jdtds:sybase://localhost:5000/myDBjdbc:jdtds:sybase://192.168.10.201:5000/SAMPLE

More information and downloadhttp://jtds.sourceforge.net/

NotesInstallation Notes: Download the jtds-nn-dist.zip file, unzip it and then load the jtds.jar file in the DbVisualizer Tools->Driver Manager or in the Tools->Connection Wizard.

jConnect for JDBC

jConnect provides high performance native access to the complete family of Sybase products including Adaptive Server Enterprise, Adaptive Server Anywhere, Adaptive Server IQ, and Replication Server.

Required File(s)jconn3.jar

Default Driver Classcom.sybase.jdbc3.jdbc.SybDriver

JDBC URL Formatjdbc:sybase:Tds:<host>:<port2048>/<database>

Example:jdbc:sybase:Tds:10.0.0.2:2048jdbc:sybase:Tds:mupp:5000/dbvistest