com.ziclix.python.sql.handler

Class OracleDataHandler

java.lang.Object

com.ziclix.python.sql.DataHandler

com.ziclix.python.sql.FilterDataHandler

com.ziclix.python.sql.handler.OracleDataHandler

public class OracleDataHandler
extends FilterDataHandler

Oracle specific data handling.

Constructor Summary

Constructors

Constructor and Description
OracleDataHandler(DataHandler datahandler) Default constructor for DataHandler filtering.

Method Summary

Modifier and Type	Method and Description
java.lang.String	getMetaDataName(PyObject name) Method getMetaDataName
PyObject	getPyObject(java.sql.ResultSet set, int col, int type) Provide functionality for Oracle specific types, such as ROWID.
void	registerOut(java.sql.CallableStatement statement, int index, int colType, int dataType, java.lang.String dataTypeName) Called when a stored procedure or function is executed and OUT parameters need to be registered with the statement.
void	setJDBCObject(java.sql.PreparedStatement stmt, int index, PyObject object, int type) Provide functionality for Oracle specific types, such as ROWID.

Methods inherited from class com.ziclix.python.sql.FilterDataHandler

__chain__, getRowId, postExecute, preExecute, setJDBCObject

Methods inherited from class com.ziclix.python.sql.DataHandler

checkNull, createUnsupportedTypeSQLException, getProcedure, getPyObject, getSystemDataHandler, read, read, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleDataHandler

public OracleDataHandler(DataHandler datahandler)

Default constructor for DataHandler filtering.

Method Detail

getMetaDataName

public java.lang.String getMetaDataName(PyObject name)

Method getMetaDataName

Overrides:

getMetaDataName in class DataHandler

Parameters:

name -

Returns:

String

setJDBCObject

public void setJDBCObject(java.sql.PreparedStatement stmt,
                          int index,
                          PyObject object,
                          int type)
                   throws java.sql.SQLException

Provide functionality for Oracle specific types, such as ROWID.

Overrides:

setJDBCObject in class FilterDataHandler

Parameters:

stmt - the current PreparedStatement

index - the index for which this object is bound

object - the PyObject in question

type - the java.sql.Types for which this PyObject should be bound

Throws:

java.sql.SQLException

getPyObject

public PyObject getPyObject(java.sql.ResultSet set,
                            int col,
                            int type)
                     throws java.sql.SQLException

Provide functionality for Oracle specific types, such as ROWID.

Overrides:

getPyObject in class FilterDataHandler

Parameters:

set - the current ResultSet set to the current row

col - the column number (adjusted properly for JDBC)

type - the column type

Returns:

PyObject

Throws:

java.sql.SQLException - if the type is unmappable

registerOut

public void registerOut(java.sql.CallableStatement statement,
                        int index,
                        int colType,
                        int dataType,
                        java.lang.String dataTypeName)
                 throws java.sql.SQLException

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

Overrides:

registerOut in class DataHandler

Parameters:

statement -

index - the JDBC offset column number

colType - the column as from DatabaseMetaData (eg, procedureColumnOut)

dataType - the JDBC datatype from Types

dataTypeName - the JDBC datatype name

Throws:

java.sql.SQLException