Databases and JDBC Drivers

This page lists the databases and JDBC drivers you can use. Download the required JDBC drver if that does not come with the software. After getting the JAR file, enter the Jar file name in the zip/jar text field in Driver Manager dialog of this tool.

1.   Oracle

Oracle JDBC driver : The Oracle JDBC driver is part of the Oracle software

Files :Classes111.zip

Driver Class: oracle.jdbc.driver.OracleDriver

URL: jdbc:oracle:thin:@<host>:<port1521>:<sid>

       Example:-jdbc:oracle:thin:@localhost:1521:orcl

Links:http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

2.    SQL Server

SQL Server 2000 JDBC Driver by Microsoft : Download and install setup.exe (Windows)

Files :mssqlserver.jar, msbase.jar, msutil.jar

Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver

URL: jdbc:microsoft:sqlserver://<<host>>:<<port number 1433>>;DatabaseName=<database>

            Example :- dbc:microsoft:sqlserver://HELLO:1433;DatabaseName=Northwind

Links:www.microsoft.com/downloads/details.aspx?FamilyID=86212D54-8488-481D-B46B-AF29BB18E1E5&displaylang=en

3.    MySQL

MySQL JDBC Driver :

Files :mysql-connector-java-3_1.1.8a.zip

Driver Class: com.mysql.jdbc.Driver

URL: jdbc:mysql://<machineName>:<port3306>/<databaseName>

        Example :- jdbc:mysql://hello:3306/test

Links: http://dev.mysql.com/downloads/connector/j/3.1.html

4.    PostgreSql

PostgreSql JDBC Driver :The PostgreSql  JDBC driver is part of the PostgreSql  software

Files :postgresql-8.0.309.jdbc2ee.jar

Driver Class: org.postgresql.Driver

URL: jdbc:postgresql://<host>:<port, default 5432>/<DB Name>

Example :- jdbc:postgresql://hello:5432/test

5.    MaxDB

MaxDB JDBC Driver :The MaxDB JDBC driver is part of the MaxDB software

Files :sapdbc.jar

Driver Class: com.sap.dbtech.jdbc.DriverSapDB

URL: jdbc:sapdb://<database_server>[:<port>]/

<database_name>[<options>]

Example :- jdbc:sapdb://localhost/demodb

Links: http://dev.mysql.com/downloads/maxdb

6.    Mimer SQL

 Mimer SQL JDBC Driver :The Mimer SQL JDBC driver is part of the Mimer SQL software

Files :mimjdbc3.jar

Driver Class: com.mimer.jdbc.Driver

URL: jdbc:mimer:[URL-field-list][property-list]

Example :- jdbc:mimer://hello/testDB

7.    Ingres 

Ingres JDBC Driver :The Ingres JDBC driver is part of the Ingres software

Files :iijdbc.jar

Driver Class: ca.ingres.jdbc.IngresDriver

URL: jdbc:ingres://host:port/db;attr=value

Example :- jdbc:ingres://hello:II7/testdb

The URL parameters are as follows:

host—the network name or address of the host on which the target DAS is running.

port—the network port used by the DAS . This can be a numeric port number or an Ingres symbolic port address such as II7.

db—the target database specification. Any valid Ingres database designation can be used including vnode and server class (that is, vnode::dbname/server_class).

attr=value—optional attribute name and value pair. Multiple attribute pairs are separated by a semi-colon.

 Note: Please refer the Ingres r3 Connectivity guide(comes along with the software)

 

8.    DB2 UDB

DB2 UDB JDBC Driver :The DB2 UDB JDBC driver is part of the DB2 UDB software

Files :db2jcc.jar, db2jcc_license_cu.jar

Driver Class: com.ibm.db2.jcc.DB2Driver

URL: jdbc:db2://host:port_number/database_name

 Example :- jdbc:db2://HELLO:50000/TestDB

The URL parameters:

host - The network name or address of the host on which the target database server is running.

port_number  -The port number used to connect to the server. To determine the port number, enter the following command from the DB2 command line at the server machine: db2jstrt port#

database_name -The database to which you are connecting

9.     Informix

Informix JDBC Driver :Unzip the JDBC.2.21.JC6.zip file and execute setup.jar

Files :ifxjdbc.jar

Driver Class: com.informix.jdbc.IfxDriver

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

 Ex:-jdbc:informix-sqli://hello:1527/stores_demo:informixserver=ol_hello1

Link :  www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc 

The URL parameters:

host - The network name or address of the host on which the target database server is running.

port  -The port number used to connect to the server. 

database -The database to which you are connecting.. 

dbservername -The database server name
Notes: Follow the instructions provided with the downloaded file
 
 

10. MS Access

MS Access JDBC Driver : This tool used JDBC driver for MS Access provided by HXTT

Files :Access_JDBC30.jar

Driver Class: com.hxtt.sql.access.AccessDriver

URL: jdbc:access:</<drive>:<file name>

 Example :- jdbc:access:/f:/FPNWIND.mdb

Links: http://www.hxtt.com/download.jsp?product=Access