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, createUnsupportedTypeSQLException, getMetaDataName, getPyObject, getSystemDataHandler, read, read, registerOut, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, 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