com.caucho.quercus.lib.db

Class OracleStatement

java.lang.Object

com.caucho.quercus.lib.db.JdbcStatementResource

com.caucho.quercus.lib.db.JdbcPreparedStatementResource

com.caucho.quercus.lib.db.OracleStatement

public class OracleStatement
extends JdbcPreparedStatementResource

Oracle statement class. Since Oracle has no object oriented API, this is essentially a JdbcStatementResource.

Method Summary

Modifier and Type	Method and Description
protected JdbcResultResource	createResultSet(java.sql.ResultSet rs)
protected boolean	execute(Env env, int mode)
java.lang.Integer	getBindingVariable(java.lang.String name) Returns a binding variable index
java.util.HashMap<java.lang.String,java.lang.Integer>	getBindingVariables() Returns all binding variables
Value	getByNameVariable(java.lang.String name) Returns the variable value by name
java.util.HashMap<java.lang.String,Value>	getByNameVariables() Returns all variable names and corresponding values
protected java.sql.CallableStatement	getCallableStatement() Gets the underlying callable statement.
protected int	getFetchedRows() Gets the number of fetched rows.
protected OracleOciLob	getOutParameter() Gets the out parameter.
Value	getResultBuffer() Returns the internal result buffer
protected int	increaseFetchedRows() Increases the number of fetched rows.
void	putBindingVariable(java.lang.String name, java.lang.Integer value) Assigns a variable name to the corresponding index
void	putByNameVariable(java.lang.String name, Value value) Assigns a value to a variable
java.lang.Integer	removeBindingVariable(java.lang.String name) Removes a binding variable
Value	removeByNameVariable(java.lang.String name) Removes a variable given the corresponding name
void	resetBindingVariables() Removes all binding variables
void	resetByNameVariables() Removes all variables
protected void	setOutParameter(OracleOciLob outParameter) Sets the out parameter.
void	setResultBuffer(Value resultBuffer) Sets the internal result buffer

Methods inherited from class com.caucho.quercus.lib.db.JdbcPreparedStatementResource

bindParams, executeImpl, getParam, getParamLength, getPreparedStatement, isPreparable, paramCount, prepare, prepareForExecute, setObject, setPreparedStatement

Methods inherited from class com.caucho.quercus.lib.db.JdbcStatementResource

bindResults, close, dataSeek, execute, execute, fetch, freeResult, getColumnCount, getConnection, getErrorCode, getErrorMessage, getException, getFieldCount, getJavaConnection, getMetaData, getNumRows, getQuery, getResultSet, getStatementType, isFetchFieldIndexBeforeFieldName, lastInsertId, setError, setErrorCode, setErrorMessage, setQuery, setResultSet, setStatement, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Method Detail

execute

protected boolean execute(Env env,
                          int mode)

createResultSet

protected JdbcResultResource createResultSet(java.sql.ResultSet rs)

Overrides:

createResultSet in class JdbcStatementResource

putBindingVariable

public void putBindingVariable(java.lang.String name,
                               java.lang.Integer value)

Assigns a variable name to the corresponding index

Parameters:

name - the variable name

value - the corresponding index

getBindingVariable

public java.lang.Integer getBindingVariable(java.lang.String name)

Returns a binding variable index

Parameters:

name - the variable name

Returns:

the binding variable index

removeBindingVariable

public java.lang.Integer removeBindingVariable(java.lang.String name)

Removes a binding variable

Parameters:

name - the binding variable name

Returns:

the binding variable index

getBindingVariables

public java.util.HashMap<java.lang.String,java.lang.Integer> getBindingVariables()

Returns all binding variables

Returns:

a HashMap of variable name to index values

resetBindingVariables

public void resetBindingVariables()

Removes all binding variables

setResultBuffer

public void setResultBuffer(Value resultBuffer)

Sets the internal result buffer

getResultBuffer

public Value getResultBuffer()

Returns the internal result buffer

Returns:

the result buffer

putByNameVariable

public void putByNameVariable(java.lang.String name,
                              Value value)

Assigns a value to a variable

Parameters:

name - a variable name

value - the variable value

getByNameVariable

public Value getByNameVariable(java.lang.String name)

Returns the variable value by name

Parameters:

name - the variable name

Returns:

the variable value

removeByNameVariable

public Value removeByNameVariable(java.lang.String name)

Removes a variable given the corresponding name

Parameters:

name - the variable name

Returns:

the variable value

getByNameVariables

public java.util.HashMap<java.lang.String,Value> getByNameVariables()

Returns all variable names and corresponding values

Returns:

a HashMap of variable names to corresponding values

resetByNameVariables

public void resetByNameVariables()

Removes all variables

increaseFetchedRows

protected int increaseFetchedRows()

Increases the number of fetched rows.

Returns:

the new number of fetched rows

getCallableStatement

protected java.sql.CallableStatement getCallableStatement()

Gets the underlying callable statement.

getFetchedRows

protected int getFetchedRows()

Gets the number of fetched rows.

Returns:

the number of fetched rows

getOutParameter

protected OracleOciLob getOutParameter()

Gets the out parameter.

Returns:

the out parameter

setOutParameter

protected void setOutParameter(OracleOciLob outParameter)

Sets the out parameter.

Parameters:

outParameter - the new out parameter