abstract class MondrianOlap4jPreparedStatement extends MondrianOlap4jStatement implements PreparedOlapStatement, OlapParameterMetaData
PreparedOlapStatement
for the Mondrian OLAP engine.
This class has sub-classes which implement JDBC 3.0 and JDBC 4.0 APIs;
it is instantiated using Factory.newPreparedStatement(java.lang.String, mondrian.olap4j.MondrianOlap4jConnection)
.
Modifier and Type | Field and Description |
---|---|
(package private) MondrianOlap4jCellSetMetaData |
cellSetMetaData |
closeOnCompletion, olap4jConnection, openCellSet
query, queryTimeout
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
parameterModeIn, parameterModeInOut, parameterModeOut, parameterModeUnknown, parameterNoNulls, parameterNullable, parameterNullableUnknown
Modifier | Constructor and Description |
---|---|
protected |
MondrianOlap4jPreparedStatement(MondrianOlap4jConnection olap4jConnection,
String mdx)
Creates a MondrianOlap4jPreparedStatement.
|
Modifier and Type | Method and Description |
---|---|
void |
addBatch() |
void |
clearParameters() |
boolean |
execute() |
CellSet |
executeQuery() |
int |
executeUpdate() |
(package private) <T> T |
foo(mondrian.olap4j.MondrianOlap4jPreparedStatement.TypeHelper<T> helper,
Type type) |
Cube |
getCube() |
CellSetMetaData |
getMetaData() |
String |
getParameterClassName(int param) |
int |
getParameterCount() |
OlapParameterMetaData |
getParameterMetaData() |
int |
getParameterMode(int param) |
String |
getParameterName(int param) |
Type |
getParameterOlapType(int param) |
int |
getParameterType(int param) |
String |
getParameterTypeName(int param) |
int |
getPrecision(int param) |
int |
getScale(int param) |
int |
isNullable(int param) |
boolean |
isSet(int parameterIndex) |
boolean |
isSigned(int param) |
void |
setArray(int parameterIndex,
Array x) |
void |
setAsciiStream(int parameterIndex,
InputStream x,
int length) |
void |
setBigDecimal(int parameterIndex,
BigDecimal x) |
void |
setBinaryStream(int parameterIndex,
InputStream x,
int length) |
void |
setBlob(int parameterIndex,
Blob x) |
void |
setBoolean(int parameterIndex,
boolean x) |
void |
setByte(int parameterIndex,
byte x) |
void |
setBytes(int parameterIndex,
byte[] x) |
void |
setCharacterStream(int parameterIndex,
Reader reader,
int length) |
void |
setClob(int parameterIndex,
Clob x) |
void |
setDate(int parameterIndex,
Date x) |
void |
setDate(int parameterIndex,
Date x,
Calendar cal) |
void |
setDouble(int parameterIndex,
double x) |
void |
setFloat(int parameterIndex,
float x) |
void |
setInt(int parameterIndex,
int x) |
void |
setLong(int parameterIndex,
long x) |
void |
setNull(int parameterIndex,
int sqlType) |
void |
setNull(int parameterIndex,
int sqlType,
String typeName) |
void |
setObject(int parameterIndex,
Object x) |
void |
setObject(int parameterIndex,
Object x,
int targetSqlType) |
void |
setObject(int parameterIndex,
Object x,
int targetSqlType,
int scaleOrLength) |
void |
setRef(int parameterIndex,
Ref x) |
void |
setShort(int parameterIndex,
short x) |
void |
setString(int parameterIndex,
String x) |
void |
setTime(int parameterIndex,
Time x) |
void |
setTime(int parameterIndex,
Time x,
Calendar cal) |
void |
setTimestamp(int parameterIndex,
Timestamp x) |
void |
setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal) |
void |
setUnicodeStream(int parameterIndex,
InputStream x,
int length) |
void |
setURL(int parameterIndex,
URL x) |
void |
unset(int parameterIndex) |
addBatch, addListener, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeOlapQuery, executeOlapQuery, executeOlapQueryInternal, executeQuery, executeQuery2, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMondrianConnection, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, isWrapperFor, onResultSetClose, parseQuery, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, start, unwrap
checkCancelOrTimeout, enableProfiling, end, getCurrentExecution, getId, getProfileHandler, getProperty, getQuery, getQueryTimeoutMillis, getSchema, getSchemaReader, setQuery, setQueryTimeoutMillis
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
setAsciiStream, setAsciiStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setCharacterStream, setCharacterStream, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setRowId, setSQLXML
addListener, executeOlapQuery, executeOlapQuery, getConnection
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
isWrapperFor, unwrap
isWrapperFor, unwrap
checkCancelOrTimeout, enableProfiling, end, getCurrentExecution, getId, getProfileHandler, getProperty, getQuery, getQueryTimeoutMillis, getSchema, getSchemaReader, setQuery, setQueryTimeoutMillis
MondrianOlap4jCellSetMetaData cellSetMetaData
protected MondrianOlap4jPreparedStatement(MondrianOlap4jConnection olap4jConnection, String mdx) throws OlapException
OlapException
- if database error occursolap4jConnection
- Connectionmdx
- MDX query stringpublic CellSet executeQuery() throws OlapException
executeQuery
in interface PreparedStatement
executeQuery
in interface PreparedOlapStatement
OlapException
public OlapParameterMetaData getParameterMetaData() throws OlapException
getParameterMetaData
in interface PreparedStatement
getParameterMetaData
in interface PreparedOlapStatement
OlapException
public Cube getCube()
getCube
in interface PreparedOlapStatement
public int executeUpdate() throws SQLException
executeUpdate
in interface PreparedStatement
SQLException
public void setNull(int parameterIndex, int sqlType) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setBoolean(int parameterIndex, boolean x) throws SQLException
setBoolean
in interface PreparedStatement
SQLException
public void setByte(int parameterIndex, byte x) throws SQLException
setByte
in interface PreparedStatement
SQLException
public void setShort(int parameterIndex, short x) throws SQLException
setShort
in interface PreparedStatement
SQLException
public void setInt(int parameterIndex, int x) throws SQLException
setInt
in interface PreparedStatement
SQLException
public void setLong(int parameterIndex, long x) throws SQLException
setLong
in interface PreparedStatement
SQLException
public void setFloat(int parameterIndex, float x) throws SQLException
setFloat
in interface PreparedStatement
SQLException
public void setDouble(int parameterIndex, double x) throws SQLException
setDouble
in interface PreparedStatement
SQLException
public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
setBigDecimal
in interface PreparedStatement
SQLException
public void setString(int parameterIndex, String x) throws SQLException
setString
in interface PreparedStatement
SQLException
public void setBytes(int parameterIndex, byte[] x) throws SQLException
setBytes
in interface PreparedStatement
SQLException
public void setDate(int parameterIndex, Date x) throws SQLException
setDate
in interface PreparedStatement
SQLException
public void setTime(int parameterIndex, Time x) throws SQLException
setTime
in interface PreparedStatement
SQLException
public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException
setTimestamp
in interface PreparedStatement
SQLException
public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException
setUnicodeStream
in interface PreparedStatement
SQLException
public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void clearParameters() throws SQLException
clearParameters
in interface PreparedStatement
SQLException
public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setObject(int parameterIndex, Object x) throws SQLException
setObject
in interface PreparedStatement
SQLException
public boolean execute() throws SQLException
execute
in interface PreparedStatement
SQLException
public void addBatch() throws SQLException
addBatch
in interface PreparedStatement
SQLException
public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setRef(int parameterIndex, Ref x) throws SQLException
setRef
in interface PreparedStatement
SQLException
public void setBlob(int parameterIndex, Blob x) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setClob(int parameterIndex, Clob x) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setArray(int parameterIndex, Array x) throws SQLException
setArray
in interface PreparedStatement
SQLException
public CellSetMetaData getMetaData()
getMetaData
in interface PreparedStatement
getMetaData
in interface PreparedOlapStatement
public void setDate(int parameterIndex, Date x, Calendar cal) throws SQLException
setDate
in interface PreparedStatement
SQLException
public void setTime(int parameterIndex, Time x, Calendar cal) throws SQLException
setTime
in interface PreparedStatement
SQLException
public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal) throws SQLException
setTimestamp
in interface PreparedStatement
SQLException
public void setNull(int parameterIndex, int sqlType, String typeName) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setURL(int parameterIndex, URL x) throws SQLException
setURL
in interface PreparedStatement
SQLException
public void setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) throws SQLException
setObject
in interface PreparedStatement
SQLException
public String getParameterName(int param) throws OlapException
getParameterName
in interface OlapParameterMetaData
OlapException
public Type getParameterOlapType(int param) throws OlapException
getParameterOlapType
in interface OlapParameterMetaData
OlapException
public int getParameterCount()
getParameterCount
in interface ParameterMetaData
public int isNullable(int param) throws SQLException
isNullable
in interface ParameterMetaData
SQLException
public boolean isSigned(int param) throws SQLException
isSigned
in interface ParameterMetaData
SQLException
public int getPrecision(int param) throws SQLException
getPrecision
in interface ParameterMetaData
SQLException
public int getScale(int param) throws SQLException
getScale
in interface ParameterMetaData
SQLException
public int getParameterType(int param) throws SQLException
getParameterType
in interface ParameterMetaData
SQLException
public String getParameterTypeName(int param) throws SQLException
getParameterTypeName
in interface ParameterMetaData
SQLException
public String getParameterClassName(int param) throws SQLException
getParameterClassName
in interface ParameterMetaData
SQLException
public int getParameterMode(int param) throws SQLException
getParameterMode
in interface ParameterMetaData
SQLException
public boolean isSet(int parameterIndex) throws SQLException
isSet
in interface PreparedOlapStatement
SQLException
public void unset(int parameterIndex) throws SQLException
unset
in interface PreparedOlapStatement
SQLException