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.
When you want to use transactions in the Expolrer's Command Editor you must switch off auto-commit mode on the DB connection. But this prperty is missing in current implementation.
Another issue: Oracle by default creates temporary tables with option 'ON COMMIT DELETE ROWS' i.e. unusable with auto-commit mode.
*** Issue 51412 has been marked as a duplicate of this issue. ***
Reassigned to new owner.
We start to rely on Netbeans very very heavily. For example instead of starting the application server from scripts, we now simply start from the service tabs. We also plan to stop (or minimise) the use of DB IDE such as TOAD or SQLDeveloper in favour of in-built editor. Unfortunately, the auto-commit is giving a lot of pain, particularly when debugging/testing SQL statements.
> We also plan to stop (or minimise) the use of DB IDE such as TOAD or > SQLDeveloper in favour of in-built editor. Unfortunately, the auto-commit is > giving a lot of pain, particularly when debugging/testing SQL statements. Thanks for your feedback, I'll add this RFE among other issues to consider in planning phase.
*** Bug 76448 has been marked as a duplicate of this bug. ***
*** Bug 65764 has been marked as a duplicate of this bug. ***
*** Bug 152412 has been marked as a duplicate of this bug. ***
Note for potential implementers - comment 4 of bug 65764 looks like a good proposal to follow. Additional thinks to consider: - Should there be a central place to shutdown connections? - Do connection leaks have to tracked? - Should a connection pool be transparent? (=> each use could get a seperate connection, which is shared until two parallel transactions are needed (either by issuing a query while in autocommit mode or by beginning an explicit transaction)
*** Bug 151686 has been marked as a duplicate of this bug. ***