Support ForumSupport Forum

Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: error when disconnecting from a stopped database.

Welcome, Guest: Login / Register; Guest Settings

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 8 - Pages: 1 - Last Post: Aug 18, 2010 9:55 AM Last Post By: Roger Bjarevall

Ronald Rood

Posts: 467
Registered: 10/12/05

error when disconnecting from a stopped database.
Posted: Jul 27, 2010 12:13 PM

Hi,

it does happen: while connected a database is bounced, or just stopped. This makes my session to that database invalid. When I quit dbVis or explicitly disconnect one such session, I get an error message stating that I should re-connect to that database first. I think this is strange.
Can that be fixed?

regards,
Ronald.
http://ronr.blogspot.com

Roger Bjarevall

Posts: 3,181
Registered: 12/17/04

Re: error when disconnecting from a stopped database.
Posted: Jul 30, 2010 1:38 PM

in response to: Ronald Rood

Hi Ronald,

What operation(s) trigger the message? A screenshot would help showing the message.

Best Regards

Roger

Ronald Rood

Posts: 467
Registered: 10/12/05

Re: error when disconnecting from a stopped database.
Posted: Jul 30, 2010 4:57 PM

in response to: Roger Bjarevall

	dbvis_reconnect_when_down_2.png (44.0 KB )
	dbvis_reconnect_when_down.png (43.6 KB )

1) connect to a database
2) shutdown that database
3) Quit DbVis

Next you get a serie of error messages trying you to convince to re connect to the database. What I want is to Quit so I don't want to reconnect ...

Roger Bjarevall

Posts: 3,181
Registered: 12/17/04

Re: error when disconnecting from a stopped database.
Posted: Aug 9, 2010 2:13 PM

in response to: Ronald Rood

Ronald,

I suspect this occur when DbVisualizer is in a certain state. In the screenshot you posted, can you please press the green down arrow so that I can see the full error?

(Currently I am unable to reproduce this and DbVisualizer exit fine if the connection is broken).

Regards

Roger

Ronald Rood

Posts: 467
Registered: 10/12/05

Re: error when disconnecting from a stopped database.
Posted: Aug 11, 2010 6:37 PM

in response to: Roger Bjarevall

dbvis_shutdown.png (107.1 KB )

Hi Roger,
here is one again. I had multiple databases open, most of them were 10gR2.

best regards,
Ronald.

Roger Bjarevall

Posts: 3,181
Registered: 12/17/04

Re: error when disconnecting from a stopped database.
Posted: Aug 12, 2010 9:47 AM

in response to: Ronald Rood

Ronald,

Thanks!

May I ask you to enable debug of DbVisualizer and whenever the disconnect problem occur open Tools->Debug Window and reply the log?

Enable the Debug mode in Tools->Debug Window (check Debug DbVisualizer).

Sorry for the trouble...

Best Regards

Roger
support@dbvis.com

Ronald Rood

Posts: 467
Registered: 10/12/05

Re: error when disconnecting from a stopped database.
Posted: Aug 13, 2010 2:11 PM

in response to: Roger Bjarevall

debug_2_dbvis.log (26.5 KB )

Hi Roger,
no problem, I could have uploaded it right away since I run with a debug logfile as default ...
In the log is the complete session for one database, including one query. After that query I shutdown aborted the database and stopped dbvis. There the pop-up a... popped up.

R.

Roger Bjarevall

Posts: 3,181
Registered: 12/17/04

Re: error when disconnecting from a stopped database.
Posted: Aug 13, 2010 2:49 PM

in response to: Ronald Rood

Thanks!

I finally found the problem. It occurs when auto commit is off.

A fix will be introduced in next maintenance version planned for release in next week.

Thanks for your help!

Best Regards

Roger

Roger Bjarevall

Posts: 3,181
Registered: 12/17/04

Re: error when disconnecting from a stopped database.
Posted: Aug 18, 2010 9:55 AM

in response to: Ronald Rood

Hi,

This is now fixed in the DbVisualizer 7.1.2 version.

Regards

Roger

Pages: 1

Back to Thread List