QueryOptions
Extends DataMappingOptions
| Key | Type | Default | Description |
|---|---|---|---|
| autoCommit | boolean | true | Specifies whether to execute the query in auto-commit mode |
| objectRows | boolean | false | Specifies whether rows are fetched as <FieldName, Value> pair objects or as arrays of values |
| typeMap | DataTypeMap | GlobalTypeMap | Data type map instance |
| cursor | boolean | If true, returns a Cursor instance instead of rows | |
| params | (BindParam | any)[] | Query execution parameters | |
| columnFormat | DataFormat | DataFormat[] | DataFormat.binary | Specifies the transfer format (binary or text) for each column |
| fetchCount | number | 100 | Specifies how many rows will be fetched. For a Cursor, this value specifies how many rows will be fetched per batch |
| rollbackOnError | boolean | true | When off, if a statement in a transaction block generates an error, the error is ignored and the transaction continues. When on (the default), a statement in a transaction block that generates an error aborts the entire transaction |
| signal | AbortSignal | Aborts the call when the signal fires: the running statement is cancelled on the server and the promise rejects with the signal's own reason, with the database error attached as cause. Cancelling is a request rather than a guarantee — the call settles when the server has actually finished, not the moment abort() is called. AbortSignal.timeout(ms) gives a per-call timeout | |
| asyncErrorHandling | boolean | the connection's own setting | Overrides the connection's own asyncErrorHandling for this call only — see DatabaseConnectionParams.asyncErrorHandling |