Thread: [Squirrel-sql-users] Weird 3.1.1 Issue
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Drav S. <hol...@re...> - 2010-04-30 10:08:52
|
Haye All, First off, I've been using Squirrel SQL for about 2 months now and love the program. It's pretty feature rich, is damn useful for all my SQL requirements, and best of all unlike it's competitors (like TOAD) is free \o/. My thanks for an excellent client - Keep up the good work! Today I upgraded to 3.1.1 (via the very useful auto updater). However when I connect to a database, goto the SQL editor window and start typing queries it goes horribly wrong. I type 's' (of select) and it lags for a few seconds, and then the cursor appears catches up with what I've been typing and my select becomes 'tceles' (which happens to be the reverse of select). On trying to edit the typo the cursor lags more and sometimes the editor window freezes out and eventually comes back after 30s or so. 2010-04-30 10:38:39,058 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Application - Exception occured dispatching Event java.awt.event.KeyEvent[KEY_TYPED,keyCode=0,keyText=Unknown keyCode: 0x0,keyChar='s',keyLocation=KEY_LOCATION_UNKNOWN,rawCode=0,primaryLevelUnicode=0,scancode=0] on net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1844x303,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@1a84b38,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=sun.swing.PrintColorUIResource[r=51,g=51,b=51],disabledTextColor=javax.swing.plaf.ColorUIResource[r=184,g=207,b=229],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=sun.swing.PrintColorUIResource[r=51,g=51,b=51],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=0,word=true,wrap=false] 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.getLineWidth(SyntaxView.java:206) at org.fife.ui.rsyntaxtextarea.SyntaxView.possiblyUpdateLongLine(SyntaxView.java:582) at org.fife.ui.rsyntaxtextarea.SyntaxView.updateDamage(SyntaxView.java:672) at org.fife.ui.rsyntaxtextarea.SyntaxView.insertUpdate(SyntaxView.java:334) at javax.swing.plaf.basic.BasicTextUI$RootView.insertUpdate(Unknown Source) at javax.swing.plaf.basic.BasicTextUI$UpdateHandler.insertUpdate(Unknown Source) at javax.swing.text.AbstractDocument.fireInsertUpdate(Unknown Source) at org.fife.ui.rsyntaxtextarea.RSyntaxDocument.fireInsertUpdate(RSyntaxDocument.java:174) at javax.swing.text.AbstractDocument.handleInsertString(Unknown Source) at javax.swing.text.AbstractDocument.insertString(Unknown Source) at javax.swing.text.PlainDocument.insertString(Unknown Source) at javax.swing.text.AbstractDocument.replace(Unknown Source) at javax.swing.text.JTextComponent.replaceSelection(Unknown Source) at org.fife.ui.rtextarea.RTextArea.handleReplaceSelection(RTextArea.java:740) at org.fife.ui.rtextarea.RTextArea.replaceSelection(RTextArea.java:1093) at javax.swing.text.DefaultEditorKit$DefaultKeyTypedAction.actionPerformed(Unknown Source) at org.fife.ui.rtextarea.RTextAreaEditorKit$DefaultKeyTypedAction.actionPerformedImpl(RTextAreaEditorKit.java:745) at org.fife.ui.rtextarea.RecordableTextAction.actionPerformed(RecordableTextAction.java:118) at javax.swing.SwingUtilities.notifyAction(Unknown Source) at javax.swing.JComponent.processKeyBinding(Unknown Source) at javax.swing.JComponent.processKeyBindings(Unknown Source) at javax.swing.JComponent.processKeyEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.KeyboardFocusManager.redispatchEvent(Unknown Source) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(Unknown Source) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(Unknown Source) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(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) On pressing F5 to see if it was a cache issue I get: 'Error occured during task execution: null' 2010-04-30 10:40:02,496 [Thread-6] 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-30 10:40:03,777 [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@c13406,notifier=null,catchExceptions=false,when=1272620402496] on sun.awt.windows.WToolkit@17a8a02 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) I'm going to uninstall and re-install and see if this fixes things. Regards D. |
From: Drav S. <hol...@re...> - 2010-04-30 10:09:04
|
Drav Sloan wrote: > I'm going to uninstall and re-install and see if this fixes things. The latest installer seems to install a non-working app; I run the shortcut it created on my desktop and it exits pretty much straight away :/ Please bring back my working Squirrel! ;) Cheers D. |
From: Robert M. <rob...@gm...> - 2010-04-30 13:21:03
|
We believe we have identified the cause and have a work-around. Aliases with schema caching enabled are affected by a bug that causes the cache feature to break, leading to other application errors. You can remove all files beneath <user.home>/.squirrel-sql/schemacaches and restart squirrel, or for each Alias with schema caching enabled, close any open sessions, access "Alias Properties" and in the "Schemas" tab click on the "Delete Cache File" button near the bottom. Rob On 4/30/10, Drav Sloan <hol...@re...> wrote: > Drav Sloan wrote: > > I'm going to uninstall and re-install and see if this fixes things. > > The latest installer seems to install a non-working app; I run the shortcut > it created on my desktop and it exits pretty much straight away :/ > > Please bring back my working Squirrel! ;) > > Cheers > > D. > > ------------------------------------------------------------------------------ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
From: <Mai...@gm...> - 2010-05-01 13:50:30
|
I had the same thing. I turned off the syntax checker and it stopped happening. Rob Sent via IPhone. On Apr 30, 2010, at 4:41 AM, Drav Sloan <holborn-squirrel@real- life.tm> wrote: > Haye All, > > First off, I've been using Squirrel SQL for about 2 months now and > love the program. It's pretty feature rich, is damn useful for all my > SQL requirements, and best of all unlike it's competitors (like TOAD) > is free \o/. My thanks for an excellent client - Keep up the good > work! > > Today I upgraded to 3.1.1 (via the very useful auto updater). > However > when I connect to a database, goto the SQL editor window and start > typing > queries it goes horribly wrong. I type 's' (of select) and it lags > for a > few seconds, and then the cursor appears catches up with what I've > been typing > and my select becomes 'tceles' (which happens to be the reverse of > select). > On trying to edit the typo the cursor lags more and sometimes the > editor > window freezes out and eventually comes back after 30s or so. > > 2010-04-30 10:38:39,058 [AWT-EventQueue-1] ERROR > net.sourceforge.squirrel_sql.client.Application - Exception occured > dispatching Event java.awt.event.KeyEvent > [KEY_TYPED,keyCode=0,keyText=Unknown keyCode: > 0x0, > keyChar= > 's' > ,keyLocation= > KEY_LOCATION_UNKNOWN,rawCode=0,primaryLevelUnicode=0,scancode=0] on > net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[ > ,0,0,1844x303,layout=javax.swing.plaf.basic.BasicTextUI > $UpdateHandler, > alignmentX= > 0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders > $MarginBorder@ > 1a84b38, > flags= > 16777576, > maximumSize= > ,minimumSize= > ,preferredSize=,caretColor=sun.swing.PrintColorUIResource > [r=51,g=51,b=51],disabledTextColor=javax.swing.plaf.ColorUIResource > [r= > 184, > g=207,b=229],editable=true,margin=javax.swing.plaf.InsetsUIResource > [top= > 0,l > eft= > 0,bottom=0,right=0],selectedTextColor=sun.swing.PrintColorUIResource > [r=51,g=51,b=51],selectionColor=java.awt.Color > [r= > 200, > g=2 > 00, > b=255],colums=0,columWidth=0,rows=0,rowHeight=0,word=true,wrap=false] > 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.getLineWidth > (SyntaxView.java:206) > at org.fife.ui.rsyntaxtextarea.SyntaxView.possiblyUpdateLongLine > (SyntaxView.java:582) > at org.fife.ui.rsyntaxtextarea.SyntaxView.updateDamage > (SyntaxView.java:672) > at org.fife.ui.rsyntaxtextarea.SyntaxView.insertUpdate > (SyntaxView.java:334) > at javax.swing.plaf.basic.BasicTextUI$RootView.insertUpdate > (Unknown Source) > at javax.swing.plaf.basic.BasicTextUI$UpdateHandler.insertUpdate > (Unknown Source) > at javax.swing.text.AbstractDocument.fireInsertUpdate(Unknown > Source) > at org.fife.ui.rsyntaxtextarea.RSyntaxDocument.fireInsertUpdate > (RSyntaxDocument.java:174) > at javax.swing.text.AbstractDocument.handleInsertString(Unknown > Source) > at javax.swing.text.AbstractDocument.insertString(Unknown Source) > at javax.swing.text.PlainDocument.insertString(Unknown Source) > at javax.swing.text.AbstractDocument.replace(Unknown Source) > at javax.swing.text.JTextComponent.replaceSelection(Unknown Source) > at org.fife.ui.rtextarea.RTextArea.handleReplaceSelection > (RTextArea.java:740) > at org.fife.ui.rtextarea.RTextArea.replaceSelection > (RTextArea.java:1093) > at javax.swing.text.DefaultEditorKit > $DefaultKeyTypedAction.actionPerformed(Unknown Source) > at org.fife.ui.rtextarea.RTextAreaEditorKit > $DefaultKeyTypedAction.actionPerformedImpl(RTextAreaEditorKit.java: > 745) > at org.fife.ui.rtextarea.RecordableTextAction.actionPerformed > (RecordableTextAction.java:118) > at javax.swing.SwingUtilities.notifyAction(Unknown Source) > at javax.swing.JComponent.processKeyBinding(Unknown Source) > at javax.swing.JComponent.processKeyBindings(Unknown Source) > at javax.swing.JComponent.processKeyEvent(Unknown Source) > at java.awt.Component.processEvent(Unknown Source) > at java.awt.Container.processEvent(Unknown Source) > at java.awt.Component.dispatchEventImpl(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.KeyboardFocusManager.redispatchEvent(Unknown Source) > at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(Unknown > Source) > at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent > (Unknown Source) > at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions > (Unknown Source) > at java.awt.DefaultKeyboardFocusManager.dispatchEvent(Unknown > Source) > at java.awt.Component.dispatchEventImpl(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Window.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(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) > > On pressing F5 to see if it was a cache issue I get: > > 'Error occured during task execution: null' > > 2010-04-30 10:40:02,496 [Thread-6] 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-30 10:40:03,777 [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@c13406,notifier=null,catchExceptions=false,when=1272620402496 > ] on sun.awt.windows.WToolkit@17a8a02 > 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) > > I'm going to uninstall and re-install and see if this fixes things. > > Regards > > D. > > > --- > --- > --- > --------------------------------------------------------------------- > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |