Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Connection Clustering |
| Version | 15.0 |
Product: Aqua Data Studio
Version: 14.0.3-21
Build #: 34729
Build Date: 2013-Nov-06 06:10:36 AM
Operating Environment: Windows XP (5.2, amd64) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_43-b01 Memory: Max=891,092,992; Total=443,940,864; Free=260,130,840; CPUs=8
relates to https://www.aquaclusters.com/app/home/project/public/aquadatastudio/issue/10673
Solution:
a) In Query Analyzer, if Autocommit is disabled and user tries to switch DB, display a warning message similar to the one displayed by Informix.
b) If user does commits or rollsback and switches DB, then this DB should also be set to autoCommit off.
Here on step b) I need to press the commit button 2 times. Focus seems to still be in the DB dropdown that appears behind the prompt.
See attached GIF Animation
@funfun: only fix if the fix is low impact and relatively low complexity.
The database combo box has the focus and is not collapsed while the confirmation dialog is displayed, that's why user needs to click twice. This is the way how that dialog was originally implemented for Informix server. I did not change this behavior for PostgreSQL.
The database combo box has the focus and is not collapsed while the confirmation dialog is displayed, that's why user needs to click twice. This is the way how that dialog was originally implemented for Informix server. I did not change this behavior for PostgreSQL.
> @funfun: only fix if the fix is low impact and relatively low complexity.
When a database is selected from the combo box, an action is triggered. In the current implementation, the action is executed while pulldown menu is displayed (pulldown menu has the focus). One way to work around this problem is to defer the execution of triggered action until the pulldown menu of the combo box disappeared, so that when the confirmation dialog shows up, it will have window's focus. This workaround only needs to add a few line of code, however, it will affect all of supported DB servers. I played with this workaround with Informix, PostgreSQL, MySQL, and SQL Server. It seems to be OK. Let me know if you want to include it in 14.0.
In addition, the message currently displayed in the confirmation dialog is:
"You currently have auto-commit disabled, which requires a commit or rollback to change databases. Would you like to continue?"
After a selection is made, user cannot tell what is the previously selected database (old database name) from the database combo box, I think it would be nice to include the old database name in the message as well, for example:
"Database 'database-name' currently has auto-commit disabled, which requires a commit or rollback to change databases. Would you like to continue?"
> @funfun: only fix if the fix is low impact and relatively low complexity.
When a database is selected from the combo box, an action is triggered. In the current implementation, the action is executed while pulldown menu is displayed (pulldown menu has the focus). One way to work around this problem is to defer the execution of triggered action until the pulldown menu of the combo box disappeared, so that when the confirmation dialog shows up, it will have window's focus. This workaround only needs to add a few line of code, however, it will affect all of supported DB servers. I played with this workaround with Informix, PostgreSQL, MySQL, and SQL Server. It seems to be OK. Let me know if you want to include it in 14.0.
In addition, the message currently displayed in the confirmation dialog is:
"You currently have auto-commit disabled, which requires a commit or rollback to change databases. Would you like to continue?"
After a selection is made, user cannot tell what is the previously selected database (old database name) from the database combo box, I think it would be nice to include the old database name in the message as well, for example:
"Database 'database-name' currently has auto-commit disabled, which requires a commit or rollback to change databases. Would you like to continue?"
Done: SVN r34742,r34743/15.0.0-dev-35
(1) Deferred action execution after a selection is made from the database combo box - this applies to all off supported DB servers.
(2) Dialog message change - this applies to Informix and those servers that use connection clustering.
Done: SVN r34742,r34743/15.0.0-dev-35
(1) Deferred action execution after a selection is made from the database combo box - this applies to all off supported DB servers.
(2) Dialog message change - this applies to Informix and those servers that use connection clustering.
Issue #10698 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 15.0.0-dev-35 |
| No time estimate |
1 issue link |
relates to #10673
Issue #10673Issues with connection clustering on changing databases from the default specified in the server properties |
@funfun: only fix if the fix is low impact and relatively low complexity.