Package mondrian.olap4j
Class MondrianOlap4jPreparedStatement
- java.lang.Object
-
- mondrian.server.StatementImpl
-
- mondrian.olap4j.MondrianOlap4jStatement
-
- mondrian.olap4j.MondrianOlap4jPreparedStatement
-
- All Implemented Interfaces:
AutoCloseable
,ParameterMetaData
,PreparedStatement
,Statement
,Wrapper
,Statement
,OlapParameterMetaData
,OlapStatement
,OlapWrapper
,PreparedOlapStatement
- Direct Known Subclasses:
FactoryJdbc4Plus.AbstractPreparedStatement
abstract class MondrianOlap4jPreparedStatement extends MondrianOlap4jStatement implements PreparedOlapStatement, OlapParameterMetaData
Implementation ofPreparedOlapStatement
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)
.- Since:
- Jun 12, 2007
- Author:
- jhyde
-
-
Field Summary
Fields Modifier and Type Field Description (package private) MondrianOlap4jCellSetMetaData
cellSetMetaData
-
Fields inherited from class mondrian.olap4j.MondrianOlap4jStatement
closeOnCompletion, olap4jConnection, openCellSet
-
Fields inherited from class mondrian.server.StatementImpl
query, queryTimeout
-
Fields inherited from interface java.sql.ParameterMetaData
parameterModeIn, parameterModeInOut, parameterModeOut, parameterModeUnknown, parameterNoNulls, parameterNullable, parameterNullableUnknown
-
Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
-
-
Constructor Summary
Constructors Modifier Constructor Description protected
MondrianOlap4jPreparedStatement(MondrianOlap4jConnection olap4jConnection, String mdx)
Creates a MondrianOlap4jPreparedStatement.
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method 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)
-
Methods inherited from class mondrian.olap4j.MondrianOlap4jStatement
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
-
Methods inherited from class mondrian.server.StatementImpl
checkCancelOrTimeout, enableProfiling, end, getCurrentExecution, getId, getProfileHandler, getProperty, getQuery, getQueryTimeoutMillis, getSchema, getSchemaReader, setQuery, setQueryTimeoutMillis
-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface org.olap4j.OlapStatement
addListener, executeOlapQuery, executeOlapQuery, getConnection
-
Methods inherited from interface org.olap4j.OlapWrapper
isWrapperFor, unwrap
-
Methods inherited from interface java.sql.PreparedStatement
executeLargeUpdate, setAsciiStream, setAsciiStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setCharacterStream, setCharacterStream, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setObject, setObject, setRowId, setSQLXML
-
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
-
Methods inherited from interface mondrian.server.Statement
checkCancelOrTimeout, enableProfiling, end, getCurrentExecution, getId, getProfileHandler, getProperty, getQuery, getQueryTimeoutMillis, getSchema, getSchemaReader, setQuery, setQueryTimeoutMillis
-
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
-
-
-
-
Field Detail
-
cellSetMetaData
MondrianOlap4jCellSetMetaData cellSetMetaData
-
-
Constructor Detail
-
MondrianOlap4jPreparedStatement
protected MondrianOlap4jPreparedStatement(MondrianOlap4jConnection olap4jConnection, String mdx) throws OlapException
Creates a MondrianOlap4jPreparedStatement.- Parameters:
olap4jConnection
- Connectionmdx
- MDX query string- Throws:
OlapException
- if database error occurs
-
-
Method Detail
-
executeQuery
public CellSet executeQuery() throws OlapException
- Specified by:
executeQuery
in interfacePreparedOlapStatement
- Specified by:
executeQuery
in interfacePreparedStatement
- Throws:
OlapException
-
getParameterMetaData
public OlapParameterMetaData getParameterMetaData() throws OlapException
- Specified by:
getParameterMetaData
in interfacePreparedOlapStatement
- Specified by:
getParameterMetaData
in interfacePreparedStatement
- Throws:
OlapException
-
getCube
public Cube getCube()
- Specified by:
getCube
in interfacePreparedOlapStatement
-
executeUpdate
public int executeUpdate() throws SQLException
- Specified by:
executeUpdate
in interfacePreparedStatement
- Throws:
SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType) throws SQLException
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
-
setBoolean
public void setBoolean(int parameterIndex, boolean x) throws SQLException
- Specified by:
setBoolean
in interfacePreparedStatement
- Throws:
SQLException
-
setByte
public void setByte(int parameterIndex, byte x) throws SQLException
- Specified by:
setByte
in interfacePreparedStatement
- Throws:
SQLException
-
setShort
public void setShort(int parameterIndex, short x) throws SQLException
- Specified by:
setShort
in interfacePreparedStatement
- Throws:
SQLException
-
setInt
public void setInt(int parameterIndex, int x) throws SQLException
- Specified by:
setInt
in interfacePreparedStatement
- Throws:
SQLException
-
setLong
public void setLong(int parameterIndex, long x) throws SQLException
- Specified by:
setLong
in interfacePreparedStatement
- Throws:
SQLException
-
setFloat
public void setFloat(int parameterIndex, float x) throws SQLException
- Specified by:
setFloat
in interfacePreparedStatement
- Throws:
SQLException
-
setDouble
public void setDouble(int parameterIndex, double x) throws SQLException
- Specified by:
setDouble
in interfacePreparedStatement
- Throws:
SQLException
-
setBigDecimal
public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
- Specified by:
setBigDecimal
in interfacePreparedStatement
- Throws:
SQLException
-
setString
public void setString(int parameterIndex, String x) throws SQLException
- Specified by:
setString
in interfacePreparedStatement
- Throws:
SQLException
-
setBytes
public void setBytes(int parameterIndex, byte[] x) throws SQLException
- Specified by:
setBytes
in interfacePreparedStatement
- Throws:
SQLException
-
setDate
public void setDate(int parameterIndex, Date x) throws SQLException
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
-
setTime
public void setTime(int parameterIndex, Time x) throws SQLException
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
-
setUnicodeStream
public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException
- Specified by:
setUnicodeStream
in interfacePreparedStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
-
clearParameters
public void clearParameters() throws SQLException
- Specified by:
clearParameters
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(int parameterIndex, Object x) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
execute
public boolean execute() throws SQLException
- Specified by:
execute
in interfacePreparedStatement
- Throws:
SQLException
-
addBatch
public void addBatch() throws SQLException
- Specified by:
addBatch
in interfacePreparedStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setRef
public void setRef(int parameterIndex, Ref x) throws SQLException
- Specified by:
setRef
in interfacePreparedStatement
- Throws:
SQLException
-
setBlob
public void setBlob(int parameterIndex, Blob x) throws SQLException
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
-
setClob
public void setClob(int parameterIndex, Clob x) throws SQLException
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
-
setArray
public void setArray(int parameterIndex, Array x) throws SQLException
- Specified by:
setArray
in interfacePreparedStatement
- Throws:
SQLException
-
getMetaData
public CellSetMetaData getMetaData()
- Specified by:
getMetaData
in interfacePreparedOlapStatement
- Specified by:
getMetaData
in interfacePreparedStatement
-
setDate
public void setDate(int parameterIndex, Date x, Calendar cal) throws SQLException
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
-
setTime
public void setTime(int parameterIndex, Time x, Calendar cal) throws SQLException
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal) throws SQLException
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType, String typeName) throws SQLException
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
-
setURL
public void setURL(int parameterIndex, URL x) throws SQLException
- Specified by:
setURL
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
getParameterName
public String getParameterName(int param) throws OlapException
- Specified by:
getParameterName
in interfaceOlapParameterMetaData
- Throws:
OlapException
-
getParameterOlapType
public Type getParameterOlapType(int param) throws OlapException
- Specified by:
getParameterOlapType
in interfaceOlapParameterMetaData
- Throws:
OlapException
-
getParameterCount
public int getParameterCount()
- Specified by:
getParameterCount
in interfaceParameterMetaData
-
isNullable
public int isNullable(int param) throws SQLException
- Specified by:
isNullable
in interfaceParameterMetaData
- Throws:
SQLException
-
isSigned
public boolean isSigned(int param) throws SQLException
- Specified by:
isSigned
in interfaceParameterMetaData
- Throws:
SQLException
-
getPrecision
public int getPrecision(int param) throws SQLException
- Specified by:
getPrecision
in interfaceParameterMetaData
- Throws:
SQLException
-
getScale
public int getScale(int param) throws SQLException
- Specified by:
getScale
in interfaceParameterMetaData
- Throws:
SQLException
-
getParameterType
public int getParameterType(int param) throws SQLException
- Specified by:
getParameterType
in interfaceParameterMetaData
- Throws:
SQLException
-
getParameterTypeName
public String getParameterTypeName(int param) throws SQLException
- Specified by:
getParameterTypeName
in interfaceParameterMetaData
- Throws:
SQLException
-
getParameterClassName
public String getParameterClassName(int param) throws SQLException
- Specified by:
getParameterClassName
in interfaceParameterMetaData
- Throws:
SQLException
-
getParameterMode
public int getParameterMode(int param) throws SQLException
- Specified by:
getParameterMode
in interfaceParameterMetaData
- Throws:
SQLException
-
isSet
public boolean isSet(int parameterIndex) throws SQLException
- Specified by:
isSet
in interfacePreparedOlapStatement
- Throws:
SQLException
-
unset
public void unset(int parameterIndex) throws SQLException
- Specified by:
unset
in interfacePreparedOlapStatement
- Throws:
SQLException
-
foo
<T> T foo(mondrian.olap4j.MondrianOlap4jPreparedStatement.TypeHelper<T> helper, Type type)
-
-