Skip to main content

Java Engine Data Source JDBC Drivers Reference

For SQL data sources, such as Microsoft SQL Server, Oracle, etc., Java Report Engine requires a JDBC driver be installed so the Engine can connect to the data source. The JDBC drivers are provided by the SQL data source vendor.

This article details where to download, and how to install, the JDBC drivers for each supported SQL data source.

note

JDBC JAR files are operating system independent. Microsoft does not provide JDBC drivers for Microsoft Access or Microsoft SQLite, but JDBC drivers for those data sources may be available from third parties.

Important

After installing a JDBC driver, always add the driver JAR file to your CLASSPATH in the Java Engine's environment.

Microsoft SQL Server​

  1. Download the SQL Server JDBC connector from Microsoft here.
  2. Unzip the downloaded zip file to a directory on your Java Report Engine server.
  3. Add the JDBC driver JAR file (e.g. mssql-jdbc-6.2.2.jre8.jar) to your CLASSPATH.

Oracle Database​

  1. Go to the Oracle Database 12.1.0.1 JDBC Driver & UCP Downloads web page.
  2. Click the ‘Accept License Agreement’ radio button.
  3. Find the JAR file for your JDK version, e.g. JDK7, JDK8.
  4. Click on the download link, e.g. ojdbc7.jar.
  5. Copy the JDBC JAR file to a directory on your Java Report Engine server.
  6. Add the JDBC driver JAR file (e.g. ojdbc7.jar) to your CLASSPATH

MySQL Server​

  1. Go to the MySQL Download Connector/J web page.
  2. In the "Select Operating System" field of the "Generally Available (GA) Releases" tab, select "Platform Independent."
  3. Click on the Download button for "Platform Independent (Architecture Independent), ZIP Archive."
  4. Unzip the downloaded zip file to a directory on your Java Report Engine server.
  5. Add the JDBC driver JAR file (e.g. mysql-connector-java-8.0.15.jar) to your CLASSPATH.

PostgreSQL​

  1. Go to the PostgreSQL JDBC Driver download web page.
  2. In the Download section near the top of the page is the "Latest Versions" section.
  3. Click on the download link for the latest JDBC driver version for Java 8
  4. Copy the JDBC JAR file to a directory on your Java Report Engine server.
  5. Add the JDBC driver JAR file (e.g. postgresql-42.6.0.jar) to your CLASSPATH.

IBM DB2​

  1. Go to DB2 JDBC Drivers and Downloads
  2. Click on the most current Driver Version for "JDBC 4.0 Driver (db2jcc4.jar)"
  3. Then on the "Download initial Version 11.1 clients and drivers" page, click on IBM Data Server Driver for JDBC and SQLJ (JCC Driver)
  4. Create or login to your IBM account
  5. Click on the "Download using http" tab
  6. Click on "Download now"
  7. Unzip the downloaded zip file (e.g. db2_db2driver_for_jdbc_sqlj_v11.1.zip) on the Java Report Engine server
  8. Add the JDBC driver JAR file db2jcc4.jar to your CLASSPATH.