Menu

#929 Cannot connect after latest software update

None
closed-fixed
5
2018-12-22
2010-12-14
Anonymous
No

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)

Discussion

  • Garry Cobbum

    Garry Cobbum - 2010-12-14

    I have exactly the same problem.

     
  • Anonymous

    Anonymous - 2010-12-15

    Also getting NoSuchMethodException. It makes me sad.

     

    Last edit: Anonymous 2015-12-27
  • Emily Bloss

    Emily Bloss - 2010-12-15

    I am also having the same problem. I'm running Ubuntu 10.04 LTS - the Lucid Lynx and SQuirreL SQL Client Snapshot-20101212_1529. Here is the stack trace, if it helps:

    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:226)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:602)
    at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:93)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:138)

     
  • Rob Manning

    Rob Manning - 2010-12-15

    What version did you upgrade from ?

    Rob

     
  • Rob Manning

    Rob Manning - 2010-12-15
    • assigned_to: nobody --> manningr
    • milestone: --> 3.2
    • labels: --> Software Updater
     
  • Rob Manning

    Rob Manning - 2010-12-16

    Good news - I've reproduced the problem and discovered what it is. It appears that the installed plugins are not being properly detected, so the updates are not downloaded. In this case, the plugin is syntax-assembly.zip in the update table dialog. So the work-around is to:

    1. Click "Check" in the software update dialog,
    2. Find the plugins you have loaded (including Syntax) and move the "action" from "NONE" to "INSTALL".
    3. Click "Apply Changes" and restart SQuirreL.

    Now I will look into why the installed plugins are not being properly detected. It could very well be our switch to using Maven which drove the decision to change the artifact name for plugins.

    Rob

     
  • Emily Bloss

    Emily Bloss - 2010-12-16

    That worked for me. Thank you very much, Rob! :)

     
  • Rob Manning

    Rob Manning - 2010-12-18

    Fixed in SVN. Snapshot-20101218_1609 has the fix. However, the core components need to be updated and SQuirreL restarted before the update summary will list the installed plugins as "INSTALL". So, update, restart then update again. After this update, or any successive one, this process will be unnecessary.

    Rob

     
  • Rob Manning

    Rob Manning - 2010-12-18
    • status: open --> closed-fixed
     
  • Anonymous

    Anonymous - 2010-12-23

    -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

     
  • Nobody/Anonymous

    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! ;-)

     
  • Nobody/Anonymous

    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

    Anonymous - 2011-01-04

    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 - 2011-01-04

    @Jeff

    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.

    Rob

     
  • Anonymous

    Anonymous - 2011-01-05

    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 - 2011-01-05

    @mkempster,

    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

     
  • Rob Manning

    Rob Manning - 2011-01-05

    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.

    Rob

     
  • Nobody/Anonymous

    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.

     
  • Nobody/Anonymous

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

     

Log in to post a comment.