Re: [Squirrel-sql-users] 3.1.1 broken for me

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hitting F5 gives me an alert box with:
"Error ocured during task execution: null"

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 <ger...@t-...>
To:     ep...@we...
Cc:     squ...@li..., Robert Manning 
<rob...@gm...>
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

@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

ep...@we... 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
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] 3.1.1 broken for me

A Java SQL client for any JDBC compliant database

Re: [Squirrel-sql-users] 3.1.1 broken for me