Saiku cannot find JDBC driver for oracle connection

Question

I'm using the all-in-one version of saiku and trying to connect it to my oracle DB.

When starting saiku-server i got an error saying that it couldn't find the jdbc driver for oracle even if i put the driver in

saiku-server\tomcat\webapps\saiku\WEB-INF\libojdbc14.jar

here's my connection file :

saiku-server\tomcat\webapps\saiku\WEB-INF\classes\saiku-datasources\foodmart

type=OLAP
name=foodmart
driver=mondrian.olap4j.MondrianOlap4jDriver
location=jdbc:oracle:thin:mondrian_user/mondrian_user@localhost:1521:XE;Catalog=res:foodmart/FoodMart.xml;JdbcDrivers=oracle.jdbc.driver.OracleDriver;
username=mondrian_user
password=mondrian_user

The connection is successful with dbms like mysql.

Thanks in advance.

Most probably not related, but ojdbc14.jar is totally outdated and should not be used any longer (unless you are using Java 1.4). Current Oracle JDBC drivers are named ojdbc6.jar or ojdbc7.jar — a_horse_with_no_name
Thank you @a_horse_with_no_name for your quick answer. I'm using oracle 10g and when using "ojdbc6.jar" i got another error saying invalid connection string format a valid format is: "host:port:sid" community.oracle.com/thread/372542 I'm using JDK1.7 ... — epsyl
I changed the connection string and got : driver:mondrian.olap4j.MondrianOlap4jDriver url:jdbc:oracle:thin:@//localhost:1521/XE;Catalog=res:foodmart/FoodMart.xml;Jdbc Drivers=oracle.jdbc.driver.OracleDriver; java.sql.SQLRecoverableException: Erreur d'E/S: The Network Adapter could not establish the connection — epsyl

Tomas Greif Tomas Greif · Accepted Answer · 2014-01-23T11:50:37

You should add all JDBC drivers to saiku-server/tomcat/webapps/saiku/WEB-INF/lib folder. It works with mysql because there already is jdbc driver in correct folder (mysql-connector-java-5.1.17.jar).

Saiku has a documentation how to add new jdbc drivers.

Saiku cannot find JDBC driver for oracle connection

1 Answers