saiku – missing PostgreSQL JDBC driver

Question

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


...
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)
...

Accepted Answer · 2018-05-19T08:57:31

0

Accepted answer

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

Answer 2 · 2018-05-10T09:09:56

According to similar problem reported here, put postgresql-42.2.2.jar 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).

Answer 3 · 2018-05-11T11:15:09

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 4 · 2019-04-03T11:09:48

0

Accepted answer

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 and put it to C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\lib (on win).

With best regards, Jiri.

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 ♦♦ 03 Apr '19, 17:01

saiku – missing PostgreSQL JDBC driver

4 Answers

Your answer

Insert a link

Insert an image

Follow this question

By Email

By RSS

Open Foris

Question tags

Related questions

Keyboard shortcuts

Anywhere

Lists of questions

Question pages