#929 Cannot connect after latest software update

Rob Manning

I updated SQuirreL today to the latest version, using the built in updating feature.
My curent version shows up as "SQuirreL SQL Client Snapshot-20101212_1529"

Upon restarting SQuirreL, I am unable to connect to my database.

When I attempt to connect I get a messagebox saying:
Error opening session

From this window there is a button to view the stacktrace, which shows:
java.lang.NoSuchMethodError: org.fife.ui.rsyntaxtextarea.SyntaxScheme.restoreDefaults()V
at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelSyntaxScheme.initSytles(SquirrelSyntaxScheme.java:29)
at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea.updateFromPreferences(SquirrelRSyntaxTextArea.java:128)
at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea.<init>(SquirrelRSyntaxTextArea.java:59)
at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxSQLEntryPanel.<init>(RSyntaxSQLEntryPanel.java:79)
at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxSQLEntryAreaFactory.createSQLEntryPanel(RSyntaxSQLEntryAreaFactory.java:37)
at net.sourceforge.squirrel_sql.plugins.syntax.SQLEntryPanelFactoryProxy.createSQLEntryPanel(SQLEntryPanelFactoryProxy.java:64)
at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.createGUI(SQLPanel.java:844)
at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.<init>(SQLPanel.java:182)
at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.getComponent(SQLTab.java:72)
at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.getSQLPanel(SQLTab.java:123)
at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.setSession(SQLTab.java:83)
at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.<init>(SQLTab.java:42)
at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.<init>(MainPanel.java:112)
at net.sourceforge.squirrel_sql.client.gui.session.MainPanelFactory.createMainPanel(MainPanelFactory.java:27)
at net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.createGUI(SessionPanel.java:478)
at net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.initialize(SessionPanel.java:134)
at net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.createGUI(SessionInternalFrame.java:123)
at net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.<init>(SessionInternalFrame.java:53)
at net.sourceforge.squirrel_sql.client.gui.WindowManager.createInternalFrame(WindowManager.java:360)
at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:373)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:93)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)


<< < 1 2 (Page 2 of 2)
  • Unfortunately, this didn't work for me when I ran into this problem after updating. I tried repeatedly, and kept getting errors. So I finally threw in the towel, deleted my old SQuirreL installation (based on version 3.1.2), and installed the latest (3.2.1) downloaded from the website. Thankfully, this resolved my problems. All's well that ends well -- if it ever ends! ;-)

  • I had the same problem but Apokais tipp worked for me too. But not at the first time. When I tried it the second (or third) time - it worked. Thanks

    -Click on Help, Software Update, then on "Check" (It might say it is the
    most current updated version, just click OK (we don't care));
    -Right click anywhere in the new window, select "All plugins";
    -Apply changes;
    - Close, restart (It will reinstall)

    You're good


  • Anonymous

    Same problem after upgrade from 3.2.0 (on WinXP). Tried restarting several times with no luck. Had to do a full 3.2.1 install to resolve the problem. Working now... hoping the next auto-update will not have this problem. This problem aside, I'm loving the SQuirreL - thx!

  • Rob Manning
    Rob Manning


    Just to be clear, when you say "Tried restarting several times", did you try to update all of your plugins between restarts ? If not, restarting will have no effect, as expected.



  • Anonymous

    Ubuntu 10.04... I saw this when upgrading from 3.2.0 to 3.2.1.
    Thanks to manningr's comment about syntax, I was able to put the old syntax jar back and have things work again.

    cd <squirrel-install-dir>
    cp ./update/backup/core/rsyntaxtextarea.jar ./lib/rsyntaxtextarea.jar

  • Rob Manning
    Rob Manning


    You now have the old plugin and the old rsyntaxtextarea library. They were updated to fix an issue that escapes me at the moment. You may want to re-install if you encounter issues with that configuration.


  • Rob Manning
    Rob Manning

    I'll just re-iterate this so that this doesn't get lost in the sea of comments from users who are "solving" the problem in interesting ways:

    The core components need to be updated and SQuirreL restarted before the update
    summary will list the installed plugins as "INSTALL". So, after updating to 3.2.1 do the following:

    1. Restart
    2. Check for updates to show the available updates dialog.
    3. If plugins that you have installed are still not listed under "ACTION" as "INSTALL", then select the syntax-assembly.zip plugin (and others if necessary), and click on the cell in the table in the "ACTION" column. This will reveal a drop-down menu from which you must choose "INSTALL".
    4. Apply changes
    5. Restart.


  • I ran into this same problem on my mac os. the advice from Rob above worked; however, after I restarted and the problem was resolved, each restart prompted me to reinstall again and again. I had to go back through the same steps and turn off the installs to make this "feature" turn off/stop. :) Thanks for your comments Rob, I searched for a while before I found it.

  • sRZV8s <a href="http://yzemakhgxqnu.com/">yzemakhgxqnu</a>, [url=http://jrogbzfpqddp.com/]jrogbzfpqddp[/url], [link=http://nlogcubwepgr.com/]nlogcubwepgr[/link], http://odocddwugmsz.com/

<< < 1 2 (Page 2 of 2)