Start a new topic

DbVisualizer 5.1.1.8 now available

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

Hi, DbVisualizer 5.1.1.8 (early access) is now available: 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.8 now available
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.

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available
Ronald, Is DbVisualizer installed on a network drive that is temporarily unavailable? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.8 now available
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.
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available
Ronald, This situation isn't gracefully handled currently since it is a major inconsistency whereas some pieces of the application cannot be loaded (because of environment problems). I think we can handle this specific situation better by telling a serious problem occurred and then let the user press an "Exit" button to leave DbVis. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.8 now available

I just wanted to take a look at the properties of an DB2 8.2 Stored Procedure but several fields show only errors. Originally I wanted to see the code of the procedure.

TEXT

An internal error occured:

Exception: java.lang.ClassCastException
java.lang.ClassCastException: com.onseven.dbvis.sql.TextData

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

Stack Trace:

java.lang.ClassCastException: com.onseven.dbvis.sql.TextData
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.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.pumpOneEventForHierarchy(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)


PROCEDURE_ID:

An internal error occured:

Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.lang.Long

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

Stack Trace:

java.lang.ClassCastException: java.lang.Long
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.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.pumpOneEventForHierarchy(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)

PARM_COUNT:

An internal error occured:

Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.lang.Integer

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

Stack Trace:

java.lang.ClassCastException: java.lang.Integer
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.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.pumpOneEventForHierarchy(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)

PARM_SIGNATURE:

An internal error occured:

Exception: java.lang.ClassCastException
java.lang.ClassCastException: com.onseven.dbvis.sql.BinaryData

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

Stack Trace:

java.lang.ClassCastException: com.onseven.dbvis.sql.BinaryData
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.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.pumpOneEventForHierarchy(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)

CREATE_TIME:

An internal error occured:

Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.sql.Timestamp

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

Stack Trace:

java.lang.ClassCastException: java.sql.Timestamp
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.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.pumpOneEventForHierarchy(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)

RESULT_SETS:

An internal error occured:

Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.lang.Integer

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

Stack Trace:

java.lang.ClassCastException: java.lang.Integer
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.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.pumpOneEventForHierarchy(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)

TEXT_BODY_OFFSET:

An internal error occured:

Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.lang.Long

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

Stack Trace:

java.lang.ClassCastException: java.lang.Long
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.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.pumpOneEventForHierarchy(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 reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available
Peter, Embarrassing bug... it will be fixed. Workaround is to double click the cell in the "Procedures" grid to see for example Text. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.8 now available
Hi there,

here's a new bug I'm experiencing with Informix and DBVis, tested in 5.1 and 5.1.1.8

When I try to access the DDL of a table (as well as for "create table") with two secondary keys as a primary key, I get the following output:

5.1.1.8
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.R.A.D.c(Unknown Source)
    at com.onseven.dbvis.R.A.D.a(Unknown Source)
    at com.onseven.dbvis.a.G.B.F.a(Unknown Source)
    at com.onseven.dbvis.a.B.A.B$A.execute(Unknown Source)
    at com.onseven.dbvis.F.B.H.construct(Unknown Source)
    at se.pureit.swing.util.SwingWorker$2.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)


5.1.1
14:05:28 [ERROR] IndexOutOfBoundsException: row=0 column=0 rowCount=0 columnCount=18
Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException
    at com.onseven.dbvis.Q.A.D.?(Unknown Source)
    at com.onseven.dbvis.Q.A.D.?(Unknown Source)
    at com.onseven.dbvis.Z.G.B.F.?(Unknown Source)
    at com.onseven.dbvis.Z.B.A.B.?(Unknown Source)
    at com.onseven.dbvis.Z.B.E.?(Unknown Source)
    at com.onseven.dbvis.Z.B.E.?(Unknown Source)
    at com.onseven.dbvis.Z.B.E.access$100(Unknown Source)
    at com.onseven.dbvis.Z.B.E$1.ancestorAdded(Unknown Source)
    at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source)
    at javax.swing.AncestorNotifier.componentShown(Unknown Source)
    at java.awt.Component.processComponentEvent(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.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.H.A.d.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(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)


---------------
Here's the original 'create table' script:

CREATE TABLE map_server_dienste
(
   id_server int,
   id_dienste int,
   CONSTRAINT map_server_dienste_PK PRIMARY KEY (id_server,id_dienste)
);

ALTER TABLE map_server_dienste
ADD CONSTRAINT foreign2
FOREIGN KEY (id_dienste)
REFERENCES dienste(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE map_server_dienste
ADD CONSTRAINT foreign1
FOREIGN KEY (id_server)
REFERENCES server(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX 104_10 ON map_server_dienste(id_dienste);
CREATE INDEX 104_9 ON map_server_dienste(id_server);

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available
Hi Dirk, I'm looking into the Informix DDL problem you reported. I cannot reproduce the exact same thing with: Informix Dynamic Server 10.00.UC6TL IBM Informix JDBC Driver for IBM Informix Dynamic Server 3.00.JC3 Are you using a different Informix and/or JDBC driver version? Also, the CREATE and ALTER statements you included do not seem to be using Informix syntax for the constraint name (the CONSTRAINT keyword and the name must come after the declaration, e.g., after PRIMARY KEY ...) and the index names are not valid identifiers. Are these statement generated with some other tool, or is there some Informix option for accepting ANSI syntax that I'm not aware of? I did, however, find some regression errors in this area that _may_ be the cause of the problem you see. Please let me know the version numbers so I can try to verify that fixing these errors also fixes the problem you encountered. Thanks, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.8 now available
Hi Hans,
I suppose, I was a little lazy there ;)
The output I posted was actually generated by Squirrel. Here's the output from dbschema from the unix machine.

Informix Dynamic Server
9.40.HC2
IBM Informix JDBC Driver for IBM Informix Dynamic Server
3.00.JC3

-------------------------------
DBSCHEMA Schema Utility       INFORMIX-SQL Version 9.40.HC2
Copyright (C) Informix Software, Inc., 1984-1997
Software Serial Number xxxxxxxxxxxxxxxxx

{ TABLE "informix".map_server_dienste row size = 8 number of columns = 2 index size  = 31 }
create table "informix".map_server_dienste
  (
    id_server integer not null ,
    id_dienste integer not null ,
    primary key (id_server,id_dienste)  constraint "informix".map
  );
revoke all on "informix".map_server_dienste from "public";



alter table "informix".map_server_dienste add constraint (foreign
    key (id_server) references "informix".server  constraint "informix"
    .foreign1);

alter table "informix".map_server_dienste add constraint (foreign
    key (id_dienste) references "informix".dienste  constraint
    "informix".foreign2);

-------------------------------

Thanks for your help
Dirk
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available
Hi Dirk, Thanks for the additional information. Hopefully my corrections to the problems I found in this area also fix the problem you ran into. We don't have access to Informix 9.40.HC, so I can't say for sure, but it seems likely based on the nature of the problems I found. Please test again when the next version is released. Thanks, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.8 now available
I suppose this is more a feature request than a bug.

I notice I can select several rows in the data tab, create an equal number of empty rows in a similar table on another server then paste the data from the first server into the empty rows on the second.

This works great when I need to quickly copy 10 rows of data but falls down when I try to copy 100 at a time. If I try to paste the 100 copied data rows into a single blank row, only 1 record is created.

Ideally, if I am pasting data into a newly-created empty row and there is more than one row of data to be pasted, it should create new empty rows to hold the remaining data to be copied.

This way, it would work more like MS Access (whose only valid use IMHO is for copying data between ODBC link tables using the windows clipboard) where you can paste several rows worth of clipboard data into an empty row and it will copy all the rows you pasted instead of just the first one.

Great effort with the last few EAP releases BTW - the way filtering and data editing works now is a wonderful improvement.
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available
Hi, We'll add a dialog in the next version asking what to do if there are more rows in the clipboard then selected rows in the grid. The options are: [b]Add Rows[/b] or [b]Don't Add Rows[/b]. This will then handle both the current scenario and the new one you describe. Thanks for your feedback. Regards Roger