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)
I have exactly the same problem.
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
Also getting NoSuchMethodException. It makes me sad.
Last edit: Anonymous 2015-12-27
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)
What version did you upgrade from ?
Rob
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
That worked for me. Thank you very much, Rob! :)
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
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
-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
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
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
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!
@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
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
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
@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
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
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/