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

0	The newest version of Collect Earth (1.6.34) fixes the issue. Thanks for reporting it. permanent link answered 19 May '18, 08:57 collectearth ♦ 1.0k●1●6 accept rate: 17%

Answer 2

0

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

permanent link

answered 10 May '18, 09:09

jurafejfar
142●3●14
accept rate: 0%

edited 10 May '18, 13:08

Answer 3

0

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

permanent link

answered 11 May '18, 11:15

Open Foris ♦♦
1.0k●5●7●14
accept rate: 10%

Answer 4

0

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.

permanent link

answered 03 Apr '19, 11:09

jurafejfar
142●3●14
accept rate: 0%

edited 03 Apr '19, 11:10

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.

(03 Apr '19, 17:01) Open Foris ♦♦

saiku – missing PostgreSQL JDBC driver

Follow this question

Related questions