Top Description Constructors Methods
com.ziclix.python.sql.handler

public Class OracleDataHandler

extends FilterDataHandler
Class Inheritance
Imports
java.sql.CallableStatement, .PreparedStatement, .ResultSet, .ResultSetMetaData, .SQLException, .Timestamp, .Types, oracle.jdbc.OracleResultSet, oracle.jdbc.OracleTypes, oracle.sql.BLOB, oracle.sql.ROWID, org.python.core.Py, .PyInteger, .PyObject, com.ziclix.python.sql.DataHandler, .FilterDataHandler

Oracle specific data handling.
Author
brian zimmer

Constructor Summary

AccessConstructor and Description
public
OracleDataHandler(DataHandler datahandler)

Default constructor for DataHandler filtering.

Method Summary

Modifier and TypeMethod and Description
public String

Returns:

String
getMetaDataName
(PyObject name)

Overrides com.ziclix.python.sql.DataHandler.getMetaDataName.

Method getMetaDataName

public PyObject
getPyObject(ResultSet set, int col, int type)

Overrides com.ziclix.python.sql.FilterDataHandler.getPyObject.

Provide functionality for Oracle specific types, such as ROWID.

public void
registerOut(CallableStatement statement, int
the JDBC offset column number
index
,
int
the column as from DatabaseMetaData (eg, procedureColumnOut)
colType
,
int
the JDBC datatype from Types
dataType
,
String
the JDBC datatype name
dataTypeName
)

Overrides com.ziclix.python.sql.DataHandler.registerOut.

Called when a stored procedure or function is executed and OUT parameters need to be registered with the statement.

public void
setJDBCObject(PreparedStatement stmt, int index, PyObject object, int type)

Overrides com.ziclix.python.sql.FilterDataHandler.setJDBCObject.

Provide functionality for Oracle specific types, such as ROWID.

Inherited from com.ziclix.python.sql.FilterDataHandler:
__chain__getRowIdpostExecutepreExecutesetJDBCObject

Constructor Detail

OracleDataHandlerback to summary
public OracleDataHandler(DataHandler datahandler)

Default constructor for DataHandler filtering.

Method Detail

getMetaDataNameback to summary
public String getMetaDataName(PyObject name)

Overrides com.ziclix.python.sql.DataHandler.getMetaDataName.

Method getMetaDataName

Returns:String

String

Annotations
@Override

getPyObjectback to summary
public PyObject getPyObject(ResultSet set, int col, int type) throws SQLException

Overrides com.ziclix.python.sql.FilterDataHandler.getPyObject.

Provide functionality for Oracle specific types, such as ROWID.

Returns:PyObject

Doc from com.ziclix.python.sql.FilterDataHandler.getPyObject.

PyObject

Annotations
@Override
Exceptions
SQLException:

Doc from com.ziclix.python.sql.DataHandler.getPyObject.

if the type is unmappable

registerOutback to summary
public void registerOut(CallableStatement statement, int index, int colType, int dataType, String dataTypeName) throws SQLException

Overrides com.ziclix.python.sql.DataHandler.registerOut.

Called when a stored procedure or function is executed and OUT parameters need to be registered with the statement.

Parameters
index:int

the JDBC offset column number

colType:int

the column as from DatabaseMetaData (eg, procedureColumnOut)

dataType:int

the JDBC datatype from Types

dataTypeName:String

the JDBC datatype name

Annotations
@Override
setJDBCObjectback to summary
public void setJDBCObject(PreparedStatement stmt, int index, PyObject object, int type) throws SQLException

Overrides com.ziclix.python.sql.FilterDataHandler.setJDBCObject.

Provide functionality for Oracle specific types, such as ROWID.

Annotations
@Override