Well, it turns out that what causes the hanging is the "Run all SQLs in
editor" button.
The same SQL which fails using Alt+Shift+Enter works fine if I select
it and type Ctrl+Enter.
My query contains two statements:
SET SCHEMA MYSCHEMA;
SELECT SOMETHING FROM WHATEVER;
I tried reproducing the error using minimal examples, but everything
works fine.
I'll use Ctrl+Enter to avoid the problem.
Il giorno ven 30 giu 2017 alle 18:47, Cosmin Blaga
<dre...@gm...> ha scritto:
> The error you posted indicates that something went wrong with the
> look and feel of Squirrel. I doubt it has anything to do with your
> pb, but try setting the default L&F and see if the error appears
> again.
>
> For the query you might try different things. Like refining the
> filter on it, trying to bring less columns in it. Eliminate parts of
> it until you see what causes the blockage. Divide et impera. You can
> also try an analysis on it to see what generates more load (if it's
> Oracle)
>
>
> On 30 Jun 2017 14:58, "Federico Bruni" <fe...@in...> wrote:
>> Hi all
>>
>> I've launched a query that used to work in the past (I track my
>> query scripts in a git repository and I commit them only after
>> testing them) and now causes Squirrel to hang forever until I end
>> the process using kill.
>>
>> How can I debug it?
>> I've looked in the log file but cannot see anything suspicious.
>>
>> Thanks in advance for any pointer
>> Federico
>>
>> PS I found this error in the log. No idea if it's related to the
>> hanging:
>>
>>
>> 2017-06-30 13:20:05,246 [AWT-EventQueue-1] ERROR
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData -
>> Unable to load LAF class
>> (com.jtattoo.plaf.mint.MintLookAndFeel):com.jtattoo.plaf.mint.MintLookAndFeel
>> java.lang.ClassNotFoundException:
>> com.jtattoo.plaf.mint.MintLookAndFeel
>> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>> at
>> net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>> at java.lang.Class.forName0(Native Method)
>> at java.lang.Class.forName(Class.java:348)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.putClass(JTattooLafData.java:82)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.initLafMap(JTattooLafData.java:62)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.<init>(JTattooLafData.java:49)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLookAndFeelController.<init>(JTattooLookAndFeelController.java:92)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.LAFRegister.installLookAndFeelControllers(LAFRegister.java:461)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.LAFRegister.<init>(LAFRegister.java:141)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.LAFPlugin.load(LAFPlugin.java:211)
>> at
>> net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugin(PluginManager.java:649)
>> at
>> net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugins(PluginManager.java:452)
>> at
>> net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:726)
>> at
>> net.sourceforge.squirrel_sql.client.Application.startup(Application.java:216)
>> at net.sourceforge.squirrel_sql.client.Main$2.run(Main.java:118)
>> at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
>> at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
>> at java.awt.EventQueue.access$500(EventQueue.java:97)
>> at java.awt.EventQueue$3.run(EventQueue.java:709)
>> at java.awt.EventQueue$3.run(EventQueue.java:703)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at
>> java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
>> at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
>> at
>> net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
>> at
>> java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
>> at
>> java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
>> at
>> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
>> at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
>> at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
>> at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|