Databases and JDBC Drivers

This page lists the databases and JDBC drivers supported by DAO-Generator. Download the JDBC Driver you require if that does not come with the software. Either modify the CLASSPATH in run.bat or start DAO-Generator and using Driver Manager menu option provide  the ZIP/Jar file name with complete path.

 

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: Driver Download



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: Download Driver



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: Download Driver



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:  Download Driver



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.    McKoi 1.0 (A pure java database engine)

 

Mckoi JDBC Driver

The McKoi  JDBC driver is part of the Mckoi software

Files

mkjdbc.jar

Driver Class:

com.mckoi.JDBCDriver

URL:

jdbc:mckoi://host[:port][/schema]/

 Example :- jdbc:mckoi://localhost/

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. The :port is optional and if not given the driver will 
attempt to connect to the default port of 9157.
 

 schema-The /schema part is also optional. If the schema part is included, the JDBCTM driver will attempt to initialize the connection in the given schema after successfully connecting to the database. If the schema is not included in the URL, the engine will attempt to initialize the connection in a schema with the same name as the username. If the engine is unable to find the schema, the connection will default to the 'APP' schema.

 

 

 

10.     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

Download Driver

 

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

 

 

 

  1. MS Access

 

MS Access JDBC Driver

The MS Access type 4 JDBC driver can be downloaded from the link mentioned below

Files

Access_JDBC30.jar

Driver Class:

com.hxtt.sql.access.AccessDriver

URL:

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

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

Link Download Driver