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 134108 - Upgrade bundled MySQL Connector/J to lastest version
Summary: Upgrade bundled MySQL Connector/J to lastest version
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: PC Windows Vista
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-04-28 22:31 UTC by spac
Modified: 2008-08-08 04:31 UTC (History)
0 users

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 spac 2008-04-28 22:31:30 UTC 
After migration to NB 6.1 I clear my project and compile it again. So after first run i get tons of exceptions while
getting Date object from RowSet. In NB 6.0.1 this worked fine so what is wrong?

---
java.sql.SQLException: Bad format for DATE '2008-01-02' in column 7.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetRow.getDateFast(ResultSetRow.java:290)
        at com.mysql.jdbc.ByteArrayRow.getDateFast(ByteArrayRow.java:235)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2108)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2060)
        at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4877)
        at com.sun.rowset.JdbcRowSetImpl.getObject(JdbcRowSetImpl.java:1632)
        at net.podzimek.petr.ui.tableModel.RowSetTableModel.getValueAt(RowSetTableModel.java:65)
        at javax.swing.JTable.getValueAt(JTable.java:2639)
        at javax.swing.JTable.prepareRenderer(JTable.java:5653)
        at javax.swing.plaf.basic.BasicTableUI.paintCell(BasicTableUI.java:2072)
        at javax.swing.plaf.basic.BasicTableUI.paintCells(BasicTableUI.java:1974)
        at javax.swing.plaf.basic.BasicTableUI.paint(BasicTableUI.java:1770)
        at javax.swing.plaf.ComponentUI.update(ComponentUI.java:143)
        at javax.swing.JComponent.paintComponent(JComponent.java:763)
        at javax.swing.JComponent.paint(JComponent.java:1027)
        at javax.swing.JComponent.paintChildren(JComponent.java:864)
        at javax.swing.JComponent.paint(JComponent.java:1036)
        at javax.swing.JViewport.paint(JViewport.java:747)
        at javax.swing.JComponent.paintChildren(JComponent.java:864)
        at javax.swing.JComponent.paint(JComponent.java:1036)
        at javax.swing.JComponent.paintChildren(JComponent.java:864)
        at javax.swing.JComponent.paint(JComponent.java:1036)
        at javax.swing.JComponent.paintChildren(JComponent.java:864)
        at javax.swing.JComponent.paint(JComponent.java:1036)
        at javax.swing.JLayeredPane.paint(JLayeredPane.java:564)
        at javax.swing.JComponent.paintChildren(JComponent.java:864)
        at javax.swing.JComponent.paintToOffscreen(JComponent.java:5129)
        at javax.swing.BufferStrategyPaintManager.paint(BufferStrategyPaintManager.java:285)
        at javax.swing.RepaintManager.paint(RepaintManager.java:1128)
        at javax.swing.JComponent.paint(JComponent.java:1013)
        at java.awt.GraphicsCallback$PaintCallback.run(GraphicsCallback.java:21)
        at sun.awt.SunGraphicsCallback.runOneComponent(SunGraphicsCallback.java:60)
        at sun.awt.SunGraphicsCallback.runComponents(SunGraphicsCallback.java:97)
        at java.awt.Container.paint(Container.java:1797)
        at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:734)
        at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:679)
        at javax.swing.RepaintManager.seqPaintDirtyRegions(RepaintManager.java:659)
        at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:128)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        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)
Comment 1 Jiri Prox 2008-04-29 06:27:03 UTC 
This is rather problem of mysql then Netbeans. 

I've found a similar mysql issue, maybe it's also your case, see http://bugs.mysql.com/bug.php?id=32649
Comment 2 spac 2008-04-29 08:36:48 UTC 
OK.
But why are you using connector version 5.1.5 when new version 5.1.6 has fixed this problem?
Comment 3 Jiri Prox 2008-04-29 09:25:53 UTC 
I hope someone from db team can give you the answer
Comment 4 Andrei Badea 2008-04-29 13:28:55 UTC 
Because we were not aware of this issue.
Comment 5 David Vancouvering 2008-05-14 00:50:46 UTC 
Workaround is for user to download and register newest driver from MySQL.  We'll get this done for 6.5.
Comment 6 Andrei Badea 2008-08-06 09:14:55 UTC 
30f854f42240
Comment 7 Roman Mostyka 2008-08-07 17:51:42 UTC 
Andrei, have you forgotten to do push? I still don't see this changeset in the trunk.
Comment 8 Andrei Badea 2008-08-07 18:03:53 UTC 
I didn't have time to do it yesterday.
Comment 9 Roman Mostyka 2008-08-07 18:52:09 UTC 
Verified with build 080807.
Comment 10 Quality Engineering 2008-08-08 04:31:52 UTC 
Integrated into 'main-golden', available in build *200808080201* on http://bits.netbeans.org/dev/nightly/
Changeset: http://hg.netbeans.org/main/rev/30f854f42240
User: Andrei Badea <abadea@netbeans.org>
Log: #134108: Upgrade bundled MySQL Connector/J to lastest version