public interface OlapStatement extends Statement, OlapWrapper
OlapStatement is generally created using
|Modifier and Type||Method and Description|
Adds a listener to be notified of events to
Executes an OLAP statement expressed as a parse tree.
Executes an OLAP statement.
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
OlapConnection getConnection() throws SQLException
OlapConnectionobject that produced this
CellSet executeOlapQuery(String mdx) throws OlapException
CellSet executeOlapQuery(SelectNode selectNode) throws OlapException
Validates the parse tree before executing it.
selectNode- Parse tree of MDX
OlapException- if a database access error occurs, this method is called on a closed
OlapStatement, the query times out (see
Statement.setQueryTimeout(int)) or another thread cancels the statement (see
void addListener(CellSetListener.Granularity granularity, CellSetListener listener) throws OlapException
CellSets created by this statement.
NOTE: You may wonder why this method belongs to the
OlapStatement class and not
CellSet. If the method
CellSet there would be a window between creation and
registering a listener during which events might be lost, whereas
registering the listener with the statement ensures that the listener is
attached immediately that the cell set is opened. It follows that
registering a listener does not affect the cell set currently
open (if any), and that no events will be received if the statement
has no open cell sets.
granularity- Granularity of cell set events to listen for
listener- Listener to be notified of changes
OlapException- if granularity is not one supported by this server, per the