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.

Answer 1

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.