Editation after sql query

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Editation after sql query

adamec vaclav
Hello,
squirrel is very usefull, but it is possible to make editable output
from SQL query? I could edit mysql data in main session's screen only
:-( I could step-over my SQL query and use "Content Tab SQL Filter" but
it is not full SQL (columns selection is not posible)

Is there any plugin or "hack" ?

Thanks for any advice

Vasek Adamec
CZ


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|

Re: Editation after sql query

Rob Manning
adamec vaclav wrote:

> Hello,
> squirrel is very usefull, but it is possible to make editable output
> from SQL query? I could edit mysql data in main session's screen only
> :-( I could step-over my SQL query and use "Content Tab SQL Filter"
> but it is not full SQL (columns selection is not posible)

As long as the query returns rows from one table, you can
right-click to access the context menu in the SQL results
table and select "Make Editable".  Then any cell should allow
you to change the value.

Rob



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




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|

Re: Editation after sql query

adamec vaclav
Maybe this is problem:

/////////////////
1512440 [AWT-EventQueue-0] ERROR
net.sourceforge.squirrel_sql.fw.util.StringManager  - No resource string
found for key 'SessionTextEditPopupMenu.makeeditable'
////////////////

Vaclav A.

Rob Manning napsal(a):

> Vaclav Adamec wrote:
>
>> Hi, I make something like this simple select:
>> SELECT `column_A`,`column_B` FROM `table` WHERE `column_A` LIKE
>> 'test%' -  one table, simple select, but in rightclickmenu is not
>> item "Make  editable".
>>
>> Version of SQuirrel is 2.1 rc2 (standard plug-ins, running on Windows
>> or  Linux), and MySQL database.
>
>
> Weird, that seems to work for me.  You may have found a bug.
> Could you forward your squirrel-sql.log file to me? (It's in
> <user.home>/.squirrel-sql/logs)
>
> Rob
>
>

0    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
5    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
5    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
13   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - SQuirreL SQL Client Version 2.0 final started: Mon Nov 28 09:16:40 CET 2005
13   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - Copyright (c) 2001-2005 Colin Bell and others
13   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.vendor: Sun Microsystems Inc.
13   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.version: 1.5.0_03
13   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition
14   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.name: Linux
14   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.version: 2.6.13-15-default
14   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.arch: i386
14   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.dir: /home/adamecv
14   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.home: /home/adamecv
14   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.home: /usr/lib/jvm/java-1.5.0-sun-1.5.0_03/jre
14   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.class.path: /home/adamecv/mismas/SQuirreL SQL Client/squirrel-sql.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/commons-cli.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/forms.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/fw.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/log4j.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/mysql-connector-java-3.1.11-bin.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/nanoxml-2.1.jar:
3394 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - Plugin mysql created in 4 ms, loaded in 4 ms, initialized in 18 ms, total 26 ms.
19676 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.util.StringManager  - No resource string found for key 'SessionTextEditPopupMenu.makeeditable'
1891179 [AWT-EventQueue-0] INFO  net.sourceforge.squirrel_sql.client.Application  - Application shutting down 28.11.05 9:48.
1893440 [AWT-EventQueue-0] INFO  net.sourceforge.squirrel_sql.client.Application  - Application shutdown complete 28.11.05 9:48.
0    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
2    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
2    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - SQuirreL SQL Client Version 2.0 final started: Tue Nov 29 08:32:21 CET 2005
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - Copyright (c) 2001-2005 Colin Bell and others
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.vendor: Sun Microsystems Inc.
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.version: 1.5.0_03
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.name: Linux
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.version: 2.6.13-15-default
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.arch: i386
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.dir: /home/adamecv
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.home: /home/adamecv
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.home: /usr/lib/jvm/java-1.5.0-sun-1.5.0_03/jre
6    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.class.path: /home/adamecv/mismas/SQuirreL SQL Client/squirrel-sql.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/commons-cli.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/forms.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/fw.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/log4j.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/mysql-connector-java-3.1.11-bin.jar:/home/adamecv/mismas/SQuirreL SQL Client/lib/nanoxml-2.1.jar:
3417 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - Plugin mysql created in 2 ms, loaded in 2 ms, initialized in 36 ms, total 40 ms.
11101 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.util.StringManager  - No resource string found for key 'SessionTextEditPopupMenu.makeeditable'
669174 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669184 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669185 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669186 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669187 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669188 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669189 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669190 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669191 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669192 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669193 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669194 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669195 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669202 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669203 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669204 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669205 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669206 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669207 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669208 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669209 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669209 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669210 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669212 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669213 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
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)
669221 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.fw.sql.ResultSetReader  - Error reading column data, column index = 7
java.sql.SQLExce
Reply | Threaded
Open this post in threaded view
|

Re: Editation after sql query

Rob Manning
adamec vaclav wrote:

> Maybe this is problem:
>
> /////////////////
> 1512440 [AWT-EventQueue-0] ERROR
> net.sourceforge.squirrel_sql.fw.util.StringManager  - No resource
> string found for key 'SessionTextEditPopupMenu.makeeditable'
> ////////////////

It could be, although I see it was defined in I18NStrings.properties
years ago.  Also, you don't appear
to be running the latest SQuirreL.  You appear to be running "SQuirreL
SQL Client Version 2.0 final" according
to the log.  I'm not saying that's bad, just that you said you were
running 2.1rc2.

Rob


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




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|

Re: Editation after sql query

Rob Manning
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




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|

Re: Editation after sql query

Rob Manning
adamec vaclav wrote:

> Whole database is in UTF-8 (utf8_general), maybe I need to somehow
> setup this colation during connection to database?

Not really sure about that.  I believe I was seeing the same exception
when I attempted to
insert a null into a date field in mysql when the date in question was
null.  Like;

ps.setDate(1, null);

Instead of

ps.setNull(1, Types.Date);

I can't see how this would be related to the behavior you are seeing -
just that it's
the same error message that I was getting.

Rob


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




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|

Re: Editation after sql query

adamec vaclav
Maybe is problem with mysql connector at all - I try MS SQL and this
works - after simple SQL query is possible to edit founded data. I'm
using mysql-connector-java-3.1.11. Is there any other mysql-connecotr?

Vasek A.

Rob Manning napsal(a):

> adamec vaclav wrote:
>
>> Whole database is in UTF-8 (utf8_general), maybe I need to somehow
>> setup this colation during connection to database?
>
>
> Not really sure about that.  I believe I was seeing the same exception
> when I attempted to
> insert a null into a date field in mysql when the date in question was
> null.  Like;
>
> ps.setDate(1, null);
>
> Instead of
>
> ps.setNull(1, Types.Date);
>
> I can't see how this would be related to the behavior you are seeing -
> just that it's
> the same error message that I was getting.
>
> Rob
>
>
> CollabraSpace - Revolutionary Collaboration
> Visit us at http://www.collabraspace.com
> This message has been scanned for viruses by
> ClamAV v0.83
>
>
>



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|

Re: Editation after sql query

Rob Manning
adamec vaclav wrote:

> Maybe is problem with mysql connector at all - I try MS SQL and this
> works - after simple SQL query is possible to edit founded data. I'm
> using mysql-connector-java-3.1.11. Is there any other mysql-connecotr?
>
> Vasek A.

I'm using mysql-connector-java-3.1.8-bin.jar against MySQL 4.1.14-nt on
WinXP.

Rob


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




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users