jdbc drivers and url
Post on 10-Apr-2015
2.113 Views
Preview:
TRANSCRIPT
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>
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
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
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
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
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
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.
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
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
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)
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
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
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
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
top related