Skip to main content
Windward

Connecting to JDBC Databases

engine-wiki-logo.png

Overview

For those using a SQL database.

JDBC Data Sources

If your users need a SQL database for the data source of their reports, read this chapter. Otherwise, you may skip it.

JDBC Drivers

You need to install the JDBC drivers for the database your users are using. Please refer to the documentation from your database vendor on how to do this.

The vendor's JDBC filenames at the time of writing this - vendors may change them) are:

  • DB2 - db2jcc.jar, db2jcc_javax.jar' and db2jcc_license_cu.jar.
  • MySql - mysql-connector-java-5.1.22-bin.jar (and the number changes with each build).
  • Oracle - ojdbc6.jar (the 6 means build for JDK6 - there is an ojdbc5.jar, ojdbc4.jar, etc.).
  • PostgreSQL - postgresql-8.3-603.jdbc2.jar (and the number changes with each build).
  • Sql Server - sqljdbc4.jar (sqljdbc.jar for older JDKs).
  • Cassandra - apache-cassandra-1.2.6.jar; apache-cassandra-clientutil-1.2.6.jar; apache-cassandra-thrift-1.2.6.jar; cassandra-jdbc-1.2.5.jar; guava-13.0.1.jar; libthrift-0.7.0.jar; slf4j-api-1.7.2.jar; slf4j-log4j12-1.7.2.jar
  • Was this article helpful?