<call/>

A modification of QueryDataSource that supports stored procedures, in particular with Oracle, and in particular out parameters.

Out parameters are arguments, but they do not bind on input. They bind on output. If an out parameter binds to a result set (cursor), that result set can be given a mapping to output an entity (or entities). Each out cursor needs to have a separate set of result mappings. The xml will look like this: <call> <sql>...</sql> <arguments> ... (bindings, including out bindings) </arguments> <results> ... (mappings for result set returned, if any) </results> <outresults> <outresult index="2"> (0-based index of cursor argument) <result> ... (entity result binding) </result> </outresult> <outresults> </call>

Implemented by:
thinkmap.datasource.database.ProcedureCallDataSource

Simple Attributes

bindableEntityType

description: Set the entity type this query DataSource responds to. If no entity type is set, this will bind to any entity type.

type: String

required: No


default: Will bind to any entity type
debug

description: Set the true to enable debug output.

type: boolean

required: No


default: False
maxResults

description: Set the maximum number of results to be returned by this query, or -1 for no limit.

type: int

required: No


default: -1 (no liimit)
SQL

description: Set the query string used by this query DataSource.

type: String

required: Yes

type

description: Set the type of this query. Can be 'related', 'search', 'entity', 'list', 'index', 'update', 'add', 'insert', 'remove', or 'delete'.

type: String

required: No

Complex Attributes

<arguments/>

description: Set the array of argument bindings that this query DataSource uses.

type: thinkmap.datasource.relational.Binding

required: No


Valid Children
<attributebinding/>
<constantbinding/>
<entityidbinding/>
<entitypropertybinding/>
<outbinding/>
<sqlbinding/>
<outResults/>

description: Set the array of out parameter results. These should correspond to out bindings in the procedure arguments.

type: thinkmap.datasource.database.OutResult

required: No


Valid Children
<outresult/>
<rejectionBinding/>

description: Set a binding that will prevent this query from executing. If this binding returns false, or the binding throws a BindingException, the query cannot execute.

type: thinkmap.datasource.relational.Binding

required: No


Valid Children
<attributebinding/>
<constantbinding/>
<entityidbinding/>
<entitypropertybinding/>
<outbinding/>
<sqlbinding/>
<results/>

description: Set the EntityResultMapping array this uses when sending back results.

type: thinkmap.datasource.database.EntityResultMapping

required: Yes


Valid Children
<result/>