DbVisualizer 5.1.1.8 now available

on german WinXP, SP2, DBVis 5.1.1.8 does not accept 5.1 licenses... (says "The license key doesn't allow use") and writes dbvis.log with content "File icons/title_buttons_metal.gif not found". Bye, Peter

With version 5.1.1.8 and 5.1.1.7 I cannot see any package bodies:

An error occured while executing the database request for:
Oracle
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
Oracle JDBC driver
10.2.0.2.0

Short message:
3 >= 3

The command that caused the problem:
Could not read FIS_WSE

Details:
   Type: java.lang.ArrayIndexOutOfBoundsException

Message:
3 >= 3

System Information:
Product: DbVisualizer Personal 5.1.1.8
Build: #1205 (2007/05/28 10:01)
Java VM: Java HotSpot(TM) Server VM
Java Version: 1.6.0-rc-b104
Java Vendor: Sun Microsystems Inc.
OS Name: Windows XP
OS Arch: x86
OS Version: 5.1

What might be causing this?

Thanks,

Benny

Hi Roger,

I have tried this with two databases, Oracle 9i and Oracle 10g, and I think it was using the sys account.

The error occurred with DBVisualizer 5.1.1.8 and 5.1.1.7.

I will do some more testing tomorrow and will provide you with more details.

Regards,

Benny

Hi Roger,

here's a bug with Informix 9.40 and 9.21
When I try to alter a table which has a DateTime Column, I get the following debug output:

Unknown data type found: DATETIME YEAR TO SECOND

also is the "data type" column empty in the following window.

Greets
Dirk

Hi Roger,

I had another look at the issue with respect to the pl/sql code.

It looks like I can't view the sources of package bodies in Oracle databases on linux. It doesn't matter what database version I am connected to (I tested with Oracle 9i, Oracle 10g). The other source (package specs, functions, procedures) are no problem.
For our Windows based databases I can see all sources. I only have Oracle 8i and Oracle 9i on Windows.

regards,

Benny

Hi Benny,

I just tested with oracle 9i on Solaris, 10gR2 on Solaris and linux and I was able to see all sources. What accounts/privileges do you use in the databases that fail to show you their package bodies ?

regards,
Ronald
http://ronr.nl/unix-dba

When I [re] open a connection
I sometimes get:
java.util.zip.ZipException: error reading zip file

No idea what it means.
R.

After opening a connection and pointing on tablespaces overview in the object tree:

java.util.zip.ZipException: error reading zip file
16:53:08 [ERROR] ERROR loading: /dbvis-actions.xml
16:53:08 [ERROR] Exception is: java.lang.NullPointerException
java.lang.NullPointerException
    at se.pureit.swing.xmlactions.xml.ActionParser.loadActions(Unknown Source)
    at se.pureit.swing.xmlactions.xml.ActionParser.getActionParser(Unknown Source)
    at se.pureit.swing.xmlactions.ActionManager.loadActions(Unknown Source)
    at com.onseven.dbvis.DbVisualizer.Š(Unknown Source)
    at com.onseven.dbvis._.f.<init>(Unknown Source)
    at com.onseven.dbvis._.RA.<init>(Unknown Source)
    at com.onseven.dbvis._.RA.<init>(Unknown Source)
    at com.onseven.dbvis._.a.?(Unknown Source)
    at com.onseven.dbvis._.DA.?(Unknown Source)
    at com.onseven.dbvis._.DA.<init>(Unknown Source)
    at com.onseven.dbvis._.a.<init>(Unknown Source)
    at com.onseven.dbvis.a.B.A.I$2.<init>(Unknown Source)
    at com.onseven.dbvis.a.B.A.I.?(Unknown Source)
    at com.onseven.dbvis.a.B.A.I.?(Unknown Source)
    at com.onseven.dbvis.a.B.E.?(Unknown Source)
    at com.onseven.dbvis.a.B.E.?(Unknown Source)
    at com.onseven.dbvis.a.B.A.?(Unknown Source)
    at com.onseven.dbvis.a.B.H.?(Unknown Source)
    at com.onseven.dbvis.a.B.H.?(Unknown Source)
    at com.onseven.dbvis.a.B.H.?(Unknown Source)
    at com.onseven.dbvis.a.B.K.?(Unknown Source)
    at com.onseven.dbvis.a.B.K.?(Unknown Source)
    at com.onseven.dbvis.a.A.C.?(Unknown Source)
    at com.onseven.dbvis.a.A.C.stateChanged(Unknown Source)
    at javax.swing.JTabbedPane.fireStateChanged(Unknown Source)
    at javax.swing.JTabbedPane$ModelListener.stateChanged(Unknown Source)
    at javax.swing.DefaultSingleSelectionModel.fireStateChanged(Unknown Source)
    at javax.swing.DefaultSingleSelectionModel.setSelectedIndex(Unknown Source)
    at javax.swing.JTabbedPane.setSelectedIndexImpl(Unknown Source)
    at javax.swing.JTabbedPane.setSelectedIndex(Unknown Source)
    at javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.mousePressed(Unknown Source)
    at javax.swing.plaf.basic.BasicTabbedPaneUI$MouseHandler.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(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)
ActionManager.addActionCommand(): Error - Action: reload-command undefined.
ActionManager.addActionCommand(): Error - Action: stop-command undefined.
ActionManager.addActionCommand(): Error - Action: fit-all-columns-with-header-command undefined.
ActionManager.addActionCommand(): Error - Action: fit-all-columns-without-header-command undefined.
ActionManager.addActionCommand(): Error - Action: fit-column-with-header-command undefined.
ActionManager.addActionCommand(): Error - Action: fit-column-without-header-command undefined.
ActionManager.addActionCommand(): Error - Action: default-column-widths-command undefined.
ActionManager.addActionCommand(): Error - Action: sort-column-asc-command undefined.
ActionManager.addActionCommand(): Error - Action: sort-column-desc-command undefined.
ActionManager.addActionCommand(): Error - Action: select-column-command undefined.
ActionManager.addActionCommand(): Error - Action: remove-column-command undefined.
ActionManager.addActionCommand(): Error - Action: copy-column-label-command undefined.
ActionManager.addActionCommand(): Error - Action: select-all-cells-command undefined.
ActionManager.addActionCommand(): Error - Action: select-row-command undefined.
ActionManager.addActionCommand(): Error - Action: copy-selected-cells-command undefined.
ActionManager.addActionCommand(): Error - Action: copy-selected-cells-with-header-command undefined.
ActionManager.addActionCommand(): Error - Action: export-command undefined.
ActionManager.addActionCommand(): Error - Action: export-selection-command undefined.
ActionManager.addActionCommand(): Error - Action: print-command undefined.
ActionManager.addActionCommand(): Error - Action: print-selection-command undefined.
ActionManager.addActionCommand(): Error - Action: print-preview-command undefined.
ActionManager.addActionCommand(): Error - Action: find-command undefined.
ActionManager.addActionCommand(): Error - Action: show-row-in-form-command undefined.
ActionManager.addActionCommand(): Error - Action: show-cell-in-form-command undefined.
ActionManager.addActionCommand(): Error - Action: show-meta-in-frame-command undefined.
ActionManager.addActionCommand(): Error - Action: calculate-selection-command undefined.
ActionManager.addActionCommand(): Error - Action: save-selected-cell-command undefined.

From now on this keeps popping up when I click on any subtree in the object tree. I think the root cause is a network failure but the code should handle such an interruption and mark the connection as closed.

R.

Hee, yes, I think I also lost that one ....(sofar was only thinking about lost database connections). dbvis really is a dead piece of meat in memory. I was able to 'close' all connections but a normal 'quit' was no longer possible.

R.

Hi Dirk, Thanks for reporting the problem with Alter Table for an Informix table containing DATETIME columns (the same problem exists for INTERVAL columns). This will be fixed in the next release, along with a fix for another problem I found while looking into this: the size/reserved numbers for a non-nullable VARCHAR column, when declared as "VARCHAR(size, reserved)", is invalid in Alter Table. Thanks, Hans

Hi Ronald,

In most cases I was logged in under sys, in other cases as schema owner.

Regards,

Benny