Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Mondrian XMLA and olap4j

  1. #1
    Join Date
    Apr 2008
    Posts
    18

    Default Mondrian XMLA and olap4j

    Hello,

    I have wriitten a small Java Console Application which should connect to Mondrian using olap4j.

    Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
    System.out.println("asd");
    Connection connection =
    DriverManager.getConnection(
    "jdbc:xmla:" +
    "Server=http://192.168.0.224:8080/mondrian/xmla; "
    + "Catalog=/WEB-INF/queries/Uni.xml");
    OlapConnection olapConnection = connection.unwrap(OlapConnection.class);
    OlapStatement statement = olapConnection.createStatement();

    I have customized the web.xml, datasource.xml and mondrian.properties.
    The name of the catalog is Uni.xml. The driver and ConnectionString is well configurated, because I can query the Uni.xml cube in JPivot.

    When I start the java application I always get the error message:

    ...
    <SOAP-ENV:Fault>
    <faultcode>SOAP-ENV:Client.00HSBC01</faultcode>
    <faultstring>XMLA connection datasource not found</faultstring>
    <faultactor>Mondrian</faultactor>
    <detail>
    <XA:error xmlns:XA="http://mondrian.sourceforge.net">
    <code>00HSBC01</code>
    <desc>The Mondrian XML: Mondrian Error:Internal
    error: no data source is configured with name 'MondrianFoodMart'</desc>
    </XA:error>
    </detail>
    </SOAP-ENV:Fault>
    ...

    I cannot unterstand why Mondrian is searching after the datasource MondrianFoodMart.

    How can I change it?
    Where I can configure the datasource for xmla?

    Best regards
    cakbulut

  2. #2
    Join Date
    May 2008
    Posts
    2

    Default Mondrian XMLA

    As far as I understood you send the request
    "Server=http://192.168.0.224:8080/mondrian/xmla; "
    to the xmla.jsp in webapps/mondrian. I think when you look in that file it will help.

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.