Package mondrian.olap4j

Class MondrianOlap4jDriver

  • All Implemented Interfaces:
    Driver
    public class MondrianOlap4jDriver
extends Object
implements Driver
    Olap4j driver for Mondrian.

    Since olap4j is a superset of JDBC, you register this driver as you would any JDBC driver:

    Class.forName("mondrian.olap4j.MondrianOlap4jDriver");

    Then create a connection using a URL with the prefix "jdbc:mondrian:". For example,

    import java.sql.Connection;
    import java.sql.DriverManager;
    import org.olap4j.OlapConnection;

    Connection connection =
      DriverManager.getConnection(
        "jdbc:mondrian:Jdbc=jdbc:odbc:MondrianFoodMart; Catalog=file:/mondrian/demo/FoodMart.xml; JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver");
    OlapConnection olapConnection =
      connection.unwrap(OlapConnection.class);

    Note how we use the Wrapper.unwrap(Class) method to down-cast the JDBC connection object to the extension OlapConnection object. This method is only available in the JDBC 4.0 (JDK 1.6 onwards).

    Connection properties

    The driver supports the same set of properties as a traditional mondrian connection. See RolapConnectionProperties.

    Catalogs and schemas

    Mondrian has a sole catalog, called "LOCALDB". You will get an error if you attempt to use Connection.setCatalog(String) to set it to anything else.

    Since:
    May 22, 2007
    Author:
    jhyde