---
title: "saiku – missing PostgreSQL JDBC driver"
url: "https://openforis.support/questions/1787/saiku-missing-postgresql-jdbc-driver"
tags: ["saiku"]
status: "accepted"
score: 0
answer_count: 4
asked: "2018-05-10T09:01:52"
last_activity: "2019-04-03T17:01:55"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# saiku – missing PostgreSQL JDBC driver

Asked by jurafejfar on 2018-05-10

Latest installer of Collect Earth (1.6.33 from [download page][1]) for Win is missing PostgreSQL JDBC driver. This causes Saiku error:

<pre><code>
...
driver:mondrian.olap4j.MondrianOlap4jDriver
url:jdbc:mondrian:Jdbc=jdbc:postgresql://HereIsOurIPaddress:5432/CollectEarthDb;Catalog=HereIsOurPath/collectEarthCubes.xml;JdbcDrivers=org.postgresql.Driver;
12:12:00,143 WARN  [RolapUtil] Mondrian: Warning: JDBC driver org.postgresql.Driver not found
12:12:00,143 WARN  [RolapUtil] Mondrian: Warning: JDBC driver sun.jdbc.odbc.JdbcOdbcDriver not found
12:12:00,174 WARN  [RolapUtil] Mondrian: Warning: JDBC driver oracle.jdbc.OracleDriver not found
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:postgresql://HereIsOurIPaddress:5432/CollectEarthDb; JdbcUser=HereIsOurUser; JdbcPassword=HereIsOurPass
        at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972)
        at mondrian.olap.Util.newInternal(Util.java:2403)
        at mondrian.olap.Util.newError(Util.java:2419)
        at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:246)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:188)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216)
...
</pre>


  [1]: http://www.openforis.org/tools/collect-earth.html


## Accepted answer (score 0, by collectearth on 2018-05-19)

Link: https://openforis.support/questions/1787/saiku-missing-postgresql-jdbc-driver/1803

The newest version of Collect Earth (1.6.34) fixes the issue.
Thanks for reporting it.


## Answer (score 0, by jurafejfar on 2018-05-10)

Link: https://openforis.support/questions/1787/saiku-missing-postgresql-jdbc-driver/1788

According to similar problem reported [here][1], put [postgresql-42.2.2.jar][2] into tomcat/lib directory (e.g. C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\lib on Win or /home/vagrant/OpenForis/CollectEarth/saiku-server_2.6/tomcat/lib on Linux).


  [1]: https://stackoverflow.com/questions/1911253/the-infamous-java-sql-sqlexception-no-suitable-driver-found/1911487#1911487
  [2]: https://jdbc.postgresql.org/download.html


## Answer (score 0, by Open Foris on 2018-05-11)

Link: https://openforis.support/questions/1787/saiku-missing-postgresql-jdbc-driver/1791

Thank you for reporting the issue and even providing a fix yourself!!

We will add this library to the Saiku distributed within Collect Earth. There was already a PostgreSQL driver in it but it seems not to be compatible with the newest Postgres 10


## Answer (score 0, by jurafejfar on 2019-04-03)

Link: https://openforis.support/questions/1787/saiku-missing-postgresql-jdbc-driver/2238

Dear developers,

CollectEarth installer version 1.7.12 (for win) is missing PostgreSQL JDBC driver again. To fix connection to latest PostgreSQL DB, it is necessary to download [postgresql-42.2.5.jar][1] and put it to C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\lib (on win).

With best regards, Jiri.


  [1]: https://jdbc.postgresql.org/download.html

> Thanks for your comment! The PostgreSQL JDBC driver should already be in C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\webapps\saiku\WEB-INF\lib , perhaps the issue was that this was an old version... In any case, the next version of Collect Earth will include the new JAR file in both locations so that we are sure. (Open Foris)