无法使用olap4j连接到XMLA/Mondrian

Question

我正在尝试通过java api (olap4j)连接到XMLA webservice，以便在Mondrian cube上执行MDX查询，Mondrian cube是托管在localhost中的商业智能工具。

下面是我的代码：

 try {
         Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
         Connection connection =
                DriverManager.getConnection(
                        "jdbc:xmla:Server=http://127.0.0.1:8080/jasperserver-pro/xmla");



        OlapWrapper wrapper = (OlapWrapper) connection;
        OlapConnection olapConnection = wrapper
                .unwrap(OlapConnection.class);
        OlapStatement statement = (OlapStatement) connection
                .createStatement();

        CellSet cellSet =
                statement.executeOlapQuery("select [Measures].Members ON COLUMNS\n" +
                        "from [FAIS_MED]\n");
        for (Position row : cellSet.getAxes().get(1)) {
            for (Position column : cellSet.getAxes().get(0)) {
                for (Member member : row.getMembers()) {
                    System.out.println(member.getUniqueName());
                }
                for (Member member : column.getMembers()) {
                    System.out.println(member.getUniqueName());
                }
                final Cell cell = cellSet.getCell(column, row);
                System.out.println(cell.getFormattedValue());
                System.out.println();
            }
        }


        } catch (SQLException | ClassNotFoundException e) {
        e.printStackTrace();
    }

我将得到下面的错误：

java.lang.ClassNotFoundException: org.olap4j.driver.xmla.XmlaOlap4jDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.slimani.bi_restful.testing.MondrianOlap4jDriver.getConnection(MondrianOlap4jDriver.java:18)
at com.slimani.bi_restful.testing.MondrianOlap4jDriver.main(MondrianOlap4jDriver.java:45)
Exception in thread "main" java.lang.NullPointerException at com.slimani.bi_restful.testing.MondrianOlap4jDriver.main(MondrianOlap4jDriver.java:48)

Answer 1

找不到XMLA驱动程序。可以在java.lang.ClassNotFoundException: org.olap4j.driver.xmla.XmlaOlap4jDriver中看到这一点。

你可以从maven下载：https://mvnrepository.com/artifact/org.olap4j/olap4j-xmla/1.2.0