com.ziclix.python.sql

Class Procedure

public class Procedure extends Object

This class provides the necessary functionality to call stored procedures. It handles managing the database metadata and binding the appropriate parameters.

Version: $Revision: 2542 $

Author: brian zimmer last modified by $Author: fwierzbicki $

Constructor Summary
Procedure(PyCursor cursor, PyObject name)
Constructor Procedure
Method Summary
booleanisInput(int index)
This method determines whether the param at the specified index is an IN or INOUT param for a stored procedure.
voidnormalizeInput(PyObject params, PyObject bindings)
Prepare the binding dictionary with the correct datatypes.
CallableStatementprepareCall()
Prepares the statement and registers the OUT/INOUT parameters (if any).
CallableStatementprepareCall(PyObject rsType, PyObject rsConcur)
Prepares the statement and registers the OUT/INOUT parameters (if any).
StringtoSql()
Returns the call in the syntax:

{?

Constructor Detail

Procedure

public Procedure(PyCursor cursor, PyObject name)
Constructor Procedure

Parameters: cursor cursor an open cursor name name a string or tuple representing the name

Throws: SQLException

Method Detail

isInput

public boolean isInput(int index)
This method determines whether the param at the specified index is an IN or INOUT param for a stored procedure. This is only configured properly AFTER a call to normalizeInput().

Parameters: index JDBC indexed column index (1, 2, ...)

Returns: true if the column is an input, false otherwise

Throws: SQLException

normalizeInput

public void normalizeInput(PyObject params, PyObject bindings)
Prepare the binding dictionary with the correct datatypes.

Parameters: params a non-None list of params bindings a dictionary of bindings

prepareCall

public CallableStatement prepareCall()
Prepares the statement and registers the OUT/INOUT parameters (if any).

Returns: CallableStatement

Throws: SQLException

prepareCall

public CallableStatement prepareCall(PyObject rsType, PyObject rsConcur)
Prepares the statement and registers the OUT/INOUT parameters (if any).

Parameters: rsType the value of to be created ResultSet type rsConcur the value of the to be created ResultSet concurrency

Returns: CallableStatement

Throws: SQLException

toSql

public String toSql()
Returns the call in the syntax:

{? = call (?, ?, ...)} {call (?, ?, ...)}

As of now, all parameters variables are created and no support for named variable calling is supported.

Returns: String