Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Mondrian properties file vs. hard coded ODBC

  1. #1

    Default Mondrian properties file vs. hard coded ODBC

    Hi all
    I am trying to install Mondrian on Mac OS X (Tomcat 4.1.24, MySQL 4.0.15, Apache 2.0.47) and I am running into a problem trying to access the examples pages.
    the properties I set are as follows:
    mondrian.jdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver,oracle.jdbc.OracleDriver,com.mysql.jdbc.Driver
    mondrian.foodmart.jdbcURL=jdbc:mysql://localhost/foodmart?user=yyyy&password=xxxx
    I get the following error:
    org.apache.jasper.JasperException: com.tonbeller.jpivot.olap.model.OlapException: Could not load Jdbc Driver sun.jdbc.odbc.JdbcOdbcDriver
    ....
    ....
    It seems the software is still looking to load the Jdbc-Obdc bridge driver, while that driver is not specified at all in the mondrian properties file.
    I tried placing that file in tomcat/webapps (next to mondrian.war), also in tomcat/bin with the same results.
    Where do i need to place that file to make sure it overrides the hard-coded ODBC calls?
    Regards

  2. #2
    Join Date
    Sep 2002
    Posts
    475

    Default RE: Mondrian properties file vs. hard coded O

    If you are using the distributed WAR, mondrian.jsp uses a JPivot tag to define the Mondrian schema, initial query and datasource, ignoring the mondrian.properties.
    You can change the JSP to use a different driver.

  3. #3
    Join Date
    Sep 2007
    Posts
    3

    Default

    It worked for me when i copy the odbc driver right into de bin directory for Tomcat. I also had to change the connection string on web.xml and add a &#38 just after the username.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.