<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
|
|
|
|
| <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
|
|
|
|
| <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
|
|
|
|
| <results/> |
| description: |
Set the EntityResultMapping array this uses when sending back results.
|
| type: |
thinkmap.datasource.database.EntityResultMapping
|
| required: |
Yes
|
|
|
|