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

public Class SQLServerDataHandler

extends FilterDataHandler
Class Inheritance
Imports
com.ziclix.python.sql.DataHandler, .FilterDataHandler, .Procedure, .PyCursor, com.ziclix.python.sql.procedure.SQLServerProcedure, org.python.core.Py, .PyObject, java.sql.ResultSet, .SQLException, .Types
SQLServer specific data handling.
Author
brian zimmer

Field Summary

Modifier and TypeField and Description
public static final int
UNICODE_VARCHAR

Field UNICODE_VARCHAR

Constructor Summary

AccessConstructor and Description
public
SQLServerDataHandler(DataHandler
the delegate DataHandler
datahandler)

Decorator for handling SQLServer specific issues.

Method Summary

Modifier and TypeMethod and Description
public Procedure
getProcedure(PyCursor
an open cursor
cursor, PyObject
the name of the procedure to invoke
name)

Overrides com.ziclix.python.sql.DataHandler.getProcedure.

A factory method for determing the correct procedure class to use per the cursor type.

public PyObject
getPyObject(ResultSet
the current ResultSet set to the current row
set, int
the column number (adjusted properly for JDBC)
col, int
the column type
type)

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

Given a ResultSet, column and type, return the appropriate Jython object.

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

Field Detail

UNICODE_VARCHARback to summary
public static final int UNICODE_VARCHAR

Field UNICODE_VARCHAR

Constructor Detail

SQLServerDataHandlerback to summary
public SQLServerDataHandler(DataHandler datahandler)

Decorator for handling SQLServer specific issues.

Parameters
datahandler:DataHandler

the delegate DataHandler

Method Detail

getProcedureback to summary
public Procedure getProcedure(PyCursor cursor, PyObject name) throws SQLException

Overrides com.ziclix.python.sql.DataHandler.getProcedure.

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

A factory method for determing the correct procedure class to use per the cursor type.

Parameters
cursor:PyCursor

an open cursor

name:PyObject

the name of the procedure to invoke

Returns:Procedure

an instance of a Procedure

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

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

Given a ResultSet, column and type, return the appropriate Jython object.

Note

DO NOT iterate the ResultSet.

Parameters
set:ResultSet

the current ResultSet set to the current row

col:int

the column number (adjusted properly for JDBC)

type:int

the column type

Returns:PyObject

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

PyObject

Exceptions
SQLException:
if the type is unmappable