This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 141995 - NetBeans DataView: Error while querying table
Summary: NetBeans DataView: Error while querying table
Status: CLOSED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: _ ahimanikya
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-29 08:02 UTC by Manish Bharani
Modified: 2008-07-30 13:06 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Manish Bharani 2008-07-29 08:02:21 UTC 
I was trying out data view editor in the NetBeans 6.5. Here is a point I stumbled.
A customer table in one of my oracle schemas has a following column data types that are probably not mapped in
DataViewUtils.

oracle.sql.struct [jdbc type 2002 ??]
oracle.sql.array
Query on this table fails with NPE (dump pasted below).

Netbeans 6.1 data viewer did not have this problem and these columns are tagged as "OTHERS" in the column properties.

Just thought would report this to you.
Otherwise, the utility works great !

You can access my database from jdbc:oracle:thin:@129.158.238.222:1521:orcl [user : oe, pw : oe]

java.lang.NullPointerException
   at org.netbeans.modules.db.dataview.util.DataViewUtils.getColumnToolTip(DataViewUtils.java:235)
   at org.netbeans.modules.db.dataview.output.DataViewDBTable.getColumnToolTips(DataViewDBTable.java:124)
   at org.netbeans.modules.db.dataview.output.DataViewTablePanel.<init>(DataViewTablePanel.java:89)
   at org.netbeans.modules.db.dataview.output.DataViewUI.<init>(DataViewUI.java:146)
   at org.netbeans.modules.db.dataview.output.DataView.createComponents(DataView.java:131)
   at org.netbeans.modules.db.dataview.api.DataView.createComponents(DataView.java:88)
   at org.netbeans.modules.db.sql.loader.SQLEditorSupport$2.run(SQLEditorSupport.java:330)
   at org.netbeans.modules.db.sql.loader.SQLEditorSupport$2.run(SQLEditorSupport.java:322)
   at org.openide.util.Mutex$1AWTWorker.run(Mutex.java:1370)
[catch] at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:199)
   at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
   at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
   at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
   at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Comment 1 _ ahimanikya 2008-07-29 10:55:01 UTC 
http://hg.netbeans.org/main/rev/2c4dfd1cf755
Comment 2 Roman Mostyka 2008-07-29 16:43:57 UTC 
I can't connect to the pointed Oracle server. bharanim, please verify the fix and mark issue appropriately.
Comment 3 Manish Bharani 2008-07-30 13:06:53 UTC 
The issue was verified with the same database and found to be fixed.
Thanks,
Manish
x40024