query = connection.parseQuery( queryString ); result = connection.execute( query );
connection.close(); } catch ( Exception ignored ) {
Query q = mdxConnection.parseQuery(queryString); Result result = mdxConnection.execute(q); List<Position> slicers = result.getSlicerAxis().getPositions(); html.append("<table class='resulttable' cellspacing=1 border=0>"); } finally { if (mdxConnection != null) { mdxConnection.close();
public void parse(String mdx) { if (connection != null) { query = connection.parseQuery(mdx); setDirty(); } else { LOGGER.error("null connection"); } }
public Result getResult() { if (result == null) { long t1 = System.currentTimeMillis(); result = connection.execute(query); long t2 = System.currentTimeMillis(); LOGGER.debug( "Execute query took " + (t2 - t1) + " millisec"); } return result; }
List<Member> getDefinedMembers() { List<Member> definedMembers = new ArrayList<Member>(); for (final Formula formula : formulas) { if (formula.isMember() && formula.getElement() != null && getConnection().getRole().canAccess(formula.getElement())) { definedMembers.add((Member) formula.getElement()); } } return definedMembers; }
final FunTable funTable = getConnection().getSchema().getFunTable(); if (tokens.length == 1) {
con.getCacheControl(null).flushSchemaCache();
connection.getDataSource(), sql, null,
Query query = this.connection.parseQuery(this.mdxCmd);
/** * Returns a schema reader. * * @param accessControlled If true, schema reader returns only elements * which are accessible to the statement's current role * * @return schema reader */ public SchemaReader getSchemaReader(boolean accessControlled) { final Role role; if (accessControlled) { // full access control role = getConnection().getRole(); } else { role = null; } final SchemaReader cubeSchemaReader = cube.getSchemaReader(role); return new QuerySchemaReader(cubeSchemaReader, Query.this); }
return; Query q = connection.parseQuery(queryTextPane.getText()); Result r = connection.execute(q);
/** * close connection */ public void valueUnbound(HttpSessionBindingEvent ev) { if (connection != null) { connection.close(); } }
public Member getCalculatedMember(List<Id.Segment> nameParts) { for (final Formula formula : query.formulas) { if (!formula.isMember()) { continue; } Member member = (Member) formula.getElement(); if (member == null) { continue; } if (!Util.matches(member, nameParts)) { continue; } if (!query.getConnection().getRole().canAccess(member)) { continue; } return member; } return null; }
/** * Executes a query and returns the result. * * @param queryString MDX query text * @return a {@link Result} object */ public Result runQuery(String queryString, boolean loadParams) { debug("CmdRunner.runQuery: TOP"); Result result = null; long start = System.currentTimeMillis(); try { this.connection = getConnection(); debug("CmdRunner.runQuery: AFTER getConnection"); Query query = this.connection.parseQuery(queryString); debug("CmdRunner.runQuery: AFTER parseQuery"); if (loadParams) { loadParameters(query); } start = System.currentTimeMillis(); result = this.connection.execute(query); } finally { queryTime = (System.currentTimeMillis() - start); totalQueryTime += queryTime; debug("CmdRunner.runQuery: BOTTOM"); } return result; }
public JRDataSource createDatasource() throws JRException { JRDataSource dataSource = null; String queryStr = getQueryString(); if (connection != null && queryStr != null) { if (log.isDebugEnabled()) { log.debug("MDX query: " + queryStr); } Query query = connection.parseQuery(queryStr); result = connection.execute(query); dataSource = new JRMondrianDataSource(dataset, result); } return dataSource; }