mondrian.olap4j
Class MondrianOlap4jPreparedStatement
java.lang.Object
mondrian.olap4j.MondrianOlap4jStatement
mondrian.olap4j.MondrianOlap4jPreparedStatement
- All Implemented Interfaces:
- java.sql.ParameterMetaData, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper, OlapParameterMetaData, OlapStatement, OlapWrapper, PreparedOlapStatement
abstract class MondrianOlap4jPreparedStatement
- extends MondrianOlap4jStatement
- implements PreparedOlapStatement, OlapParameterMetaData
Implementation of 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)
.
- Since:
- Jun 12, 2007
- Version:
- $Id: //open/mondrian/src/main/mondrian/olap4j/MondrianOlap4jPreparedStatement.java#4 $
- Author:
- jhyde
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 |
Fields inherited from interface java.sql.ParameterMetaData |
parameterModeIn, parameterModeInOut, parameterModeOut, parameterModeUnknown, parameterNoNulls, parameterNullable, parameterNullableUnknown |
Method Summary |
void |
addBatch()
|
void |
clearParameters()
|
boolean |
execute()
|
CellSet |
executeOlapQuery(java.lang.String mdx)
|
CellSet |
executeQuery()
|
int |
executeUpdate()
|
(package private)
|
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 |
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)
|
Methods inherited from class mondrian.olap4j.MondrianOlap4jStatement |
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeOlapQuery, executeOlapQueryInternal, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface java.sql.PreparedStatement |
setAsciiStream, setAsciiStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setCharacterStream, setCharacterStream, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setRowId, setSQLXML |
Methods inherited from interface java.sql.Statement |
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout |
Methods inherited from interface java.sql.Wrapper |
isWrapperFor, unwrap |
cellSetMetaData
MondrianOlap4jCellSetMetaData cellSetMetaData
MondrianOlap4jPreparedStatement
public MondrianOlap4jPreparedStatement(MondrianOlap4jConnection olap4jConnection,
java.lang.String mdx)
executeOlapQuery
public CellSet executeOlapQuery(java.lang.String mdx)
throws OlapException
- Specified by:
executeOlapQuery
in interface OlapStatement
- Overrides:
executeOlapQuery
in class MondrianOlap4jStatement
- Throws:
OlapException
executeQuery
public CellSet executeQuery()
throws OlapException
- Specified by:
executeQuery
in interface java.sql.PreparedStatement
- Specified by:
executeQuery
in interface PreparedOlapStatement
- Throws:
OlapException
getParameterMetaData
public OlapParameterMetaData getParameterMetaData()
throws OlapException
- Specified by:
getParameterMetaData
in interface java.sql.PreparedStatement
- Specified by:
getParameterMetaData
in interface PreparedOlapStatement
- Throws:
OlapException
getCube
public Cube getCube()
- Specified by:
getCube
in interface PreparedOlapStatement
executeUpdate
public int executeUpdate()
throws java.sql.SQLException
- Specified by:
executeUpdate
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setNull
public void setNull(int parameterIndex,
int sqlType)
throws java.sql.SQLException
- Specified by:
setNull
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setBoolean
public void setBoolean(int parameterIndex,
boolean x)
throws java.sql.SQLException
- Specified by:
setBoolean
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setByte
public void setByte(int parameterIndex,
byte x)
throws java.sql.SQLException
- Specified by:
setByte
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setShort
public void setShort(int parameterIndex,
short x)
throws java.sql.SQLException
- Specified by:
setShort
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setInt
public void setInt(int parameterIndex,
int x)
throws java.sql.SQLException
- Specified by:
setInt
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setLong
public void setLong(int parameterIndex,
long x)
throws java.sql.SQLException
- Specified by:
setLong
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setFloat
public void setFloat(int parameterIndex,
float x)
throws java.sql.SQLException
- Specified by:
setFloat
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setDouble
public void setDouble(int parameterIndex,
double x)
throws java.sql.SQLException
- Specified by:
setDouble
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setBigDecimal
public void setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
- Specified by:
setBigDecimal
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setString
public void setString(int parameterIndex,
java.lang.String x)
throws java.sql.SQLException
- Specified by:
setString
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setBytes
public void setBytes(int parameterIndex,
byte[] x)
throws java.sql.SQLException
- Specified by:
setBytes
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setDate
public void setDate(int parameterIndex,
java.sql.Date x)
throws java.sql.SQLException
- Specified by:
setDate
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setTime
public void setTime(int parameterIndex,
java.sql.Time x)
throws java.sql.SQLException
- Specified by:
setTime
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setTimestamp
public void setTimestamp(int parameterIndex,
java.sql.Timestamp x)
throws java.sql.SQLException
- Specified by:
setTimestamp
in interface java.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 interface java.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 interface java.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 interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
clearParameters
public void clearParameters()
throws java.sql.SQLException
- Specified by:
clearParameters
in interface java.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 interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setObject
public void setObject(int parameterIndex,
java.lang.Object x)
throws java.sql.SQLException
- Specified by:
setObject
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
execute
public boolean execute()
throws java.sql.SQLException
- Specified by:
execute
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
addBatch
public void addBatch()
throws java.sql.SQLException
- Specified by:
addBatch
in interface java.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 interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setRef
public void setRef(int parameterIndex,
java.sql.Ref x)
throws java.sql.SQLException
- Specified by:
setRef
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setBlob
public void setBlob(int parameterIndex,
java.sql.Blob x)
throws java.sql.SQLException
- Specified by:
setBlob
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setClob
public void setClob(int parameterIndex,
java.sql.Clob x)
throws java.sql.SQLException
- Specified by:
setClob
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setArray
public void setArray(int parameterIndex,
java.sql.Array x)
throws java.sql.SQLException
- Specified by:
setArray
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
getMetaData
public CellSetMetaData getMetaData()
- Specified by:
getMetaData
in interface java.sql.PreparedStatement
- Specified by:
getMetaData
in interface PreparedOlapStatement
setDate
public void setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal)
throws java.sql.SQLException
- Specified by:
setDate
in interface java.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 interface java.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 interface java.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 interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
setURL
public void setURL(int parameterIndex,
java.net.URL x)
throws java.sql.SQLException
- Specified by:
setURL
in interface java.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 interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
getParameterName
public java.lang.String getParameterName(int param)
throws OlapException
- Specified by:
getParameterName
in interface OlapParameterMetaData
- Throws:
OlapException
getParameterOlapType
public Type getParameterOlapType(int param)
throws OlapException
- Specified by:
getParameterOlapType
in interface OlapParameterMetaData
- Throws:
OlapException
getParameterCount
public int getParameterCount()
- Specified by:
getParameterCount
in interface java.sql.ParameterMetaData
isNullable
public int isNullable(int param)
throws java.sql.SQLException
- Specified by:
isNullable
in interface java.sql.ParameterMetaData
- Throws:
java.sql.SQLException
isSigned
public boolean isSigned(int param)
throws java.sql.SQLException
- Specified by:
isSigned
in interface java.sql.ParameterMetaData
- Throws:
java.sql.SQLException
getPrecision
public int getPrecision(int param)
throws java.sql.SQLException
- Specified by:
getPrecision
in interface java.sql.ParameterMetaData
- Throws:
java.sql.SQLException
getScale
public int getScale(int param)
throws java.sql.SQLException
- Specified by:
getScale
in interface java.sql.ParameterMetaData
- Throws:
java.sql.SQLException
getParameterType
public int getParameterType(int param)
throws java.sql.SQLException
- Specified by:
getParameterType
in interface java.sql.ParameterMetaData
- Throws:
java.sql.SQLException
getParameterTypeName
public java.lang.String getParameterTypeName(int param)
throws java.sql.SQLException
- Specified by:
getParameterTypeName
in interface java.sql.ParameterMetaData
- Throws:
java.sql.SQLException
getParameterClassName
public java.lang.String getParameterClassName(int param)
throws java.sql.SQLException
- Specified by:
getParameterClassName
in interface java.sql.ParameterMetaData
- Throws:
java.sql.SQLException
getParameterMode
public int getParameterMode(int param)
throws java.sql.SQLException
- Specified by:
getParameterMode
in interface java.sql.ParameterMetaData
- Throws:
java.sql.SQLException
foo
<T> T foo(mondrian.olap4j.MondrianOlap4jPreparedStatement.TypeHelper<T> helper,
Type type)