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). For Microsoft SQL Server 2005 and higher and Azure, this includes triggers that are fired by Data Definition Language (DDL) events.
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 following behavior occurs:
For Microsoft SQL Server 2005 and higher and Microsoft Windows Azure SQL Database, the driver does not report trigger results if the statement is a single Insert, Update, Delete, Create, Alter, Drop, Grant, Revoke, or Deny statement.
For other Microsoft SQL Server databases, the driver does not report trigger results if the statement is a single Insert, Update, or Delete 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.