Start a new topic

DBVis 5.1 DDL Tab causes NPE

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

Whenever selecting a table then clicking on DDL under Object View I get this error are there any solutions? Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException at com.onseven.dbvis.Q.A.B.?(Unknown Source) at com.onseven.dbvis.Q.A.B.?(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)

[This reply is migrated from our old forums.]

Re: DBVis 5.1 DDL Tab causes NPE
Hi, What database are you accessing and what driver are you using? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DBVis 5.1 DDL Tab causes NPE
MySQL 5.0.24a Driver mysql connector 5.0.3 More Info: I also tried the zip and windows installer versions, if that is any help. Previously I've always used the zip versions and I've been using the EA versions. I've tried to move the .dbvis folder and recreate it on start of DBVis but that also had no effect. Message was edited by: gcstang
[This reply is migrated from our old forums.]

Re: DBVis 5.1 DDL Tab causes NPE
It would also be very helpful if you can post the actual CREATE TABLE statement for the table. If you don't know how the table was created, please run SHOW CREATE TABLE in the SQL Commander, assuming you're using MySQL. If you use a different database, some of them provide similar commands for getting the CREATE TABLE statement.
[This reply is migrated from our old forums. The original author name has been removed]

Re: DBVis 5.1 DDL Tab causes NPE
it happens on all tables however I'll include an example here: CREATE TABLE `wbevtlnk` ( `evtid` decimal(11,0) NOT NULL, `lnktyp` decimal(9,0) NOT NULL, `seq` decimal(9,0) NOT NULL default '0', `dsp` decimal(1,0) NOT NULL, `link` text, `lnkdsc` varchar(128) default NULL, `dspseq` decimal(9,0) NOT NULL default '0', `lnkpty` decimal(9,0) NOT NULL, `imgnam` varchar(128) NOT NULL, `imghgt` decimal(5,0) NOT NULL default '0', `imgwid` decimal(5,0) NOT NULL default '0', `imgtyp` decimal(9,0) NOT NULL, `lnkdatatyp` decimal(9,0) NOT NULL, `lnkldsc` text, `lnkdat` date default NULL, `rendid` decimal(9,0) NOT NULL, `extcod` varchar(50) default NULL, `effdat` date default NULL, `expdat` date default NULL, `xmlid` decimal(9,0) NOT NULL, PRIMARY KEY (`evtid`,`lnktyp`,`seq`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
[This reply is migrated from our old forums.]

Re: DBVis 5.1 DDL Tab causes NPE
Hi, Can you please enable debug as described in: http://www.minq.se/products/dbvis/faq.html#6.11 Post or email the debug output. Regards Roger support@minq.se
[This reply is migrated from our old forums. The original author name has been removed]

Re: DBVis 5.1 DDL Tab causes NPE
15:35:40 [DEBUG AWT-EventQueue-1 T.?] Column name: Type not found in model 15:35:40 [DEBUG AWT-EventQueue-1 T.?] Column name: Null not found in model Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException at com.onseven.dbvis.Q.A.B.?(Unknown Source) at com.onseven.dbvis.Q.A.B.?(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)
[This reply is migrated from our old forums.]

Re: DBVis 5.1 DDL Tab causes NPE
Hi, Thanks! Try the following in the SQL Commander: [b]SHOW FULL COLUMNS FROM `wbevtlnk`[/b] What is the result? Make sure the current database is the one having the above table in it. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: DBVis 5.1 DDL Tab causes NPE
Put into an attached xls file.
[This reply is migrated from our old forums.]

Re: DBVis 5.1 DDL Tab causes NPE
Hi, Thanks! You must use the latest 3.1.13 driver as the 5.0 driver is still in development at MySQL. http://dev.mysql.com/downloads/connector/j/3.1.html We will add support for Connector/J 5.0 in a coming version. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DBVis 5.1 DDL Tab causes NPE
I tried the 3.1.13 release and it worked. Thank you for all your help, I also tried the nightly release of 5.0 and it seems to work also must be an issue in the 5.0.3 release. Message was edited by: gcstang