Windward DocumentationJava Report Engine User Manual ReferenceJava Report Engine Data Source JDBC Drivers Reference

Java Report 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.

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.

After installing a JDBC driver, always add the driver JAR file to your CLASSPATH in the Java Report 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 at the top of the page, click on "Current Version."
  3. Click on the download link for the current JDBC driver version, e.g. "PostgreSQL JDBC 4.2 Driver, 42.2.5."
  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.2.5.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.

0 Comments

Add your comment

E-Mail me when someone replies to this comment