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 152412

Summary:	Specific connection for each open editor
Product:	db	Reporter:	sansan <sansan>
Component:	SQL Editor	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED DUPLICATE
Severity:	blocker	CC:	romanmostyka
Priority:	P3
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	TASK	Exception Reporter:
Bug Depends on:
Bug Blocks:	65764

Description sansan 2008-11-05 11:43:02 UTC

To make transaction handling possible (work with auto-commit = off) i think it was a simple solution
to give each open sql editor his own database connection.
Other views (db explorer) can share one db connection to retrieve database metadata and so on.

An option is to make this configurable by user. By default each editor will use it's own database connection to keep 
the transactions apart. The user can control this behavior through an option in db-settings panel.

To work with auto-commit off, buttons at the sql editor toolbar are needed (commit/rollback)

Comment 1 David Vancouvering 2008-11-05 21:32:08 UTC

This is more of an internal implementation decision how we do this.  I think what you're asking for is that ability to
set autocommit separately for each open editor.  So, I think this issue is actually a task for implementing issue 65764.

Comment 2 Jiri Rechtacek 2009-10-16 14:06:35 UTC

Reassigned to new owner.

Comment 3 matthias42 2012-04-17 19:03:26 UTC

The interpretation from comment #2 sound sane - so this is a duplicate of bug # 31149.

*** This bug has been marked as a duplicate of bug 31149 ***