com.ziclix.python.sql.procedure

Class SQLServerProcedure

java.lang.Object

com.ziclix.python.sql.Procedure

com.ziclix.python.sql.procedure.SQLServerProcedure

public class SQLServerProcedure
extends Procedure

Stored procedure support for SQLServer.

Field Summary

Fields inherited from class com.ziclix.python.sql.Procedure

COLUMN_TYPE, columns, cursor, DATA_TYPE, DATA_TYPE_NAME, inputSet, LENGTH, NAME, NULLABLE, PRECISION, procedureCatalog, procedureName, procedureSchema, SCALE

Constructor Summary

Constructors

Constructor and Description
SQLServerProcedure(PyCursor cursor, PyObject name)

Method Summary

Modifier and Type	Method and Description
protected PyObject	getDefault() The value for a missing schema or catalog.
protected java.lang.String	getProcedureName() Construct a procedure name for the relevant schema and catalog information.

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

fetchColumns, isInput, normalizeInput, prepareCall, prepareCall, registerOutParameters, toSql

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLServerProcedure

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

Throws:

java.sql.SQLException

Method Detail

getDefault

protected PyObject getDefault()

Description copied from class: Procedure

The value for a missing schema or catalog. This value is used to find the column names for the procedure. Not all DBMS use the same default value; for instance Oracle uses an empty string and SQLServer a null. This implementation returns the empty string.

Overrides:

getDefault in class Procedure

Returns:

the default value (the empty string)

See Also:

DatabaseMetaData.getProcedureColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)

getProcedureName

protected java.lang.String getProcedureName()

Description copied from class: Procedure

Construct a procedure name for the relevant schema and catalog information.

Overrides:

getProcedureName in class Procedure