How can we help you today?
DBVis 5.1 DDL Tab causes NPE
10 CommentsSorted by Oldest First
Roger Bjärevall
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: DBVis 5.1 DDL Tab causes NPE
Re: DBVis 5.1 DDL Tab causes NPE
Hi,
What database are you accessing and what driver are you using?
Regards
Roger
Hans Bergsten
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: DBVis 5.1 DDL Tab causes NPE
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
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. The original author name has been removed]
Re: DBVis 5.1 DDL Tab causes NPE
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
Roger Bjärevall
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: DBVis 5.1 DDL Tab causes NPE
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
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)
Roger Bjärevall
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: DBVis 5.1 DDL Tab causes NPE
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
[Attachment has been removed.]
Re: DBVis 5.1 DDL Tab causes NPE
Put into an attached xls file.
Roger Bjärevall
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: DBVis 5.1 DDL Tab causes NPE
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
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
anonymous