This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 144493

Summary: Support multiple exceptions in a statement
Product: db Reporter: David Vancouvering <davidvc>
Component: Show DataAssignee: matthias42
Status: RESOLVED INCOMPLETE    
Severity: blocker CC: romanmostyka
Priority: P3    
Version: 6.x   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Exception Reporter:

Description David Vancouvering 2008-08-19 23:00:44 UTC 
In Sybase and MS SQL Server, you can execute a single set of SQL that contains multiple statements, each of which is
executed independently and each of which can return a result set, an update count, or throw an exception.  This
enhancement request is to support the ability to return multiple exceptions for a single execution.

See Issue 73341 for more details
Comment 1 _ ahimanikya 2008-08-29 06:49:41 UTC 
David, since you already have 73341, I am sending this to you Q.
Comment 2 Jiri Rechtacek 2009-10-16 14:02:40 UTC 
Reassigned to new owner.
Comment 3 matthias42 2016-01-29 15:18:37 UTC 
Closing this as it was not possible to create the stated state in mssql. Trying to setup a testcase always lead to mssql aborting execution on exception. No further statement is executed.

In addition to this it is unclear how these multiple exception should be reported. Scenario: "<statement1>;<statement2>" is prepared or executed and in this case an SQLException can be raised. The specification dictates, that multiple exceptions can be chained.

SQLExcecutionLoggerImpl already handles the case of chained exceptions. So it is unclear what more is expected. Closing therefore as INCOMPLETE.