Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - BETA versions

Thread: DbVisualizer 5.1.1.9 now available


Permlink Replies: 45 - Pages: 4 [ 1 2 3 4 | Next ] - Last Post: Jun 29, 2007 11:45 AM Last Post By: Roger Bjarevall
Roger Bjarevall


Posts: 5,069
Registered: 12/17/04
DbVisualizer 5.1.1.9 now available
Posted: Jun 13, 2007 1:12 AM
   thread.click_reply Reply
Hi,

DbVisualizer 5.1.1.9 (early access) is now available:

http://www.minq.se/products/dbvis/eap

Best Regards

Roger
dirk

Posts: 18
Registered: 05/31/07
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 13, 2007 8:52 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply
 global.attachment ifx-users-940.log (867 bytes )
 global.attachment ifx-users-921.log (867 bytes )
 global.attachment ifx-roles-940.log (867 bytes )
 global.attachment ifx-roles-921.log (867 bytes )
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
--------------------------------------------------



Bjørn T Johansen

Posts: 61
Registered: 03/22/06
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 13, 2007 9:03 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply
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
Roger Bjarevall


Posts: 5,069
Registered: 12/17/04
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 13, 2007 9:22 AM    global.in_response_to.tooltip in response to: dirk
   thread.click_reply Reply
 global.attachment informix.xml (61.3 KB )
Dirk,

Sorry I simply forgot the Users/Roles issue. Attached you'll find an updated database profile for Informix. Save it as DBVIS-HOME/resources/profiles/informix.xml (replace the existing informix.xml file).

Let me know if it works better.

We'll look into the NullPointerException problem.

Regards

Roger
Roger Bjarevall


Posts: 5,069
Registered: 12/17/04
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 13, 2007 9:25 AM    global.in_response_to.tooltip in response to: Bjørn T Johansen
   thread.click_reply Reply
Bjørn,

What database are you using?

If possible, can you post/email the DDL for the actual table?

Regards

Roger
support@minq.se
Peter Nagel

Posts: 36
Registered: 02/17/06
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 13, 2007 9:57 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply
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
Ronald Rood

Posts: 559
Registered: 10/12/05
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 13, 2007 5:08 PM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply
Roger,
I miss the dbvis.vmoptions file. Is the way to increase the memory changed ? When I load the lang.sql file I see a cpu going crazy and I assume that when I give it a little more memory to play with it will behave better.

regards,
Ronald.
Frank Mang

Posts: 12
Registered: 11/29/05
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 13, 2007 5:13 PM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply
Hi Roger,

it seems, that the commit/rollback icons and menu items always are disabled.
I've set "Auto Commit" at Tool and Connect-Properties to false.

Thanks for your great work.

Regards
Frank
Ronald Rood

Posts: 559
Registered: 10/12/05
Re: DbVisualizer 5.1.1.9 now available - undo format long sql
Posted: Jun 13, 2007 5:18 PM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply
Hi Roger,

I just tried to format the long sql and it worked and pretty fast too. Given the length of the text I can imagine it is a problem to undo this
 but in that case I expect undo to give a warning or that it is disabled. What dbvis does now is delete words from the sql from the end.

that is not what one expects from an undo operation. Redo undoes the delete operation so that is ok.

R.
Hans Bergsten


Posts: 1,558
Registered: 10/11/06
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 13, 2007 6:29 PM    global.in_response_to.tooltip in response to: dirk
   thread.click_reply Reply
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
Roger Bjarevall


Posts: 5,069
Registered: 12/17/04
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 14, 2007 10:19 AM    global.in_response_to.tooltip in response to: Frank Mang
   thread.click_reply Reply
Frank,

We'll look into the commit/rollback problem.

Thanks for your post.

Regards

Roger
Roger Bjarevall


Posts: 5,069
Registered: 12/17/04
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 14, 2007 11:06 PM    global.in_response_to.tooltip in response to: Ronald Rood
   thread.click_reply Reply
Ronald,

You just need to create the dbvis.vmoptions file and put the options in it. It is not created with the .zip variant of the installer.

Regards

Roger
Bjørn T Johansen

Posts: 61
Registered: 03/22/06
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 15, 2007 1:15 PM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply
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
Roger Bjarevall


Posts: 5,069
Registered: 12/17/04
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 15, 2007 1:30 PM    global.in_response_to.tooltip in response to: Bjørn T Johansen
   thread.click_reply Reply
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
mark lawford

Posts: 77
Registered: 08/23/05
Re: DbVisualizer 5.1.1.9 now available
Posted: Jun 15, 2007 1:49 PM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply


I stumbled across the following error (included below) while using the navigator feature.

It looks like the query DBVis uses isn't correct for the field data type.

As it's a "char for bit data" field the value should be enclosed as follows:

x'20021006123949311084000000'

NOT simply

'20021006123949311084000000'

The x is all important. This is pretty consisten and this happens across all char for bit data fields I've tried through the navigator.


An error occured while executing the database request for:
DB2/6000
SQL08023
IBM DB2 JDBC Universal Driver Architecture
2.8.46

Short message:
Illegal Conversion

The command that caused the problem:
select * from SCHEMA.TABLE where FIELD = '20021006123949311084000000'

Long Message:
Illegal Conversion

Details:
   Type: com.ibm.db2.jcc.a.SqlException
   Error Code: -99999
   SQL State: null

System Information:
Product: DbVisualizer Personal 5.1.1.9
Build: #1224 (2007/06/13 00:44)
Java VM: Java HotSpot(TM) Tiered VM
Java Version: 1.7.0-ea-b12
Java Vendor: Sun Microsystems Inc.
OS Name: Windows 2000
OS Arch: x86
OS Version: 5.0


Point your RSS reader here for a feed of the latest messages in all forums