Examples of org.olap4j.OlapConnection

org.olap4j.OlapConnection
Connection to an OLAP server.
OlapConnection is a subclass of {@link Connection}. It can be pooled by a connection pooling framework or obtained directly via the Java standard {@link DriverManager}. The JDBC URL prefix of olap connections is dependent of the driver implementation. Such implementations are, among others possible:
- Olap4j's XML/A driver
- Mondrian
Olap connections have a different metadata hierarchy than regular JDBC. The connection's metadata is available using {@link OlapConnection#getMetaData()}, and returns a specialized subclass of {@link DatabaseMetaData}. The objects at the root of the hierarchy are {@link Database} class objects.
A connection needs be bound to a database, a catalog and a schema. Implementations are expected to automatically discover these if no driver specific parameters indicated which ones to use. @author jhyde @version $Id: OlapConnection.java 407 2011-03-20 00:44:11Z lucboudreau $ @since Aug 22, 2006

  }


  @NotNull
  public Cube getNativeCube(@NotNull SaikuCube cube) throws SaikuOlapException {
    try {
      OlapConnection con = connections.getOlapConnection(cube.getConnection());
      if (con != null) {
        for (Database db : con.getOlapDatabases()) {
          Catalog cat = db.getCatalogs().get(cube.getCatalog());
          if (cat != null) {
            for (Schema schema : cat.getSchemas()) {
              if (StringUtils.isBlank(cube.getSchema())
                  && StringUtils.isBlank(schema.getName()) || schema.getName().equals(cube.getSchema())) {

View Full Code Here

  }


  @Nullable
  public OlapConnection getNativeConnection(String name) throws SaikuOlapException {
    try {
      OlapConnection con = connections.getOlapConnection(name);
      if (con != null) {
        return con;
      }
    } catch (Exception e) {
      throw new SaikuOlapException("Cannot get native connection for ( " + name + " )", e);

View Full Code Here

  public List<SimpleCubeElement> getAllMembers(@NotNull SaikuCube cube, String hierarchy, String level,
                                               @NotNull String searchString,
                                               int searchLimit) throws SaikuOlapException {
    try {
      Cube nativeCube = getNativeCube(cube);
      OlapConnection con = nativeCube.getSchema().getCatalog().getDatabase().getOlapConnection();
      Hierarchy h = findHierarchy(hierarchy, nativeCube);


      boolean search = StringUtils.isNotBlank(searchString);
      int found = 0;
      List<SimpleCubeElement> simpleMembers;

View Full Code Here

      throw new SaikuOlapException("Cannot find member: " + uniqueMemberName + " in cube:" + cube.getName(), e);
    }
  }


  private boolean isMondrian(@NotNull Cube cube) {
    OlapConnection con = cube.getSchema().getCatalog().getDatabase().getOlapConnection();
    try {
      return con.isWrapperFor(RolapConnection.class);
    } catch (SQLException e) {
      LOG.error("SQLException", e.getNextException());
    }
    return false;
  }

View Full Code Here

    }


    if (PentahoSystem.getObjectFactory().objectDefined(MDXConnection.MDX_CONNECTION_MAPPER_KEY)) {
      IConnectionUserRoleMapper mondrianUserRoleMapper = PentahoSystem.get(IConnectionUserRoleMapper.class, MDXConnection.MDX_CONNECTION_MAPPER_KEY, null);
      if (mondrianUserRoleMapper != null) {
        OlapConnection c = (OlapConnection) con.getConnection();
        String[] validMondrianRolesForUser = mondrianUserRoleMapper.mapConnectionRoles(PentahoSessionHolder.getSession(), c.getCatalog());
        if (setRole(con, validMondrianRolesForUser, datasource)) {
          return con;
        }
      }
    }

View Full Code Here


  private boolean setRole(ISaikuConnection con, String[] validMondrianRolesForUser, SaikuDatasource datasource) {
    if (con.getConnection() instanceof OlapConnection) 
    {
      try {
        OlapConnection c = (OlapConnection) con.getConnection();
        String roles = "";
        if (validMondrianRolesForUser != null && validMondrianRolesForUser.length > 0) {
          for (String r : validMondrianRolesForUser) {
            // lets make sure the role is actually available, just to be safe
            if (c.getAvailableRoleNames().contains(r)) {
              roles += r +",";
            }
          }


          System.out.println("Setting role to datasource:" + datasource.getName() + " role: " + roles);


          if (validMondrianRolesForUser != null && validMondrianRolesForUser.length == 0) {
            return true;
          }
          else if (validMondrianRolesForUser != null && validMondrianRolesForUser.length == 1) {
            c.setRoleName(validMondrianRolesForUser[0]);
          } else {
            SaikuMondrianHelper.setRoles(c, validMondrianRolesForUser);
          }
        } else {
          c.setRoleName(null);
        }




        return true;
      } catch (Exception e) {

View Full Code Here

    stubHostedServer();
    final Properties properties = new Properties();
    properties.put(
      RolapConnectionProperties.Locale.name(),
      getLocale().toString() );
    OlapConnection conn = mock( OlapConnection.class );
    when( server.getConnection( "Pentaho", "myHostedServer", null, properties ) ).thenReturn( conn );
    olapService.flushAll( session );
    verify( mockXmlaExtra ).flushSchemaCache( conn );
  }

View Full Code Here

    stubHostedServer();
    final Properties properties = new Properties();
    properties.put(
      RolapConnectionProperties.Locale.name(),
      getLocale().toString() );
    OlapConnection conn = mock( OlapConnection.class );
    when( server.getConnection( "Pentaho", "myHostedServer", null, properties ) ).thenReturn( conn );
    when( conn.isWrapperFor( any( Class.class ) ) ).thenReturn( true );
    final RolapConnection rolapConn = mock( RolapConnection.class );
    when( conn.unwrap( any( Class.class ) ) ).thenReturn( rolapConn );
    when( rolapConn.getCacheControl( any( PrintWriter.class ) ) ).thenThrow(
      new RuntimeException( "something happend" ) );
    try {
      olapService.flushAll( session );
    } catch ( IOlapServiceException e ) {

View Full Code Here

     *
     * @param queryString MDX query text
     */
    public <T> T runQuery(String queryString, Util.Functor1<T, CellSet> f) {
        long start = System.currentTimeMillis();
        OlapConnection connection = null;
        OlapStatement statement = null;
        CellSet cellSet = null;
        try {
            connection = getOlapConnection();
            statement = connection.createStatement();
            debug("CmdRunner.runQuery: AFTER createStatement");
            start = System.currentTimeMillis();
            cellSet = statement.executeOlapQuery(queryString);
            return f.apply(cellSet);
        } catch (SQLException e) {

View Full Code Here

                addRow(row, rows);
            }
        }


        private void populateMember(List<Row> rows) throws SQLException {
            OlapConnection connection =
                handler.getConnection(
                    request,
                    Collections.<String, String>emptyMap());
            for (Catalog catalog
                : catIter(connection, catNameCond(), catalogCond))

View Full Code Here

0 1 2 3

TOP

Related Classes of org.olap4j.OlapConnection

mondrian.test.MondrianServerTest

mondrian.tui.CmdRunner

mondrian.xmla.impl.Olap4jXmlaServlet$Olap4jPoolingConnectionFactory

mondrian.xmla.MdschemaPropertiesRowset

org.olap4j.sample.PaloConnection

org.olap4j.test.ParserTest

org.olap4j.transform.TransformTest

org.pentaho.platform.plugin.action.mondrian.mapper.MondrianAbstractPlatformUserRoleMapper

org.pentaho.platform.plugin.action.olap.impl.OlapServiceImpl

org.pentaho.platform.plugin.services.olap.OlapServiceImplTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.