Examples of OlapParameterMetaData

org.olap4j.OlapParameterMetaData
Extension to {@link ParameterMetaData} for parameters of OLAP statements.
Chief differences:
- An OLAP statement parameter has a name.
- An OLAP statement parameter may be a member. If this is the case, the {@link #getParameterType(int)} method returns{@link java.sql.Types#OTHER}.
- An additional method {@link #getParameterOlapType(int)} provides extratype information; in particular, the hierarchy that a member parameter belongs to.
Parameters to an OLAP statement must have default values, and therefore it is not necessary to set every parameter. @author jhyde @version $Id: OlapParameterMetaData.java 229 2009-05-08 19:11:29Z jhyde $ @since Oct 12, 2006

Examples of org.olap4j.OlapParameterMetaData

      {
        params.add(getJdbcUserField());
      }
      final PreparedOlapStatement statement = connection.prepareOlapStatement(translatedQuery);


      final OlapParameterMetaData data = statement.getParameterMetaData();
      final int count = data.getParameterCount();
      for (int i = 0; i < count; i++)
      {
        final String parameterName = data.getParameterName(i + 1);
        params.add(parameterName);
      }
      params.add(DataFactory.QUERY_LIMIT);
      return params.toArray(new String[params.size()]);
    }

View Full Code Here

Examples of org.olap4j.OlapParameterMetaData


  protected QueryResultWrapper performQuery(final String rawMdxQuery, final DataRow parameters)
      throws ReportDataFactoryException, SQLException
  {
    final PreparedOlapStatement statement = getStatement(rawMdxQuery, parameters);
    final OlapParameterMetaData data = statement.getParameterMetaData();
    final int count = data.getParameterCount();
    for (int i = 0; i < count; i++)
    {
      final String parameterName = data.getParameterName(i + 1);
      statement.setObject(i + 1, parameters.get(parameterName));
    }


    final Object queryTimeout = parameters.get(DataFactory.QUERY_TIMEOUT);
    final int queryTimeoutValue;
    if (queryTimeout instanceof Number)
    {
      final Number i = (Number) queryTimeout;
      queryTimeoutValue = i.intValue();
    }
    else
    {
      // means unlimited ...
      queryTimeoutValue = 0;
    }


    if (queryTimeoutValue > 0)
    {
      statement.setQueryTimeout(queryTimeoutValue);
    }




    final OlapParameterMetaData olapParameterMetaData = statement.getParameterMetaData();
    final int paramCount = olapParameterMetaData.getParameterCount();
    for (int i = 1; i <= paramCount; i++)
    {
      final String paramName = olapParameterMetaData.getParameterName(i);
      Object parameterValue = parameters.get(paramName);
      if (parameterValue != null)
      {
        final Type parameterType = olapParameterMetaData.getParameterOlapType(i);
        if (parameterType instanceof StringType)
        {
          if (!(parameterValue instanceof String))
          {
            throw new ReportDataFactoryException(parameterValue + " is incorrect for type " + parameterType);

View Full Code Here

Examples of org.olap4j.OlapParameterMetaData

  }


  private void parametrizeQuery(final DataRow parameters,
                                final PreparedOlapStatement statement) throws SQLException, ReportDataFactoryException
  {
    final OlapParameterMetaData olapParameterMetaData = statement.getParameterMetaData();
    final int paramCount = olapParameterMetaData.getParameterCount();
    for (int i = 1; i <= paramCount; i++)
    {
      final String paramName = olapParameterMetaData.getParameterName(i);
      Object parameterValue = parameters.get(paramName);
      final Type parameterType = olapParameterMetaData.getParameterOlapType(i);
      parameterValue = computeParameterValue(statement, parameterType, parameterValue);
      statement.setObject(i, parameterValue);
    }
  }

View Full Code Here

Examples of org.olap4j.OlapParameterMetaData

      {
        params.add(getJdbcUserField());
      }
      final PreparedOlapStatement statement = connection.prepareOlapStatement(translatedQuery);


      final OlapParameterMetaData data = statement.getParameterMetaData();
      final int count = data.getParameterCount();
      for (int i = 0; i < count; i++)
      {
        final String parameterName = data.getParameterName(i + 1);
        params.add(parameterName);
      }
      params.add(DataFactory.QUERY_LIMIT);
      return params.toArray(new String[params.size()]);
    }

View Full Code Here

TOP

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.