com.ziclix.python.sql.handler

Class SQLServerDataHandler

java.lang.Object

com.ziclix.python.sql.DataHandler

com.ziclix.python.sql.FilterDataHandler

com.ziclix.python.sql.handler.SQLServerDataHandler

public class SQLServerDataHandler
extends FilterDataHandler

SQLServer specific data handling.

Field Summary

Fields

Modifier and Type	Field and Description
static int	UNICODE_VARCHAR Field UNICODE_VARCHAR

Constructor Summary

Constructors

Constructor and Description
SQLServerDataHandler(DataHandler datahandler) Decorator for handling SQLServer specific issues.

Method Summary

Modifier and Type	Method and Description
Procedure	getProcedure(PyCursor cursor, PyObject name) A factory method for determing the correct procedure class to use per the cursor type.
PyObject	getPyObject(java.sql.ResultSet set, int col, int type) Given a ResultSet, column and type, return the appropriate Jython object.

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

__chain__, getRowId, postExecute, preExecute, setJDBCObject, setJDBCObject

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

checkNull, getMetaDataName, getPyObject, getSystemDataHandler, read, read, registerOut, toString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

UNICODE_VARCHAR

public static final int UNICODE_VARCHAR

Field UNICODE_VARCHAR

See Also:

Constant Field Values

Constructor Detail

SQLServerDataHandler

public SQLServerDataHandler(DataHandler datahandler)

Decorator for handling SQLServer specific issues.

Parameters:

datahandler - the delegate DataHandler

Method Detail

getProcedure

public Procedure getProcedure(PyCursor cursor,
                              PyObject name)
                       throws java.sql.SQLException

Description copied from class: DataHandler

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

Overrides:

getProcedure in class DataHandler

Parameters:

cursor - an open cursor

name - the name of the procedure to invoke

Returns:

an instance of a Procedure

Throws:

java.sql.SQLException

getPyObject

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

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

Note: DO NOT iterate the ResultSet.

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