C H A P T E R 30 - JDBC Stored Procedure Model

C H A P T E R 30

JDBC Stored Procedure Model

The JDBC Stored Procedure model allows developers to execute stored procedures. This allows display fields to be bound to parameters and result columns (where vendor supported) in the stored procedure.

Property Name	Description	Notes
Data Source	The JDBC datasource name that will be used to obtain a connection from the J2EE container.	Req
Name	The class name of the component.	Req
Procedure Name	The name of the stored procedure in the RDBMS which this model will invoke.	Req

Result Set Column Fields

Property Name	Description	Notes
Column Name	The name of the result column to which the model field maps in the stored procedure.	Req
Field Type	The Java class type of the model field (java.lang.String, java.lang.Integer, java.lang.Boolean, etc.).	Req
Name	The logical name of the model field.	Req

Procedure Parameter Fields

Property Name	Description	Notes
Parameter Class	The Java class type of the model field (java.lang.String, java.lang.Integer, java.lang.Boolean, etc.). Note, this is not the actual parameter SQL type in the database.	Req
Parameter Name	The name of the parameter in the stored procedure to which this field is bound.	Req
Parameter Type	The stored procedure parameter type: IN, IN_OUT, OUT, RESULT, RETURN, and UNKNOWN.	Req
Name	The logical name of the model field.	Req
SQL Type	The SQL datatype (from `java.sql.Types`) of the parameter: VARCHAR, TIMESTAMP, SMALLINT, etc.	Req

Copyright © 2004, Sun Microsystems, Inc. All rights reserved.