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 - Specific connection for each open editor
Summary: Specific connection for each open editor
Status: RESOLVED DUPLICATE of bug 31149
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks: 65764
  Show dependency tree
 
Reported: 2008-11-05 11:43 UTC by sansan
Modified: 2012-04-17 19:03 UTC (History)
1 user (show)

See Also:
Issue Type: TASK
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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