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 - Support multiple exceptions in a statement
Summary: Support multiple exceptions in a statement
Status: RESOLVED INCOMPLETE
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: matthias42
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-19 23:00 UTC by David Vancouvering
Modified: 2016-01-29 15:18 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.