Oracle

thin

Files :

  • classes12.jar

Url :

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

Classname :

oracle.jdbc.OracleDriver

Important Notes :

Links :

oci

Files :
  • ojdbc14.jar
Classname :

oracle.jdbc.OracleDriver

Urls :

  • jdbc:oracle:thin:@<host>:<port1521>:<sid>
  • jdbc:oracle:oci:@<host>:<port1521>:<sid>




Important Notes :

  • It is generally recommended that you use the latest version of the driver based on that it is supported by the version of Java you are using
  • It is the same driver file used for both thin and OCI connections
Links :

Sql Server

jtDs

2000 and 2005 Files :
  • jtds-x.x.jar
Classname :

net.sourceforge.jtds.jdbc.Driver

Urls :

jdbc:jtds:<server_type>://<host>[:<port>][/<database>]

Installation notes :

  • Download the jtds-x.x-dist.zip file, unpack it and load the jtds-x.x.jar in the driver manager or in the connection wizard.
Links :

Microsoft Jdbc drivers (SQL server 2000)

Files :
  • mssqlserver.jar
  • msbase.jar
  • msutil.jar
Classname :

com.microsoft.jdbc.sqlserver.SQLServerDriver

Url :

jdbc:microsoft:sqlserver://<host>:<port1433>;DatabaseName=<database>

Microsoft drivers (SQL Server 2005)

Files :

  • sqljdbc.jar

Classname :

com.microsoft.sqlserver.jdbc.SQLServerDriver

Url :

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

Important Notes :

Links :

DB2

IBM Jdbc Native drivers

Files :

  • db2jcc.jar
  • db2jcc_license_cu.jar
Classname :

com.ibm.db2.jcc.DB2Driver

Url :

jdbc:db2://<host>:<port50000>/<database>

How to locate the driver at the IBM web site:

  1. Goto the web site by pressing the Download Driver link
  2. In the web page select Trials and betas link
  3. In the Search for: field enter jdbc
  4. You will probably get one match:

    DB2 Personal Developer's Edition: Redistributable JDBC Type 4 Driver
  5. Press the link and then follow the instructions
Installation Notes :

  • Once you have saved the zip file then unzip it and load the db2jcc.jar and db2jcc_license_cu.jar files listed above in the driver manager
Links :

MySQL

MySQL Jdbc Native drivers

Files :
  • mysql-connector-java-x.x.x-bin.jar
Classname :

com.mysql.jdbc.Driver Url :

jdbc:mysql://<host>:<port3306>/<database> Installation Notes :

  • The saved archive file must be unpacked in order to located the jar file that should be loaded.
Links :

PostgreSQL

PostgreSQL Jdbc Native drivers

Files :
Classname :

Url :

Important Notes :

Links :

HSQL

HSQL 1.8.0 Embedded

Files :
  • hsqldb.jar
Classname :

org.hsqldb.jdbcDriver

Urls :

jdbc:hsqldb:<database>

Important Notes :

Links :

HSQL 1.8.0 Server

Files :

  • hsqldb.jar

Classname :

org.hsqldb.jdbcDriver

Urls :

jdbc:hsqldb:<database>

Important Notes :

Links :

csv files

jcsv

Files :

Classname :

Urls :

Important Notes :

Links :

SqlLite