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 62622 - New Db Explorer and Oracle: IllegalArgException on date columns
Summary: New Db Explorer and Oracle: IllegalArgException on date columns
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 5.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
: 62881 64351 (view as bug list)
Depends on:
Blocks:
 
Reported: 2005-08-18 20:07 UTC by giorgio42
Modified: 2005-11-21 10:40 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description giorgio42 2005-08-18 20:07:57 UTC
Hi,

I really like the ongoing improvements in the database explorer in daily build
200508161800.

Using ojdbc14.jar (newest thin client driver from Oracle10g) and Oracle 8i I get
an IAE when the table renders date columns (see below). 

The exception should not cause a modal dialog box to appear because the user has
to click OK at least 200 times before the IDE is usable again. Errors that occur
while iterating over a resultset should go to the output window only.

Other observations:
With MySQL (testing 5.1.10 with connector/j 3.1.10) the exception does not
occur. However no views are displayed (using DbVisualizer 4.3.1 from www.minq.se
as a reference, with identical configuration).

Here's the exception:
java.lang.IllegalArgumentException: Cannot format given Object as a Date
	at java.text.DateFormat.format(DateFormat.java:279)
	at java.text.Format.format(Format.java:133)
	at javax.swing.JTable$DateRenderer.setValue(JTable.java:3575)
	at
javax.swing.table.DefaultTableCellRenderer.getTableCellRendererComponent(DefaultTableCellRenderer.java:181)
	at javax.swing.JTable.prepareRenderer(JTable.java:3919)
	at javax.swing.plaf.basic.BasicTableUI.paintCell(BasicTableUI.java:1669)
	at javax.swing.plaf.basic.BasicTableUI.paintCells(BasicTableUI.java:1571)
	at javax.swing.plaf.basic.BasicTableUI.paint(BasicTableUI.java:1494)
	at javax.swing.plaf.ComponentUI.update(ComponentUI.java:142)
	at javax.swing.JComponent.paintComponent(JComponent.java:742)
	at javax.swing.JComponent.paint(JComponent.java:1005)
	at javax.swing.JComponent.paintChildren(JComponent.java:842)
	at javax.swing.JComponent.paint(JComponent.java:1014)
	at javax.swing.JViewport.paint(JViewport.java:728)
	at javax.swing.JComponent.paintChildren(JComponent.java:842)
	at javax.swing.JComponent.paint(JComponent.java:1014)
	at javax.swing.JComponent.paintWithOffscreenBuffer(JComponent.java:4963)
	at javax.swing.JComponent.paintDoubleBuffered(JComponent.java:4916)
	at javax.swing.JComponent._paintImmediately(JComponent.java:4859)
	at javax.swing.JComponent.paintImmediately(JComponent.java:4666)
	at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:451)
[catch] at
javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:114)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
	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)

Keep it coming :-)
Cheers,
Georg
Comment 1 Andrei Badea 2005-08-23 15:36:56 UTC
Thank you for the positive feedback. We will look at the bug.
Comment 2 Martin Schovanek 2005-09-06 13:46:48 UTC
It's caused by null values in a date column.
Comment 3 Andrei Badea 2005-09-06 14:11:51 UTC
*** Issue 62881 has been marked as a duplicate of this issue. ***
Comment 4 Andrei Badea 2005-09-13 14:47:33 UTC
Fixed.

Checking in src/org/netbeans/modules/db/sql/execute/ResultSetTableModelSupport.java;
/cvs/db/core/src/org/netbeans/modules/db/sql/execute/ResultSetTableModelSupport.java,v
 <--  ResultSetTableModelSupport.java
new revision: 1.4; previous revision: 1.3
done
Checking in src/org/netbeans/modules/db/sql/execute/ui/SQLResultPanel.form;
/cvs/db/core/src/org/netbeans/modules/db/sql/execute/ui/SQLResultPanel.form,v 
<--  SQLResultPanel.form
new revision: 1.3; previous revision: 1.2
done
Checking in src/org/netbeans/modules/db/sql/execute/ui/SQLResultPanel.java;
/cvs/db/core/src/org/netbeans/modules/db/sql/execute/ui/SQLResultPanel.java,v 
<--  SQLResultPanel.java
new revision: 1.3; previous revision: 1.2
done
Comment 5 Andrei Badea 2005-09-14 15:51:14 UTC
*** Issue 64351 has been marked as a duplicate of this issue. ***
Comment 6 Martin Schovanek 2005-11-21 10:40:18 UTC
VERIFIED