Start a new topic

DbVisualizer 5.1.1.9 now available

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

Hi, DbVisualizer 5.1.1.9 (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]
[Attachment has been removed.]

Re: DbVisualizer 5.1.1.9 now available
Great news! Thanks for this release, guys!

Anyway there are still 2 bugs in I've reported earlier: Users and Roles don't work for Informix 9.21 and 9.40.

@Hans
Unfortunately I'm still having trouble with this table with two secondary keys as a primary key.

Thanks again!
Dirk
--------------------------------------------------
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.č(Unknown Source)
    at com.onseven.dbvis.R.A.D.ā(Unknown Source)
    at com.onseven.dbvis.a.F.B.F.ā(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
--------------------------------------------------



[This reply is migrated from our old forums.]
[Attachment has been removed.]

Re: DbVisualizer 5.1.1.9 now available
Dirk, Sorry I simply forgot the Users/Roles issue. Attached you'll find an updated database profile for Informix. Save it as [b]DBVIS-HOME/resources/profiles/informix.xml[/b] (replace the existing informix.xml file). Let me know if it works better. We'll look into the NullPointerException problem. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.9 now available
Users/Roles seems to work with this xml (no exception anymore on Informix 9.41 with JDBC 3.00 and correct display of default_role on IDS 10) And THANK YOU VERY MUCH!! for bringing back the "old" (theme aware) Windows style :-) :-) Bye Peter
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Hi Dirk, Sorry the fixes for other problems didn't fix the problem you have found for the table with two foreign keys. Can you please set the debug log level to "Debug" and detail to "Full" in Tool Properties just before you click on the DDL tab for the table gives the error ,and post the resulting debug output here? Thanks, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.9 now available
I am getting this exception when choosing Alter table when right clicking on a table..:

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.a.F.B.E$A.<init>(Unknown Source)
    at com.onseven.dbvis.a.F.B.E.Ą(Unknown Source)
    at com.onseven.dbvis.a.F.C.Č(Unknown Source)
    at com.onseven.dbvis.a.F.C.ā(Unknown Source)
    at com.onseven.dbvis.a.F.B.E.ā(Unknown Source)
    at com.onseven.dbvis.a.F.A.ā(Unknown Source)
    at com.onseven.dbvis.a.F.D.execute(Unknown Source)
    at se.pureit.swing.util.PureAction.actionPerformed(Unknown Source)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
    at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
    at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1216)
    at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1257)
    at java.awt.Component.processMouseEvent(Component.java:6038)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
    at java.awt.Component.processEvent(Component.java:5803)
    at java.awt.Container.processEvent(Container.java:2058)
    at java.awt.Component.dispatchEventImpl(Component.java:4410)
    at java.awt.Container.dispatchEventImpl(Container.java:2116)
    at java.awt.Component.dispatchEvent(Component.java:4240)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
    at java.awt.Container.dispatchEventImpl(Container.java:2102)
    at java.awt.Window.dispatchEventImpl(Window.java:2429)
    at java.awt.Component.dispatchEvent(Component.java:4240)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)



BTJ
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Bjørn, What database are you using? If possible, can you post/email the DDL for the actual table? Regards Roger support@minq.se
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.9 now available
We are using DB2 for IBM AS/400..

But I don't get any DDL from DbVisualizer, I only get this error message when choosing the DDL tab..:

An error occured while performing the operation:
[SQL0204] TABLES in SYSCAT type *FILE not found.


Let me know if you need more info....


BTJ
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Bjørn, DDL generation for DB2 on AS/400 is not supported. Using the DB2 profile in DbVisualizer to access an AS/400 DB2 database is nothing I recommend as it is developed for DB2 running on UNIX/Windows. The DB2 z/OS profile is for DB2 running on mainframes. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.9 now available
Oki, I switched to DB2 z/OS and then the alter table feature disappeared so I guess the problem is solved.... :)

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

Re: DbVisualizer 5.1.1.9 now available
But I discovered a "bug/feature"...
If I enable to only show default database/schema, DbVis still shows all the schemas...

Is this a know feature or?


BTJ
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
DB2 AS/400? Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.9 now available
This is when using DB2 z/OS and enabling only defaul schema yes....

BTJ
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Bjørn, Is the exception you reported a couple of days ago also a result of opening the Alter Table feature with DB2 on AS/400? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.9 now available
Yes, the exception happend when choosing Alter table using DB2 against DB2 AS/400 mainframe... When choosing the correct type, z/OS, the Alter table feature is not available anymore...

BTJ