Skip to main content

Connecting to JDBC Databases



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?