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.
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: |
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 ' |
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 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 |
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 |