[This topic is migrated from our old forums. The original author name has been removed]
Product: DbVisualizer Pro 9.2.8 [Build #2468]
OS: Windows 7
OS Version: 6.1
OS Arch: amd64
Java Version: 1.8.0_51
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Vendor: Oracle Corporation
Steps to reproduce:
1. Connect to database with autocommit option turned off
2. Open new tab and execute any query from it
3. Click "rollback" button on that tab
4. Select "disconnect" from connection context menu in connections list to the left
5. "Process uncommitted update(s)" prompt appears though there are no uncommitted changes, we just rolled back everything
Also if you close the tab (it closes without commit/rollback prompt) after step 3 then step 4 works fine and no prompt appears.
Ruslan,
The dialog is displayed to guarantee unhandled transactions are taken care of when disconnecting. Its appearance may in some situations look odd based on that no changes has been made but there is no way to 100% technically guarantee there are no unhandled transactions.
I have open a new ticket regarding no dialog for commit/rollback is displayed when closing a SQL Commander tab. The behavior should be consistent independent where the disconnect is initiated in DbVisualizer.
In Tools->Tool Properties and in the General / Transaction category you can change the default action for the commit/rollback dialog to instead always be Commit or Rollback at disconnect. It is by default set to Ask.
Regards
Roger
a
anonymous
said
over 9 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Invalid commit/rollback prompt
Roger,
It looks rather odd to me that we cannot track the state of our own transactions.
Nevertheless, the consistent dialog works for me too (I don't want to use any default behavior for things like that). Thanks for your help.
Is the ticket you've mentioned an internal one or there is a way to track it?
Roger Bjärevall
said
over 9 years ago
[This reply is migrated from our old forums.]
Re: Invalid commit/rollback prompt
Ruslan,
It is an internal ticketing system. You'll be notified through this forum whenever it is fixed.
Regards
Roger
Roger Bjärevall
said
over 9 years ago
[This reply is migrated from our old forums.]
Re: Invalid commit/rollback prompt
Ruslan,
Just to let you know DbVisualizer 9.2.10 has just been released with the consistency fix applied.
Release notes: http://www.dbvis.com/doc/relnotes/?version=9.2.10
Easiest is that you open Help->Check for Update in DbVisualizer to perform the upgrade.
An alternative is that you download from our web site:
http://www.dbvis.com/download/
Regards
Roger
a
anonymous
said
over 9 years ago
[This reply is migrated from our old forums. The original author name has been removed]
anonymous