Start a new topic

DbVisualizer 5.1.1.7 now available

[This topic is migrated from our old forums. The original author name has been removed]

Hello, DbVisualizer 5.1.1.7 is now available in the early access web: http://www.minq.se/products/dbvis/eap Best Regards Roger

[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available npe
e = java.lang.NullPointerException
java.lang.NullPointerException
    at javax.swing.ToolTipManager.mouseExited(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Window.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventToSelf(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.trackMouseEnterExit(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

This happened when trying to pulldown the get bookmark entry of the menu. dbvis was open for about 1 day and could be running out of memory. After restarting dbvis it worked like before (which is good).

Ronald.

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available npe
Ronald, What OS and look and feel? Did you open the Bookmarks menu in the main window or in the bookmarks editor? Did it appear directly when the menu appear or when you selected an entry?Does the bookmark you selected have a "Note" attached to it (specified in the bookmark editor). Lots of questions :-) Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available npe
Roger,

this was on XP with Alloy.
I tried to open the 'Get Bookmark' menu Item and before the menu with Personal, New and History folded out, the NPE came.
This was in order to get the bookmark into the sqlcommander, not in the bookmarks editor.

regards,
R.
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available npe
Ronald, Which Java version? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available npe
Product:  DbVisualizer Personal 5.1.1.7
Build:  #1200 (2007/05/07 22:43)
Java VM:  Java HotSpot(TM) Client VM
Java Version:  1.6.0_01-b06
Java Vendor:  Sun Microsystems Inc.
OS Name:  Windows XP
OS Arch:  x86
OS Version:  5.1

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available npe
Ronald, I have tried various tests now to repeat the NPE problem. Unfortunately I cannot make it happen. Is this repeatable on your side? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available npe
Roger,
it happens after a long period of time.
Currently I work a lot with tables having clobs (a few bytes up to 250KB length).
I almost constantly have about 3 db connections open and about 10 tabs in the sql commander.
My feeling is that is has to do with some memory leeking away. Before the NPE rises, dbvis is often VERY slow to respond on redraw requests that happen when switching a windows task. When I notice this I try to close dbvis in a normal way and after that it normally runs fine again.

regards,
R.
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available npe
Roger,
I let dbvis running when I left last night and when I came back this morning I saw that memory usage was increased. (I had the debugging window open, no further actions, no running monitor, just a few open connections, no activity that I know of).
The reading of the debug window was the last thing that succeeded, now a java error is trying to display. An 'Error Alert' is trying to popup but seems to be unable to finish drawing the screen. This is a popup that comes from the jre, if you ask me. 'Normally' this one comes first and next is dbvis showing the NPE in the debug window.
Is there a way to trace the activities of dbvis to a log file ? It should not trace the results of the queries, that would grow a bit too large but metrics like #rows and sizes would be ok to log.

R.
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available npe
Roger,
have you tried letting dbvis run for more than a day - idle - with just 1 database connection open ? When I do so, I can no longer get any response from dbvis and have to kill it. Last friday I opened 1 db connection, created 1 quick and good performing query (just a few numbers) in sqlcommander, executed it a few times and left. No I hit execute for that query again and I don't get any response.
Running XP here...

with kind regards,
R.
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available npe
Ronald, These observations are really great as one major task before publishing the final release is to do various optimizations. So we will look into this and other related things such as memory usage, etc. Thanks again. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available

Roger,

I just noticed that 5.1.1.7 was out, looked through the release notes and found:
"Add a lightweight filtering capability in the Data tab in addition to the where filter dialog".

Hurra! Thank you so much for bringing this back!

Best Regards,
Georg


[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available
Roger,

in 5.1.1.7 the comment still is not saved as I entered it. In order to be able to use hints in oracle ( start with /*+ ...) I explicitily enter the comment delimiter as '/* ' (note the space). When I restart dbvis I see that the space is gone again so it looks like the space is not saved or not read from the config file. The session in which I edit the propertie does handle hint well from that point on.

It would be very nice if this could be fixed.

thanks,
Ronald.
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available
Hi Ronald, The comment problem is on the todo and will be taken care of in the next version. Ragrds Roger
[This reply is migrated from our old forums. The original author name has been removed]

Error on Disconnect of DB Connections using icon in menu at top
An internal error occured:

Exception: java.lang.NullPointerException
java.lang.NullPointerException

The error may have affected the application state.
Please notify vendor.

Stack Trace:

java.lang.NullPointerException
    at com.onseven.dbvis.F.B.C.Ĉ(Unknown Source)
    at com.onseven.dbvis.F.B.C.execute(Unknown Source)
    at com.onseven.dbvis.F.B.F.run(Unknown Source)
    at com.onseven.dbvis.F.B.B.ă(Unknown Source)
    at com.onseven.dbvis.F.B.B.execute(Unknown Source)
    at com.onseven.dbvis.F.B.F.run(Unknown Source)
    at com.onseven.dbvis.sql.N.đ(Unknown Source)
    at com.onseven.dbvis.G.I.ā(Unknown Source)
    at com.onseven.dbvis.C.I$3.actionPerformed(Unknown Source)
    at javax.swing.JComboBox.fireActionEvent(Unknown Source)
    at javax.swing.JComboBox.setSelectedItem(Unknown Source)
    at com.onseven.dbvis.G.K.setSelectedItem(Unknown Source)
    at com.onseven.dbvis.G.K.ā(Unknown Source)
    at com.onseven.dbvis.G.K.ı(Unknown Source)
    at com.onseven.dbvis.G.K.sessionEvent(Unknown Source)
    at com.onseven.dbvis.V.K.ā(Unknown Source)
    at com.onseven.dbvis.V.M.ā(Unknown Source)
    at com.onseven.dbvis.V.K.Ą(Unknown Source)
    at com.onseven.dbvis.sql.N$A.finished(Unknown Source)
    at se.pureit.util.ThreadCommand$2.run(ThreadCommand.java:154)
    at java.awt.event.InvocationEvent.dispatch(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

Windows XP
Java 1.6.0_01-b06
Large Icon sizes
Alloy
[This reply is migrated from our old forums.]

Re: Error on Disconnect of DB Connections using icon in menu at top
Hi, Thanks for your report. This will be fixed in the next version. Regards Roger