Package mondrian.olap4j
Class MondrianOlap4jPreparedStatement
- java.lang.Object
-
- mondrian.server.StatementImpl
-
- mondrian.olap4j.MondrianOlap4jStatement
-
- mondrian.olap4j.MondrianOlap4jPreparedStatement
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.sql.ParameterMetaData
,java.sql.PreparedStatement
,java.sql.Statement
,java.sql.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
-
-
Constructor Summary
Constructors Modifier Constructor Description protected
MondrianOlap4jPreparedStatement(MondrianOlap4jConnection olap4jConnection, java.lang.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()
java.lang.String
getParameterClassName(int param)
int
getParameterCount()
OlapParameterMetaData
getParameterMetaData()
int
getParameterMode(int param)
java.lang.String
getParameterName(int param)
Type
getParameterOlapType(int param)
int
getParameterType(int param)
java.lang.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, java.sql.Array x)
void
setAsciiStream(int parameterIndex, java.io.InputStream x, int length)
void
setBigDecimal(int parameterIndex, java.math.BigDecimal x)
void
setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
void
setBlob(int parameterIndex, java.sql.Blob x)
void
setBoolean(int parameterIndex, boolean x)
void
setByte(int parameterIndex, byte x)
void
setBytes(int parameterIndex, byte[] x)
void
setCharacterStream(int parameterIndex, java.io.Reader reader, int length)
void
setClob(int parameterIndex, java.sql.Clob x)
void
setDate(int parameterIndex, java.sql.Date x)
void
setDate(int parameterIndex, java.sql.Date x, java.util.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, java.lang.String typeName)
void
setObject(int parameterIndex, java.lang.Object x)
void
setObject(int parameterIndex, java.lang.Object x, int targetSqlType)
void
setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scaleOrLength)
void
setRef(int parameterIndex, java.sql.Ref x)
void
setShort(int parameterIndex, short x)
void
setString(int parameterIndex, java.lang.String x)
void
setTime(int parameterIndex, java.sql.Time x)
void
setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)
void
setTimestamp(int parameterIndex, java.sql.Timestamp x)
void
setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)
void
setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)
void
setURL(int parameterIndex, java.net.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
-
-
-
-
Field Detail
-
cellSetMetaData
MondrianOlap4jCellSetMetaData cellSetMetaData
-
-
Constructor Detail
-
MondrianOlap4jPreparedStatement
protected MondrianOlap4jPreparedStatement(MondrianOlap4jConnection olap4jConnection, java.lang.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 interfacejava.sql.PreparedStatement
- Throws:
OlapException
-
getParameterMetaData
public OlapParameterMetaData getParameterMetaData() throws OlapException
- Specified by:
getParameterMetaData
in interfacePreparedOlapStatement
- Specified by:
getParameterMetaData
in interfacejava.sql.PreparedStatement
- Throws:
OlapException
-
getCube
public Cube getCube()
- Specified by:
getCube
in interfacePreparedOlapStatement
-
executeUpdate
public int executeUpdate() throws java.sql.SQLException
- Specified by:
executeUpdate
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBoolean
public void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
- Specified by:
setBoolean
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setByte
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException
- Specified by:
setByte
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setShort
public void setShort(int parameterIndex, short x) throws java.sql.SQLException
- Specified by:
setShort
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setInt
public void setInt(int parameterIndex, int x) throws java.sql.SQLException
- Specified by:
setInt
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setLong
public void setLong(int parameterIndex, long x) throws java.sql.SQLException
- Specified by:
setLong
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setFloat
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException
- Specified by:
setFloat
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setDouble
public void setDouble(int parameterIndex, double x) throws java.sql.SQLException
- Specified by:
setDouble
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBigDecimal
public void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
- Specified by:
setBigDecimal
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setString
public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
- Specified by:
setString
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBytes
public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
- Specified by:
setBytes
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setUnicodeStream
public void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setUnicodeStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
clearParameters
public void clearParameters() throws java.sql.SQLException
- Specified by:
clearParameters
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
execute
public boolean execute() throws java.sql.SQLException
- Specified by:
execute
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
addBatch
public void addBatch() throws java.sql.SQLException
- Specified by:
addBatch
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setRef
public void setRef(int parameterIndex, java.sql.Ref x) throws java.sql.SQLException
- Specified by:
setRef
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.sql.Blob x) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.sql.Clob x) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setArray
public void setArray(int parameterIndex, java.sql.Array x) throws java.sql.SQLException
- Specified by:
setArray
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
getMetaData
public CellSetMetaData getMetaData()
- Specified by:
getMetaData
in interfacePreparedOlapStatement
- Specified by:
getMetaData
in interfacejava.sql.PreparedStatement
-
setDate
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setURL
public void setURL(int parameterIndex, java.net.URL x) throws java.sql.SQLException
- Specified by:
setURL
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scaleOrLength) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
getParameterName
public java.lang.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 interfacejava.sql.ParameterMetaData
-
isNullable
public int isNullable(int param) throws java.sql.SQLException
- Specified by:
isNullable
in interfacejava.sql.ParameterMetaData
- Throws:
java.sql.SQLException
-
isSigned
public boolean isSigned(int param) throws java.sql.SQLException
- Specified by:
isSigned
in interfacejava.sql.ParameterMetaData
- Throws:
java.sql.SQLException
-
getPrecision
public int getPrecision(int param) throws java.sql.SQLException
- Specified by:
getPrecision
in interfacejava.sql.ParameterMetaData
- Throws:
java.sql.SQLException
-
getScale
public int getScale(int param) throws java.sql.SQLException
- Specified by:
getScale
in interfacejava.sql.ParameterMetaData
- Throws:
java.sql.SQLException
-
getParameterType
public int getParameterType(int param) throws java.sql.SQLException
- Specified by:
getParameterType
in interfacejava.sql.ParameterMetaData
- Throws:
java.sql.SQLException
-
getParameterTypeName
public java.lang.String getParameterTypeName(int param) throws java.sql.SQLException
- Specified by:
getParameterTypeName
in interfacejava.sql.ParameterMetaData
- Throws:
java.sql.SQLException
-
getParameterClassName
public java.lang.String getParameterClassName(int param) throws java.sql.SQLException
- Specified by:
getParameterClassName
in interfacejava.sql.ParameterMetaData
- Throws:
java.sql.SQLException
-
getParameterMode
public int getParameterMode(int param) throws java.sql.SQLException
- Specified by:
getParameterMode
in interfacejava.sql.ParameterMetaData
- Throws:
java.sql.SQLException
-
isSet
public boolean isSet(int parameterIndex) throws java.sql.SQLException
- Specified by:
isSet
in interfacePreparedOlapStatement
- Throws:
java.sql.SQLException
-
unset
public void unset(int parameterIndex) throws java.sql.SQLException
- Specified by:
unset
in interfacePreparedOlapStatement
- Throws:
java.sql.SQLException
-
foo
<T> T foo(mondrian.olap4j.MondrianOlap4jPreparedStatement.TypeHelper<T> helper, Type type)
-
-