Database.createQuery()
Signature
String createQuery(String jdbcURI, String cursorName, String resultConceptURI, String sql, int pageSize, Object requestObj)
Domain
ACTION, CONDITION, BUI
Description
Opens a database cursor for the given sql query.
Parameters
| Name | Type | Description |
|---|
jdbcURI | String | The JDBC URI of the resource to be used for getting connection. |
cursorName | String | The name of the cursor to be opened |
resultTypeURI | String | a user can retrieve the column values by specifying column names as key |
sql | String | The sql query string, it can be a prepared statement query or a simple statement query. |
pageSize | int | The number of concepts/records to be fetched from the database for each page |
requestObj | Object | array of arguments |
Returns
| Type | Description |
|---|
String | The cursor name of the cursor opened |