No problem.  I'm glad to have the upgrade because it included a fix for bug #2974533.  Now the console is useful!

Robert & Gerd, thanks for all your work SQuirreL SQL.  It is *hand down* the best open source SQL editor I've found.

Eric P.



From:        Gerd Wagner <gerdhwagner@t-online.de>
To:        epierce@wernervas.com
Cc:        Robert Manning <robert.m.manning@gmail.com>, squirrel-sql-users@lists.sourceforge.net
Date:        04/27/2010 11:58 AM
Subject:        Re: [Squirrel-sql-users] 3.1.1 broken for me




epierce@wernervas.com wrote:
> Hitting F5 gives me an alert box with:
> "Error ocured during task execution: null"

Now that I see it it is clear to me that this had to happen. Sorry for my bad
advice. Removing the cache files, as you say in your follow up mail, was the
right choice.

Sorry

Gerd

>
>
> Here's the error from the log.
>
> 2010-04-27 07:52:02,488 [Thread-5] ERROR
> net.sourceforge.squirrel_sql.fw.util.TaskThreadPool  - Error
> java.lang.NullPointerException
>         at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.clearAllSchemaDependentData(SchemaInfoCache.java:417)
>
>         at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.clearAll(SchemaInfoCache.java:405)
>
>         at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:205)
>
>         at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:197)
>
>         at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:324)
>
>         at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>         at java.lang.Thread.run(Unknown Source)
> 2010-04-27 07:52:04,581 [AWT-EventQueue-1] ERROR
> net.sourceforge.squirrel_sql.client.Application  - Exception occured
> dispatching Event
> java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback$1@1e0e954,notifier=null,catchExceptions=false,when=1272372722488]
> on sun.awt.windows.WToolkit@e1d5ea
> java.lang.RuntimeException: java.lang.NullPointerException
>         at
> net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback$1.run(TaskThreadPool.java:161)
>
>         at java.awt.event.InvocationEvent.dispatch(Unknown Source)
>         at java.awt.EventQueue.dispatchEvent(Unknown Source)
>         at
> net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:194)
>
>         at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
> Source)
>         at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
>         at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
> Source)
>         at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>         at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>         at java.awt.EventDispatchThread.run(Unknown Source)
> Caused by: java.lang.NullPointerException
>         at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.clearAllSchemaDependentData(SchemaInfoCache.java:417)
>
>         at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.clearAll(SchemaInfoCache.java:405)
>
>         at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:205)
>
>         at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:197)
>
>         at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:324)
>
>         at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>         at java.lang.Thread.run(Unknown Source)
>
>
> Thanks,
> Eric P.
>
> Ps 'occurred' is misspelled a couple times up there.    ;)
>
>
>
> From:        Gerd Wagner <gerdhwagner@t-online.de>
> To:        epierce@wernervas.com
> Cc:        squirrel-sql-users@lists.sourceforge.net, Robert Manning
> <robert.m.manning@gmail.com>
> Date:        04/27/2010 12:15 AM
> Subject:        Re: [Squirrel-sql-users] 3.1.1 broken for me
> ------------------------------------------------------------------------
>
>
>
> Eric,
>
> I just saw the problem too. You use Schema caching in your Alias, right?
>
> After you just opened your Session hit the F5 key. This will
> reinitialize your
> cache. You only need to do it once for each Alias that uses caching.
>
> Please let me know if this solves your problem.
>
> Could you also please file a bug about it here:
>
http://sourceforge.net/tracker/?group_id=28383&atid=393414
> <
http://sourceforge.net/tracker/?group_id=28383&atid=393414>
>
>
> @Rob:
> The problem is that a serialized object of SchemaInfoCache that was
> saved before
> I introduced SchemaInfoColumnCache as a member of SchemaInfoCache does
> not know
> anything about this member. Normally this leads to serialization
>  exceptions
> that are handled smoothly, but seemingly not this time.
>
>
> Sorry for the inconvenience
>
> Gerd
>
>
>
>
> epierce@wernervas.com wrote:
>  > Just got the notice to upgrade to 3.1.1 on Windows XP.
>  >
>  > As soon as I type into the editor it starts throwing repeated errors,
>  > and I'm unable to execute any queries.
>  >
>  >
>  > Exception occured dispatching Event
>  >
> java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=javax.swing.SystemEventQueueUtilities$ComponentWorkRequest@57828d,notifier=null,catchExceptions=false,when=1272313054178]
>
>  > on sun.awt.windows.WToolkit@c88440
>  >
>  >
>  > And the stack trace:
>  > java.lang.NullPointerException
>  >         at
>  >
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getExtColumnInfosByColumnNameForReadOnly(SchemaInfoCache.java:620)
>
>  >
>  >         at
>  >
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isColumn(SchemaInfo.java:789)
>
>  >
>  >         at
>  >
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxHighlightTokenMatcher.isColumn(RSyntaxHighlightTokenMatcher.java:216)
>
>  >
>  >         at
>  >
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxHighlightTokenMatcherProxy.isColumn(RSyntaxHighlightTokenMatcherProxy.java:71)
>
>  >
>  >         at
>  >
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMarker.addToken(SquirrelTokenMarker.java:57)
>
>  >
>  >         at
>  >
> org.fife.ui.rsyntaxtextarea.TokenMakerBase.addToken(TokenMakerBase.java:90)
>  >         at
>  >
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.addToken(SquirrelTokenMakerBase.java:313)
>
>  >
>  >         at
>  >
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.addToken(SquirrelTokenMakerBase.java:298)
>
>  >
>  >         at
>  >
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.addToken(SquirrelTokenMakerBase.java:287)
>
>  >
>  >         at
>  >
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.yylex(SquirrelTokenMakerBase.java:683)
>
>  >
>  >         at
>  >
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.getTokenList(SquirrelTokenMakerBase.java:370)
>
>  >
>  >         at
>  >
> org.fife.ui.rsyntaxtextarea.RSyntaxDocument.getTokenListForLine(RSyntaxDocument.java:336)
>
>  >
>  >         at
>  > org.fife.ui.rsyntaxtextarea.SyntaxView.paint(SyntaxView.java:564)
>  >         at javax.swing.plaf.basic.BasicTextUI$RootView.paint(Unknown
>  > Source)
>  >         at javax.swing.plaf.basic.BasicTextUI.paintSafely(Unknown Source)
>  >         at javax.swing.plaf.basic.BasicTextUI.paint(Unknown Source)
>  >         at javax.swing.plaf.basic.BasicTextUI.update(Unknown Source)
>  >         at
>  >
> org.fife.ui.rtextarea.RTextAreaBase.paintComponent(RTextAreaBase.java:667)
>  >         at
>  >
> org.fife.ui.rsyntaxtextarea.RSyntaxTextArea.paintComponent(RSyntaxTextArea.java:1186)
>
>  >
>  >         at javax.swing.JComponent.paint(Unknown Source)
>  >         at javax.swing.JComponent.paintToOffscreen(Unknown Source)
>  >         at
>  > javax.swing.RepaintManager$PaintManager.paintDoubleBuffered(Unknown
> Source)
>  >         at javax.swing.RepaintManager$PaintManager.paint(Unknown Source)
>  >         at javax.swing.BufferStrategyPaintManager.paint(Unknown Source)
>  >         at javax.swing.RepaintManager.paint(Unknown Source)
>  >         at javax.swing.JComponent._paintImmediately(Unknown Source)
>  >         at javax.swing.JComponent.paintImmediately(Unknown Source)
>  >         at javax.swing.RepaintManager.paintDirtyRegions(Unknown Source)
>  >         at javax.swing.RepaintManager.paintDirtyRegions(Unknown Source)
>  >         at javax.swing.RepaintManager.seqPaintDirtyRegions(Unknown
> Source)
>  >         at
>  > javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(Unknown
>  > Source)
>  >         at java.awt.event.InvocationEvent.dispatch(Unknown Source)
>  >         at java.awt.EventQueue.dispatchEvent(Unknown Source)
>  >         at
>  >
> net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:194)
>
>  >
>  >         at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
>  > Source)
>  >         at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
> Source)
>  >         at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
>  > Source)
>  >         at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>  >         at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>  >         at java.awt.EventDispatchThread.run(Unknown Source)
>  >
>  >
>  > Thanks,
>  > Eric P.
>  > _______________________________________________
>  > Squirrel-sql-users mailing list
>  > Squirrel-sql-users@lists.sourceforge.net
>  >
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@lists.sourceforge.net
>
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users