Re: [Squirrel-sql-users] Editation after sql query

[Rob M. <Rob...@co...>]

adamec vaclav wrote:

> Log is from Linux machine where is 2.0 final, but same I receive in 
> 2.1rc2 on Win XP. At this system is newest Java, mysql-connector and 
> SQuirell :-(

I see.  Still unexplained why you get that error message, though.

I bet it has more to do with this:

java.sql.SQLException: Value '0000-00-00' can not be represented as 
java.sql.Date
    at com.mysql.jdbc.ResultSet.getDateFromString(ResultSet.java:1886)
    at com.mysql.jdbc.ResultSet.getDate(ResultSet.java:1822)
    at com.mysql.jdbc.ResultSet.getDate(ResultSet.java:1790)
    at 
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.DataTypeDate.readResultSet(DataTypeDate.java:459)
    at 
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.CellComponentFactory.readResultSet(CellComponentFactory.java:503)
    at 
net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.doContentTabRead(ResultSetReader.java:461)
    at 
net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.readRow(ResultSetReader.java:151)
    at 
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResultSet(ResultSetDataSet.java:132)
    at 
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setContentsTabResultSet(ResultSetDataSet.java:71)
    at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab.createDataSet(ContentsTab.java:352)
    at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab.refreshComponent(BaseDataSetTab.java:121)
    at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseObjectTab.select(BaseObjectTab.java:104)
    at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeTabbedPane.selectCurrentTab(ObjectTreeTabbedPane.java:119)
    at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel$2.run(ObjectTreePanel.java:669)
    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)

Let me guess, you have some nulls in your date column(s)??  (I believe 
this is how MySQL driver responds
when you don't bother to check if the value was null.)

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83