OLAP4J connection to Palo

    OLAP4J connection to Palo

    Hi there, we are trying to use the olap4j to connect our java program to Palo and we receive the following error message:

    org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getDatabases(XmlaOlap4jDatabaseMetaData.java:1034)
    at htbase.htplanning.rap.dao.PaloConnection.main(PaloConnection.java:28)
    Caused by: org.xml.sax.SAXParseExceptionpublicId: -//W3C//DTD HTML 4.01//EN; systemId: w3.org/TR/html4/strict.dtd; lineNumber: 81; columnNumber: 5; The declaration for the entity "ContentType" must end with '>'.
    at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
    at org.olap4j.driver.xmla.XmlaOlap4jUtil.parse(XmlaOlap4jUtil.java:83)


    The connection string we are using is as follow:

    Connection connection =
    DriverManager.getConnection(
    "jdbc:xmla:Server=http://localhost:7777;"
    + "User='admin';"
    + "Password='admin';"
    + "Catalog=Demo;"
    + "Cube=Sales");

    OlapWrapper wrapper = (OlapWrapper) connection;


    I never did a query for Palo but maybe something like this:

    "SELECT {[Years].[2007]} ON COLUMNS , {[Measures].[Units]} ON ROWS\n"
    + "FROM [Sales]");





    Would anyone know the right one?
    OLAP4J connections are based on XMLA, for Palo the XMLA port is 4242, If you intend to make a client application only for Palo then
    the native PaloJlib will be faster, but its not standard. Hence with PaloJlib you can connect to 7777 OLAP port but with OLAP4J you have the option
    to use any backend OLAP databases supporting this standard i.e Palo, Mondrian, SSAS, SAPBW, I have also got some success with Essbase :)

    Palo connection example:
    Connection connection = DriverManager.getConnection(
    "jdbc:xmla:Server=localhost:4242;" + "User='admin';" + "Password='admin';" + "Catalog=Demo;" + "Cube=Sales");

    Hope it helps!

    Best regards,
    Noel.