com.ziclix.python.sql
Class Procedure

java.lang.Object
  |
  +--com.ziclix.python.sql.Procedure

public class Procedure
extends java.lang.Object

Class Procedure

Version:
$Revision: 1.4 $
Author:
brian zimmer
, last modified by $Author: bzimmer $

Field Summary
static PyObject PLACEHOLDER
          Field PLACEHOLDER
 
Constructor Summary
Procedure(PyCursor cursor, PyObject name)
          Constructor Procedure
 
Method Summary
 boolean isInput(int index)
          This method determines whether the param at the specified index is an IN or INOUT param for a stored procedure.
 void normalizeInput(PyObject params, PyObject bindings)
          Prepare the binding dictionary with the correct datatypes.
 java.sql.CallableStatement prepareCall()
          Prepares the statement and registers the OUT/INOUT parameters (if any).
 java.lang.String toSql()
          Returns the call in the syntax: {?
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

PLACEHOLDER

public static final PyObject PLACEHOLDER
Field PLACEHOLDER

Constructor Detail

Procedure

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

Throws:
java.sql.SQLException
Method Detail

prepareCall

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

Returns:
CallableStatement
Throws:
java.sql.SQLException

normalizeInput

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

Parameters:
params - a non-None list of params
bindings - a dictionary of bindings
java.sql.SQLException

isInput

public boolean isInput(int index)
                throws java.sql.SQLException
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:
java.sql.SQLException

toSql

public java.lang.String toSql()
                       throws java.sql.SQLException
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
java.sql.SQLException


Jython homepage