Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: error in using olap4j to access pentaho xmla service

  1. #1
    Join Date
    Jun 2016

    Default error in using olap4j to access pentaho xmla service

    I set up the pentaho xmla service. I think it is working well, for I can access it in excel:
    Name:  tmp001.jpg
Views: 706
Size:  15.5 KB

    but when i developed a java client, an error occur in line 6:
    1 try {
    2 Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
    3 String connectString2="jdbc:xmla:Server=http://localhost:8080/pentaho/Xmla?catalog=FoodMart&userid=Admin&password=password";
    4 Connection cnx = DriverManager.getConnection(connectString2, null, null);
    5 OlapConnection olapConnection = cnx.unwrap(OlapConnection.class);
    6 olapConnection.setCatalog("FoodMart");

    the error is:
    java.lang.RuntimeException: [FATAL]:29:3: The element type "meta" must be terminated by the matching end-tag "</meta>".
    at org.olap4j.driver.xmla.XmlaOlap4jUtil.checkForParseError(
    at org.olap4j.driver.xmla.XmlaOlap4jUtil.parse(
    at org.olap4j.driver.xmla.XmlaOlap4jConnection.executeMetadataRequest(
    at org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getMetadata(
    at org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getMetadata(
    at org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getDatabaseProperties(
    at org.olap4j.driver.xmla.XmlaOlap4jConnection.makeConnectionPropertyList(
    at org.olap4j.driver.xmla.XmlaOlap4jConnection.generateRequest(
    at org.olap4j.driver.xmla.XmlaOlap4jConnection.populateList(
    at org.olap4j.driver.xmla.DeferredNamedListImpl.populateList(
    at org.olap4j.driver.xmla.DeferredNamedListImpl.getList(
    at org.olap4j.driver.xmla.DeferredNamedListImpl.size(
    at org.olap4j.driver.xmla.XmlaOlap4jConnection.getOlapDatabase(
    at org.olap4j.driver.xmla.XmlaOlap4jConnection.getOlapCatalogs(
    at org.olap4j.driver.xmla.XmlaOlap4jConnection.setCatalog(
    at mondriantest.MondrianTest.main(
    Caused by: org.xml.sax.SAXParseException; lineNumber: 29; columnNumber: 3; The element type "meta" must be terminated by the matching end-tag "</meta>".
    at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
    at org.olap4j.driver.xmla.XmlaOlap4jUtil.parse(
    ... 14 more

    I am using java 1.7.

    anyone can help? thanks

  2. #2
    Join Date
    Mar 2017


    Try this:
    String connectString2="jdbc:xmla:Server=http://localhost:8080/pentaho/Xmla;Catalog=FoodMart;

    Connection cnx = DriverManager.getConnection(connectString2, "Admin", "password");

Tags for this Thread

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.