skip to main content
Connection property descriptions : AlwaysReportTriggerResults
  

Try DataDirect Drivers Now

AlwaysReportTriggerResults

Purpose

Determines how the driver reports results that are generated by database triggers (procedures that are stored in the database and executed, or fired, when a table is modified).

Valid values

true | false

Behavior

If set to true, the driver returns all results, including results that are generated by triggers. Multiple trigger results are returned sequentially. Use the Statement.getMoreResults() method to return individual trigger results. Warnings and errors are reported in the results as they are encountered.
If set to false, the driver does not report trigger results if the statement is a single Insert, Update, Delete, Create, Alter, Drop, Grant, Revoke, or Deny statement. The only result that is returned is the update count that is generated by the statement that was executed (if errors do not occur). Although trigger results are ignored, any errors that are generated by the trigger are reported. Any warnings that are generated by the trigger are enqueued. If errors are reported, the update count is not reported.

Data source method

setAlwaysReportTriggerResults

Default

false

Data type

Boolean