Cannot load JDBC Driver class

Owned by Aaron van Herk
Last updated: 16 Aug, 2023 by Shaun Forbes
1 min read

Error

Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.OracleDriver         at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:623)         at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:731)         at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:192)         at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:158)         at com.cohga.server.datasource.jdbc.internal.PooledJdbcDataSource$ConnectionObjectFactory.makeObject(PooledJdbcDataSource.java:162)

Solution

Make sure that the JDBC driver has been installed in the ...\weave\platform\workspace\jdbc directory.

In the case above it is looking for class oracle.jdbc.OracleDriver which is contained within the ojdbc8.jar file, if you're trying to connect to a different database, for example SQL Server or Postgres, the required JDBC driver will be different.
The driver should be downloaded from the web site of the database provider or copied from the installation media of the database.

The Weave server instance must be restarted after installing a new JDBC driver