Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Newbie question:mondrian.properties not found

  1. #1
    Join Date
    Sep 2003
    Posts
    18

    Default Newbie question:mondrian.properties not found

    Hi there,
    When I clicked "JPivot pivot table" from Mondrian web examples.
    I got the message in Tomcat console.
    Mondrian: Warning: file 'C:\Program Files\Apache Group\Tomcat 4.1\mondrian.properties' not found
    Mondrian: loaded 0 system properties
    Mondrian: JDBC driver sun.jdbc.odbc.JdbcOdbcDriver loaded successfully
    Mondrian: Warning: JDBC driver org.hsqldb.jdbcDriver not found
    Mondrian: JDBC driver oracle.jdbc.OracleDriver loaded successfully
    Mondrian: Warning: JDBC driver com.mysql.jdbc.Driver not found
    And I got the message in web browser.
    org.apache.jasper.JasperException: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    I had imported the oracle data and these are my env.
    Apache Tomcat/4.1.27
    j2sdk1.4.1_05
    Any ideas?
    Thanks in advance.

  2. #2
    Join Date
    Sep 2003
    Posts
    18

    Default RE: Newbie question:mondrian.properties not found

    Hi,
    I just copied the mondrian.war to tomcat/webapps.
    There is a question comes to me.
    Where do I configure the database connect string?
    The version is Mondrian 1.0.1.
    Thanks in advance.

  3. #3
    Join Date
    Sep 2002
    Posts
    475

    Default RE: Newbie question:mondrian.properties not found

    Check out the Mondrian project home page at
    http://apoptosis.dyndns.org:8080/ope...doc/index.html.
    The Download/Install menu item has Section 6, "Run the web app", with some explanation about configuration.
    To fix the missing mondrian.properties, take the one in the bin folder and modify it for your needs. Have you got the demo FoodMart database set up?

  4. #4
    Join Date
    Sep 2003
    Posts
    18

    Default RE: Newbie question:mondrian.properties not found

    Hi,
    These were what I did.
    1) build the Mondrian 1.0.1 source code(SUCCESSFUL)
    2) deploy to tomcat 4.1.27 (SUCCESSFUL)
    3) Copy mondrian.properties to C:\Program Files\Apache Group\Tomcat 4.1
    When I clicked "JPivot pivot table" from Mondrian web examples. I still got the error message like my first post.
    What's wrong and where should I set the database connect string?
    It seems that my database connect string setting is wrong.
    Thanks.

  5. #5
    Join Date
    Sep 2003
    Posts
    18

    Default RE: Newbie question:mondrian.properties not found

    Hi,
    Yes, I have got the demo FoodMart and import to my oracle database.
    When I Run build deploy-webapp, it said "Target `deploy-webapp' does not exist in this project."
    So I run "build deploy-war and it successed.
    After that, I still got the same error.
    Any ideas?
    thanks.

  6. #6
    Join Date
    Sep 2003
    Posts
    18

    Default RE: Newbie question:mondrian.properties not found

    Hi,
    I put the mondrian.properties in C:/, and I modified the mondrian.olap.MondrianProperties to read the file.
    private static final String mondrianDotProperties = "/mondrian.properties";
    After redeployed the mondrian.war, mondrian.properties could be read.
    When I clicked "JPivot pivot table" from Mondrian web examples, I got the message in web browser.
    org.apache.jasper.JasperException: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
    I imported the foodmart data to my oracle database.
    What's wrong with my mondrian.properties?
    This is my mondrian.properties.
    ----
    mondrian.jdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver,oracle.jdbc.OracleDriver,com.mysql.jdbc.Driver
    mondrian.foodmart.jdbcURL=jdbcracleci8:foodmart/foodmart@helpdesk
    catalina.home=C:/Program Files/Apache Group/Tomcat 4.1
    ----
    Thanks in advance.

  7. #7
    Join Date
    Sep 2002
    Posts
    475

    Default RE: Newbie question:mondrian.properties not found

    Now I see your problem.
    The webapp distributed with Mondrian includes JPivot. The link you are selecting is part of JPivot.
    In the mondrian.war that is distributed with Mondrian, you will find testpage.jsp, which uses another jsp, mondrian.jsp. The JPivot tag in mondrian.jsp is where the DataSource is defined, not mondrian.properties. The standard mondrian.jsp uses the JDBC/ODBC bridge to get to the database. You can create an ODBC datasource or change the tag parameters in mondrian.jsp to be the same as what you have in your current mondrian.properties.
    Cheers,
    Sherman

  8. #8
    Join Date
    Mar 2002
    Posts
    10

    Default RE: Newbie question:mondrian.properties not found

    Do you have this ?
    mondrian.test.connectString=\
    Provider=mondrian;\
    Jdbc=jdbcracleci8:foodmart/foodmart@helpdesk;\
    Catalog=/WEB-INF/queries/FoodMart.xml;\
    JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver,oracle.jdbc.OracleDriver,com.mysql.jdbc.Driver;\
    mondrian.foodmart.jdbcURL=jdbcracleci8:foodmart/foodmart@helpdesk

  9. #9
    Join Date
    Sep 2003
    Posts
    18

    Default RE: Newbie question:mondrian.properties not found

    Got it.
    Thanks a lot.

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.