squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] Issue launching squirrel client

[Stanimir S. <s7...@ne...>]

Thu, 18 May 2023 13:02:15 +0000, /Greg Blajian/:

> $ java -jar squirrel-sql.jar
> 
> java.lang.RuntimeException: 
> com.fasterxml.jackson.databind.JsonMappingException: No content to map 
> due to end-of-input
> at [Source: java.io.InputStreamReader@248af7cf; line: 1, column: 1]
>          ...
>          at net.sourceforge.squirrel_sql.client.gui.recentfiles.RecentFilesManager.initJSonBean(RecentFilesManager.java:89)
>          at net.sourceforge.squirrel_sql.client.Application.loadRecentFileHistory(Application.java:1060)
>          ...

Seems like you're having a corrupt "RecentFilesJsonBean.json":

* 
https://github.com/squirrel-sql-client/squirrel-sql-code/blob/1a950b28b/sql12/core/src/net/sourceforge/squirrel_sql/client/Application.java#L1060
* 
https://github.com/squirrel-sql-client/squirrel-sql-code/blob/1a950b28b/sql12/core/src/net/sourceforge/squirrel_sql/client/util/ApplicationFiles.java#L200-L202

Try deleting it (move it away or rename it):

 > ren %USERPROFILE%\.squirrel-sql\RecentFilesJsonBean.json 
RecentFilesJsonBean.json.bak

Alternatively, you may open it in Notepad – if the content is empty (as 
it seems from the exception message), enter an empty JSON object and 
save it back:

{}

-- 
Stanimir

Re: [Squirrel-sql-users] What is the latest Squirrel version which works with Java v8?

[Stanimir S. <s7...@ne...>]

Tue, 16 May 2023 19:09:36 +0200, /Ben/:

> What is the latest Squirrel version which works with Java v8?

Looking at:

* 
https://github.com/squirrel-sql-client/squirrel-sql-code/blob/90e68ebdb/sql12/core/doc/changes.txt#L741-L744

If I'm not mistaken, it should be 4.2.0 (04/05/2021).  The next one – 
4.3.0 (10/02/2021) requires Java 11.

-- 
Stanimir

Re: [Squirrel-sql-users] Issue launching squirrel client

[Greg B. <gjb...@ho...>]

The location I was running the application from was a microSD card that seems to have a few issues. After I discovered this, I tried moving the folder to my primary drive and relaunching and that is when this started. I believe it is trying to read a configuration file from my user profile location and that the file may e corrupt but I do not know what file or where it may be looking. One of those AppData folder issues, maybe?

Gregory J Blajian
gjb...@ho...

From: Roger Hill <rh...@hi...>
Sent: Thursday, May 18, 2023 09:07
To: squ...@li...
Subject: Re: [Squirrel-sql-users] Issue launching squirrel client


Hi.



If the error is common across 3 applications, then I guess it is not a Squirrel problem.



Maybe try re-installing Java?



What changed between the time it worked, and when it stopped working?



Regards

Roger
On 18/05/2023 09:02, Greg Blajian wrote:
I have been using squirrel for many years. Normally, I can figure out any issues on my own but it seems I have a corrupt file somewhere and the stack trace is not helping. I am getting the below error when I attempt to launch the application. I have downloaded a fresh copy the latest stable build 4.5.1 and installed it in different locations (both the zip and the installer). I have tried Amazon Corretto [C:\Program Files\Amazon Corretto\jdk11.0.19_7\bin] and Eclipse Adoptium [C:\Program Files\Eclipse Adoptium\jdk-11.0.19.7-hotspot\bin] but EVERY instance has the same error. The splash screen starts gets about ¾ through then gives me this error. If I had any idea what file it is trying to read and failing at I would fix it. Please help.

$ java -jar squirrel-sql.jar
java.lang.RuntimeException: com.fasterxml.jackson.databind.JsonMappingException: No content to map due to end-of-input
at [Source: java.io.InputStreamReader@248af7cf<mailto:java.io.InputStreamReader@248af7cf>; line: 1, column: 1]
        at net.sourceforge.squirrel_sql.fw.util.Utilities.wrapRuntime(Utilities.java:449)
        at net.sourceforge.squirrel_sql.fw.util.JsonMarshalUtil.readObjectFromFile(JsonMarshalUtil.java:52)
        at net.sourceforge.squirrel_sql.client.gui.recentfiles.RecentFilesManager.initJSonBean(RecentFilesManager.java:89)
        at net.sourceforge.squirrel_sql.client.Application.loadRecentFileHistory(Application.java:1060)
        at net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:913)
        at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:242)
        at net.sourceforge.squirrel_sql.client.Main.doApplicationStartup(Main.java:123)
        at net.sourceforge.squirrel_sql.client.Main.lambda$startApp$0(Main.java:115)
        at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
        at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
        at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
        at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
        at java.base/java.security.AccessController.doPrivileged(Native Method)
        at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
        at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
        at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:103)
        at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.fasterxml.jackson.databind.JsonMappingException: No content to map due to end-of-input
at [Source: java.io.InputStreamReader@248af7cf<mailto:java.io.InputStreamReader@248af7cf>; line: 1, column: 1]
        at com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:148)
        at com.fasterxml.jackson.databind.ObjectMapper._initForReading(ObjectMapper.java:3781)
        at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:3721)
        at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2787)
        at net.sourceforge.squirrel_sql.fw.util.JsonMarshalUtil.readObjectFromFile(JsonMarshalUtil.java:48)
        ... 20 more

Gregory J Blajian
gjb...@ho...<mailto:gjb...@ho...>





_______________________________________________

Squirrel-sql-users mailing list

Squ...@li...<mailto:Squ...@li...>

https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Issue launching squirrel client

[Roger H. <rh...@hi...>]

Hi.


If the error is common across 3 applications, then I guess it is not a 
Squirrel problem.


Maybe try re-installing Java?


What changed between the time it worked, and when it stopped working?


Regards

Roger

On 18/05/2023 09:02, Greg Blajian wrote:
>
> I have been using squirrel for many years. Normally, I can figure out 
> any issues on my own but it seems I have a corrupt file somewhere and 
> the stack trace is not helping. I am getting the below error when I 
> attempt to launch the application. I have downloaded a fresh copy the 
> latest stable build 4.5.1 and installed it in different locations 
> (both the zip and the installer). I have tried Amazon Corretto 
> [C:\Program Files\Amazon Corretto\jdk11.0.19_7\bin] and Eclipse 
> Adoptium [C:\Program Files\Eclipse Adoptium\jdk-11.0.19.7-hotspot\bin] 
> but EVERY instance has the same error. The splash screen starts gets 
> about ¾ through then gives me this error. If I had any idea what file 
> it is trying to read and failing at I would fix it. Please help.
>
> $ java -jar squirrel-sql.jar
>
> java.lang.RuntimeException: 
> com.fasterxml.jackson.databind.JsonMappingException: No content to map 
> due to end-of-input
>
> at [Source: java.io.InputStreamReader@248af7cf; line: 1, column: 1]
>
>         at 
> net.sourceforge.squirrel_sql.fw.util.Utilities.wrapRuntime(Utilities.java:449)
>
>         at 
> net.sourceforge.squirrel_sql.fw.util.JsonMarshalUtil.readObjectFromFile(JsonMarshalUtil.java:52)
>
>         at 
> net.sourceforge.squirrel_sql.client.gui.recentfiles.RecentFilesManager.initJSonBean(RecentFilesManager.java:89)
>
>         at 
> net.sourceforge.squirrel_sql.client.Application.loadRecentFileHistory(Application.java:1060)
>
>         at 
> net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:913)
>
>         at 
> net.sourceforge.squirrel_sql.client.Application.startup(Application.java:242)
>
>         at 
> net.sourceforge.squirrel_sql.client.Main.doApplicationStartup(Main.java:123)
>
>         at 
> net.sourceforge.squirrel_sql.client.Main.lambda$startApp$0(Main.java:115)
>
>         at 
> java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
>
>         at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown 
> Source)
>
>         at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
>
>         at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
>
>         at 
> java.base/java.security.AccessController.doPrivileged(Native Method)
>
>         at 
> java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown 
> Source)
>
>         at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
>
>         at 
> net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:103)
>
>         at 
> java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown 
> Source)
>
>         at 
> java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown 
> Source)
>
>         at 
> java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown 
> Source)
>
>         at 
> java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>
>         at 
> java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>
>         at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
>
> Caused by: com.fasterxml.jackson.databind.JsonMappingException: No 
> content to map due to end-of-input
>
> at [Source: java.io.InputStreamReader@248af7cf; line: 1, column: 1]
>
>         at 
> com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:148)
>
>         at 
> com.fasterxml.jackson.databind.ObjectMapper._initForReading(ObjectMapper.java:3781)
>
>         at 
> com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:3721)
>
>         at 
> com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2787)
>
>         at 
> net.sourceforge.squirrel_sql.fw.util.JsonMarshalUtil.readObjectFromFile(JsonMarshalUtil.java:48)
>
>         ... 20 more
>
> Gregory J Blajian
>
> gjb...@ho...
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Issue launching squirrel client

[Greg B. <gjb...@ho...>]

I have been using squirrel for many years. Normally, I can figure out any issues on my own but it seems I have a corrupt file somewhere and the stack trace is not helping. I am getting the below error when I attempt to launch the application. I have downloaded a fresh copy the latest stable build 4.5.1 and installed it in different locations (both the zip and the installer). I have tried Amazon Corretto [C:\Program Files\Amazon Corretto\jdk11.0.19_7\bin] and Eclipse Adoptium [C:\Program Files\Eclipse Adoptium\jdk-11.0.19.7-hotspot\bin] but EVERY instance has the same error. The splash screen starts gets about ¾ through then gives me this error. If I had any idea what file it is trying to read and failing at I would fix it. Please help.

$ java -jar squirrel-sql.jar
java.lang.RuntimeException: com.fasterxml.jackson.databind.JsonMappingException: No content to map due to end-of-input
at [Source: java.io.InputStreamReader@248af7cf<mailto:java.io.InputStreamReader@248af7cf>; line: 1, column: 1]
        at net.sourceforge.squirrel_sql.fw.util.Utilities.wrapRuntime(Utilities.java:449)
        at net.sourceforge.squirrel_sql.fw.util.JsonMarshalUtil.readObjectFromFile(JsonMarshalUtil.java:52)
        at net.sourceforge.squirrel_sql.client.gui.recentfiles.RecentFilesManager.initJSonBean(RecentFilesManager.java:89)
        at net.sourceforge.squirrel_sql.client.Application.loadRecentFileHistory(Application.java:1060)
        at net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:913)
        at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:242)
        at net.sourceforge.squirrel_sql.client.Main.doApplicationStartup(Main.java:123)
        at net.sourceforge.squirrel_sql.client.Main.lambda$startApp$0(Main.java:115)
        at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
        at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
        at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
        at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
        at java.base/java.security.AccessController.doPrivileged(Native Method)
        at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
        at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
        at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:103)
        at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.fasterxml.jackson.databind.JsonMappingException: No content to map due to end-of-input
at [Source: java.io.InputStreamReader@248af7cf<mailto:java.io.InputStreamReader@248af7cf>; line: 1, column: 1]
        at com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:148)
        at com.fasterxml.jackson.databind.ObjectMapper._initForReading(ObjectMapper.java:3781)
        at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:3721)
        at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2787)
        at net.sourceforge.squirrel_sql.fw.util.JsonMarshalUtil.readObjectFromFile(JsonMarshalUtil.java:48)
        ... 20 more

Gregory J Blajian
gjb...@ho...

[Squirrel-sql-users] What is the latest Squirrel version which works with Java v8?

[Ben <bxs...@ya...>]

What is the latest Squirrel version which works with Java v8?

Re: [Squirrel-sql-users] Introduction

[info <in...@dr...>]

Which database server do you folks use? The connection info depends on it.

On 2023-05-02 03:48 PM, Knight, Parrish S. (Contractor) via 
Squirrel-sql-users wrote:
>
> Good afternoon:  I hope this is the correct email address to use; had 
> to make an educated guess based on what I was able to find in the 
> archives.
>
> I am an IT Specialist with the National Science Foundation who is 
> attempting to provide some support for a first-time Squirrel user 
> under macOS.  He is unclear as to what he needs to do to get his new 
> Squirrel installation connected to the databases that he needs to 
> use.  I am not a database/SQL person, myself, so I don’t really have 
> the background to assist him.  I told him I’d get on this list to see 
> whether I could find any assistance for him.
>
> *--*
>
> *Parrish S. Knight (CONTRACTOR)* |**IT Specialist – Directorate for 
> Mathematical and Physical Sciences – National Science Foundation
>
> psk...@as... <mailto:psk...@as...> | o. 
> +1.703.292.7381 |
>
>
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Introduction

[Roger H. <rh...@hi...>]

Hi.
Assuming Squirrel is up and running...

Locate the JDBC drivers for the databases in use, download them locally, and in the Drivers tab on the left of the main Squirrel pane, install them so that there is a tick mark against the ones he needs.

Then using the aliases tab, add connections to each database in turn. He will need the JDBC connection string (the drivers should provide the example) and his user id and password.

To use an alias/connection, highlight alias and click connect. There is a 'test' option on the connection pane.

Once you have the alias set up and working, click on save preferences in the File menu to save the setup.

That should get him started.

Regards
Roger

⁣Get BlueMail for Android ​

On 2 May 2023, 16:23, at 16:23, "Knight, Parrish S. (Contractor) via Squirrel-sql-users" <squ...@li...> wrote:
>Good afternoon:  I hope this is the correct email address to use; had
>to make an educated guess based on what I was able to find in the
>archives.
>
>I am an IT Specialist with the National Science Foundation who is
>attempting to provide some support for a first-time Squirrel user under
>macOS.  He is unclear as to what he needs to do to get his new Squirrel
>installation connected to the databases that he needs to use.  I am not
>a database/SQL person, myself, so I don’t really have the background to
>assist him.  I told him I’d get on this list to see whether I could
>find any assistance for him.
>
>--
>Parrish S. Knight (CONTRACTOR) | IT Specialist – Directorate for
>Mathematical and Physical Sciences – National Science Foundation
>psk...@as...<mailto:psk...@as...> | o.
>+1.703.292.7381 |
>
>
>
>------------------------------------------------------------------------
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Squirrel-sql-users mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Introduction

[Knight, P. S. (Contractor) <psk...@as...>]

Good afternoon:  I hope this is the correct email address to use; had to make an educated guess based on what I was able to find in the archives.

I am an IT Specialist with the National Science Foundation who is attempting to provide some support for a first-time Squirrel user under macOS.  He is unclear as to what he needs to do to get his new Squirrel installation connected to the databases that he needs to use.  I am not a database/SQL person, myself, so I don’t really have the background to assist him.  I told him I’d get on this list to see whether I could find any assistance for him.

--
Parrish S. Knight (CONTRACTOR) | IT Specialist – Directorate for Mathematical and Physical Sciences – National Science Foundation
psk...@as...<mailto:psk...@as...> | o. +1.703.292.7381 |

Re: [Squirrel-sql-users] Install on Fedora 37 - OpenJDK

[Michele M. <m.m...@gm...>]

Hi Gerd,

thanks for your help.
I have reinstalled Java-17 and the installation process worked.

Kind regards,
Michele

On Sat, 11 Feb 2023 at 22:17, Gerd Wagner <ger...@t-...> wrote:

> The error message looks like your Java installation is broken.
> The Java VM should be able to load libawt_xawt.so.
>
> For a first check you may see if libawt_xawt.so exists. If not your Java
> installation is broken for sure.
>
> Gerd
>
> Am 11.02.23 um 11:03 schrieb Michele Mor:
> > Hi,
> > I have downloaded squirrel-sql-4.5.1-standard.jar and tried to install
> > on Fedora 37.
> > The Java version is:
> > openjdk version "17.0.6" 2023-01-17
> > OpenJDK Runtime Environment (Red_Hat-17.0.6.0.10-1.fc37) (build
> 17.0.6+10)
> > OpenJDK 64-Bit Server VM (Red_Hat-17.0.6.0.10-1.fc37) (build 17.0.6+10,
> > mixed mode, sharing)
> >
> > When I execute the command: java -jar squirrel-sql-4.5.1-standard.jar
> > I have the following error:
> > Command line arguments:
> > Exception in thread "main" java.lang.UnsatisfiedLinkError: Can't load
> > library:
> > /usr/lib/jvm/java-17-openjdk-17.0.6.0.10-1.fc37.x86_64/lib/libawt_xawt.so
> > at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2393)
> > at java.base/java.lang.Runtime.load0(Runtime.java:755)
> > at java.base/java.lang.System.load(System.java:1953)
> > at java.base/jdk.internal.loader.NativeLibraries.load(Native Method)
> > at
> >
> java.base/jdk.internal.loader.NativeLibraries$NativeLibraryImpl.open(NativeLibraries.java:388)
> > at
> >
> java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:232)
> > at
> >
> java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:174)
> > at
> >
> java.base/jdk.internal.loader.NativeLibraries.findFromPaths(NativeLibraries.java:315)
> > at
> >
> java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:285)
> > at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2398)
> > at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:818)
> > at java.base/java.lang.System.loadLibrary(System.java:1989)
> > at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1392)
> > at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1390)
> > at
> >
> java.base/java.security.AccessController.doPrivileged(AccessController.java:318)
> > at java.desktop/java.awt.Toolkit.loadLibraries(Toolkit.java:1389)
> > at java.desktop/java.awt.Toolkit.initStatic(Toolkit.java:1427)
> > at java.desktop/java.awt.Toolkit.<clinit>(Toolkit.java:1401)
> > at java.desktop/java.awt.Color.<clinit>(Color.java:277)
> > at
> >
> com.izforge.izpack.installer.data.GUIInstallData.<init>(GUIInstallData.java:54)
> > at
> >
> com.izforge.izpack.installer.container.provider.GUIInstallDataProvider.provide(GUIInstallDataProvider.java:86)
> > at
> > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
> > Method)
> > at
> >
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
> > at
> >
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.base/java.lang.reflect.Method.invoke(Method.java:568)
> > at
> >
> org.picocontainer.injectors.MethodInjector.invokeMethod(MethodInjector.java:129)
> > at
> >
> org.picocontainer.injectors.MethodInjector.access$000(MethodInjector.java:39)
> > at
> org.picocontainer.injectors.MethodInjector$2.run(MethodInjector.java:113)
> > at
> >
> org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
> > at
> >
> org.picocontainer.injectors.MethodInjector.decorateComponentInstance(MethodInjector.java:120)
> > at
> >
> org.picocontainer.injectors.CompositeInjector.decorateComponentInstance(CompositeInjector.java:58)
> > at org.picocontainer.injectors.Reinjector.reinject(Reinjector.java:142)
> > at
> >
> org.picocontainer.injectors.ProviderAdapter.getComponentInstance(ProviderAdapter.java:96)
> > at
> >
> org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
> > at
> org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
> > at
> >
> org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:699)
> > at
> >
> org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:647)
> > at
> >
> org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:678)
> > at
> >
> com.izforge.izpack.installer.container.impl.InstallerContainer.resolveComponents(InstallerContainer.java:139)
> > at
> >
> com.izforge.izpack.installer.container.impl.GUIInstallerContainer.resolveComponents(GUIInstallerContainer.java:88)
> > at
> >
> com.izforge.izpack.installer.container.impl.InstallerContainer.fillContainer(InstallerContainer.java:80)
> > at
> >
> com.izforge.izpack.core.container.AbstractContainer.initialise(AbstractContainer.java:304)
> > at
> >
> com.izforge.izpack.core.container.AbstractContainer.initialise(AbstractContainer.java:284)
> > at
> >
> com.izforge.izpack.installer.container.impl.GUIInstallerContainer.<init>(GUIInstallerContainer.java:38)
> > at
> >
> com.izforge.izpack.installer.bootstrap.InstallerGui.run(InstallerGui.java:54)
> > at
> >
> com.izforge.izpack.installer.bootstrap.Installer.launchInstall(Installer.java:294)
> > at
> >
> com.izforge.izpack.installer.bootstrap.Installer.start(Installer.java:238)
> > at
> com.izforge.izpack.installer.bootstrap.Installer.main(Installer.java:78)
> >
> > Do I have to install a different version of Java?
> > Or is there a bug with Squirrel?
> >
> > Thanks,
> > Michele
> >
> >
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Install on Fedora 37 - OpenJDK

[Gerd W. <ger...@t-...>]

The error message looks like your Java installation is broken.
The Java VM should be able to load libawt_xawt.so.

For a first check you may see if libawt_xawt.so exists. If not your Java 
installation is broken for sure.

Gerd

Am 11.02.23 um 11:03 schrieb Michele Mor:
> Hi,
> I have downloaded squirrel-sql-4.5.1-standard.jar and tried to install 
> on Fedora 37.
> The Java version is:
> openjdk version "17.0.6" 2023-01-17
> OpenJDK Runtime Environment (Red_Hat-17.0.6.0.10-1.fc37) (build 17.0.6+10)
> OpenJDK 64-Bit Server VM (Red_Hat-17.0.6.0.10-1.fc37) (build 17.0.6+10, 
> mixed mode, sharing)
> 
> When I execute the command: java -jar squirrel-sql-4.5.1-standard.jar
> I have the following error:
> Command line arguments:
> Exception in thread "main" java.lang.UnsatisfiedLinkError: Can't load 
> library: 
> /usr/lib/jvm/java-17-openjdk-17.0.6.0.10-1.fc37.x86_64/lib/libawt_xawt.so
> at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2393)
> at java.base/java.lang.Runtime.load0(Runtime.java:755)
> at java.base/java.lang.System.load(System.java:1953)
> at java.base/jdk.internal.loader.NativeLibraries.load(Native Method)
> at 
> java.base/jdk.internal.loader.NativeLibraries$NativeLibraryImpl.open(NativeLibraries.java:388)
> at 
> java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:232)
> at 
> java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:174)
> at 
> java.base/jdk.internal.loader.NativeLibraries.findFromPaths(NativeLibraries.java:315)
> at 
> java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:285)
> at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2398)
> at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:818)
> at java.base/java.lang.System.loadLibrary(System.java:1989)
> at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1392)
> at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1390)
> at 
> java.base/java.security.AccessController.doPrivileged(AccessController.java:318)
> at java.desktop/java.awt.Toolkit.loadLibraries(Toolkit.java:1389)
> at java.desktop/java.awt.Toolkit.initStatic(Toolkit.java:1427)
> at java.desktop/java.awt.Toolkit.<clinit>(Toolkit.java:1401)
> at java.desktop/java.awt.Color.<clinit>(Color.java:277)
> at 
> com.izforge.izpack.installer.data.GUIInstallData.<init>(GUIInstallData.java:54)
> at 
> com.izforge.izpack.installer.container.provider.GUIInstallDataProvider.provide(GUIInstallDataProvider.java:86)
> at 
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native 
> Method)
> at 
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
> at 
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:568)
> at 
> org.picocontainer.injectors.MethodInjector.invokeMethod(MethodInjector.java:129)
> at 
> org.picocontainer.injectors.MethodInjector.access$000(MethodInjector.java:39)
> at org.picocontainer.injectors.MethodInjector$2.run(MethodInjector.java:113)
> at 
> org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
> at 
> org.picocontainer.injectors.MethodInjector.decorateComponentInstance(MethodInjector.java:120)
> at 
> org.picocontainer.injectors.CompositeInjector.decorateComponentInstance(CompositeInjector.java:58)
> at org.picocontainer.injectors.Reinjector.reinject(Reinjector.java:142)
> at 
> org.picocontainer.injectors.ProviderAdapter.getComponentInstance(ProviderAdapter.java:96)
> at 
> org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
> at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
> at 
> org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:699)
> at 
> org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:647)
> at 
> org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:678)
> at 
> com.izforge.izpack.installer.container.impl.InstallerContainer.resolveComponents(InstallerContainer.java:139)
> at 
> com.izforge.izpack.installer.container.impl.GUIInstallerContainer.resolveComponents(GUIInstallerContainer.java:88)
> at 
> com.izforge.izpack.installer.container.impl.InstallerContainer.fillContainer(InstallerContainer.java:80)
> at 
> com.izforge.izpack.core.container.AbstractContainer.initialise(AbstractContainer.java:304)
> at 
> com.izforge.izpack.core.container.AbstractContainer.initialise(AbstractContainer.java:284)
> at 
> com.izforge.izpack.installer.container.impl.GUIInstallerContainer.<init>(GUIInstallerContainer.java:38)
> at 
> com.izforge.izpack.installer.bootstrap.InstallerGui.run(InstallerGui.java:54)
> at 
> com.izforge.izpack.installer.bootstrap.Installer.launchInstall(Installer.java:294)
> at 
> com.izforge.izpack.installer.bootstrap.Installer.start(Installer.java:238)
> at com.izforge.izpack.installer.bootstrap.Installer.main(Installer.java:78)
> 
> Do I have to install a different version of Java?
> Or is there a bug with Squirrel?
> 
> Thanks,
> Michele
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Install on Fedora 37 - OpenJDK

[Michele M. <m.m...@gm...>]

Hi,
I have downloaded squirrel-sql-4.5.1-standard.jar and tried to install on
Fedora 37.
The Java version is:
openjdk version "17.0.6" 2023-01-17
OpenJDK Runtime Environment (Red_Hat-17.0.6.0.10-1.fc37) (build 17.0.6+10)
OpenJDK 64-Bit Server VM (Red_Hat-17.0.6.0.10-1.fc37) (build 17.0.6+10,
mixed mode, sharing)

When I execute the command: java -jar squirrel-sql-4.5.1-standard.jar
I have the following error:
Command line arguments:
Exception in thread "main" java.lang.UnsatisfiedLinkError: Can't load
library:
/usr/lib/jvm/java-17-openjdk-17.0.6.0.10-1.fc37.x86_64/lib/libawt_xawt.so
at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2393)
at java.base/java.lang.Runtime.load0(Runtime.java:755)
at java.base/java.lang.System.load(System.java:1953)
at java.base/jdk.internal.loader.NativeLibraries.load(Native Method)
at
java.base/jdk.internal.loader.NativeLibraries$NativeLibraryImpl.open(NativeLibraries.java:388)
at
java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:232)
at
java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:174)
at
java.base/jdk.internal.loader.NativeLibraries.findFromPaths(NativeLibraries.java:315)
at
java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:285)
at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2398)
at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:818)
at java.base/java.lang.System.loadLibrary(System.java:1989)
at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1392)
at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1390)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:318)
at java.desktop/java.awt.Toolkit.loadLibraries(Toolkit.java:1389)
at java.desktop/java.awt.Toolkit.initStatic(Toolkit.java:1427)
at java.desktop/java.awt.Toolkit.<clinit>(Toolkit.java:1401)
at java.desktop/java.awt.Color.<clinit>(Color.java:277)
at
com.izforge.izpack.installer.data.GUIInstallData.<init>(GUIInstallData.java:54)
at
com.izforge.izpack.installer.container.provider.GUIInstallDataProvider.provide(GUIInstallDataProvider.java:86)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at
org.picocontainer.injectors.MethodInjector.invokeMethod(MethodInjector.java:129)
at
org.picocontainer.injectors.MethodInjector.access$000(MethodInjector.java:39)
at org.picocontainer.injectors.MethodInjector$2.run(MethodInjector.java:113)
at
org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
at
org.picocontainer.injectors.MethodInjector.decorateComponentInstance(MethodInjector.java:120)
at
org.picocontainer.injectors.CompositeInjector.decorateComponentInstance(CompositeInjector.java:58)
at org.picocontainer.injectors.Reinjector.reinject(Reinjector.java:142)
at
org.picocontainer.injectors.ProviderAdapter.getComponentInstance(ProviderAdapter.java:96)
at
org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
at
org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:699)
at
org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:647)
at
org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:678)
at
com.izforge.izpack.installer.container.impl.InstallerContainer.resolveComponents(InstallerContainer.java:139)
at
com.izforge.izpack.installer.container.impl.GUIInstallerContainer.resolveComponents(GUIInstallerContainer.java:88)
at
com.izforge.izpack.installer.container.impl.InstallerContainer.fillContainer(InstallerContainer.java:80)
at
com.izforge.izpack.core.container.AbstractContainer.initialise(AbstractContainer.java:304)
at
com.izforge.izpack.core.container.AbstractContainer.initialise(AbstractContainer.java:284)
at
com.izforge.izpack.installer.container.impl.GUIInstallerContainer.<init>(GUIInstallerContainer.java:38)
at
com.izforge.izpack.installer.bootstrap.InstallerGui.run(InstallerGui.java:54)
at
com.izforge.izpack.installer.bootstrap.Installer.launchInstall(Installer.java:294)
at
com.izforge.izpack.installer.bootstrap.Installer.start(Installer.java:238)
at com.izforge.izpack.installer.bootstrap.Installer.main(Installer.java:78)

Do I have to install a different version of Java?
Or is there a bug with Squirrel?

Thanks,
Michele

Re: [Squirrel-sql-users] Can't open second session

[Brian <bri...@br...>]

That -D option works.



Get TypeApp for Android



On Feb 5, 2023, 11:05 AM, at 11:05 AM, Gerd Wagner <ger...@t-...> wrote:
>Sorry, I can't reproduce your problem.
>
>Judging from your stack trace it looks like a JDK/JRE problem.
>Did you download your JDK/JRE from here: https://adoptium.net/
>
>Another thing you may try is setting the JVM parameter
>-Djava.util.Arrays.useLegacyMergeSort=true
>
>Gerd
>
>
>Am 03.02.23 um 18:07 schrieb Brian:
>> Something changed a few days ago. Now I can open a first session just
>
>> fine. But if I open a second session tab, (no matter which aliases I 
>> pick for first or second,) it says "Error opening session"
>> 
>> I have also tried changing the OpenJDK version. Currently using 19.
>> 
>> 
>> 
>> 
>> 
>> 
>> Error opening session
>> 
>> java.lang.IllegalArgumentException: Comparison method violates its 
>> general contract!
>> at
>java.base/java.util.ComparableTimSort.mergeHi(ComparableTimSort.java:870)
>> at
>java.base/java.util.ComparableTimSort.mergeAt(ComparableTimSort.java:487)
>> at 
>>
>java.base/java.util.ComparableTimSort.mergeCollapse(ComparableTimSort.java:413)
>> at
>java.base/java.util.ComparableTimSort.sort(ComparableTimSort.java:213)
>> at java.base/java.util.Arrays.sort(Arrays.java:1041)
>> at 
>>
>java.desktop/sun.awt.shell.Win32ShellFolderManager2.get(Win32ShellFolderManager2.java:315)
>> at java.desktop/sun.awt.shell.ShellFolder.get(ShellFolder.java:274)
>> at 
>>
>java.desktop/javax.swing.plaf.metal.MetalFileChooserUI$DirectoryComboBoxModel.addItem(MetalFileChooserUI.java:1031)
>> at 
>>
>java.desktop/javax.swing.plaf.metal.MetalFileChooserUI.doDirectoryChanged(MetalFileChooserUI.java:719)
>> at 
>>
>java.desktop/javax.swing.plaf.metal.MetalFileChooserUI$5.propertyChange(MetalFileChooserUI.java:808)
>> at 
>>
>java.desktop/java.beans.PropertyChangeSupport.fire(PropertyChangeSupport.java:343)
>> at 
>>
>java.desktop/java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:335)
>> at 
>>
>java.desktop/java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:268)
>> at
>java.desktop/java.awt.Component.firePropertyChange(Component.java:8716)
>> at 
>>
>java.desktop/javax.swing.JFileChooser.setCurrentDirectory(JFileChooser.java:610)
>> at
>java.desktop/javax.swing.JFileChooser.<init>(JFileChooser.java:364)
>> at
>java.desktop/javax.swing.JFileChooser.<init>(JFileChooser.java:310)
>> at 
>>
>net.sourceforge.squirrel_sql.client.session.filemanager.FileChooserManager.initNewFileChooser(FileChooserManager.java:44)
>> at 
>>
>net.sourceforge.squirrel_sql.client.session.filemanager.FileChooserManager.<init>(FileChooserManager.java:34)
>> at 
>>
>net.sourceforge.squirrel_sql.client.session.filemanager.FileManagementCore.<init>(FileManagementCore.java:39)
>> at 
>>
>net.sourceforge.squirrel_sql.client.session.filemanager.FileHandler.<init>(FileHandler.java:36)
>> at 
>>
>net.sourceforge.squirrel_sql.client.session.SQLPanelAPI.<init>(SQLPanelAPI.java:86)
>> at 
>>
>net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.<init>(SQLPanel.java:161)
>> at 
>>
>net.sourceforge.squirrel_sql.client.session.mainpanel.sqltab.SQLTab.createSqlPanel(SQLTab.java:26)
>> at 
>>
>net.sourceforge.squirrel_sql.client.session.mainpanel.sqltab.BaseSQLTab.getComponent(BaseSQLTab.java:59)
>> at 
>>
>net.sourceforge.squirrel_sql.client.gui.session.MainPanel.addMainPanelTab(MainPanel.java:177)
>> at 
>>
>net.sourceforge.squirrel_sql.client.gui.session.MainPanel.<init>(MainPanel.java:98)
>> at 
>>
>net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.createGUI(SessionPanel.java:255)
>> at 
>>
>net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.initialize(SessionPanel.java:120)
>> at 
>>
>net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.createGUI(SessionInternalFrame.java:118)
>> at 
>>
>net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.<init>(SessionInternalFrame.java:52)
>> at 
>>
>net.sourceforge.squirrel_sql.client.gui.WindowManager.createInternalFrame(WindowManager.java:337)
>> at 
>>
>net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:362)
>> at 
>>
>java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:318)
>> at
>java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773)
>> at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:720)
>> at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:714)
>> at 
>>
>java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
>> at 
>>
>java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
>> at
>java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
>> at
>net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:103)
>> at 
>>
>java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
>> at 
>>
>java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
>> at 
>>
>java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
>> at 
>>
>java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
>> at 
>>
>java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
>> at 
>>
>java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
>> 
>> 
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Can't open second session

[Gerd W. <ger...@t-...>]

Sorry, I can't reproduce your problem.

Judging from your stack trace it looks like a JDK/JRE problem.
Did you download your JDK/JRE from here: https://adoptium.net/

Another thing you may try is setting the JVM parameter
-Djava.util.Arrays.useLegacyMergeSort=true

Gerd


Am 03.02.23 um 18:07 schrieb Brian:
> Something changed a few days ago. Now I can open a first session just 
> fine. But if I open a second session tab, (no matter which aliases I 
> pick for first or second,) it says "Error opening session"
> 
> I have also tried changing the OpenJDK version. Currently using 19.
> 
> 
> 
> 
> 
> 
> Error opening session
> 
> java.lang.IllegalArgumentException: Comparison method violates its 
> general contract!
> at java.base/java.util.ComparableTimSort.mergeHi(ComparableTimSort.java:870)
> at java.base/java.util.ComparableTimSort.mergeAt(ComparableTimSort.java:487)
> at 
> java.base/java.util.ComparableTimSort.mergeCollapse(ComparableTimSort.java:413)
> at java.base/java.util.ComparableTimSort.sort(ComparableTimSort.java:213)
> at java.base/java.util.Arrays.sort(Arrays.java:1041)
> at 
> java.desktop/sun.awt.shell.Win32ShellFolderManager2.get(Win32ShellFolderManager2.java:315)
> at java.desktop/sun.awt.shell.ShellFolder.get(ShellFolder.java:274)
> at 
> java.desktop/javax.swing.plaf.metal.MetalFileChooserUI$DirectoryComboBoxModel.addItem(MetalFileChooserUI.java:1031)
> at 
> java.desktop/javax.swing.plaf.metal.MetalFileChooserUI.doDirectoryChanged(MetalFileChooserUI.java:719)
> at 
> java.desktop/javax.swing.plaf.metal.MetalFileChooserUI$5.propertyChange(MetalFileChooserUI.java:808)
> at 
> java.desktop/java.beans.PropertyChangeSupport.fire(PropertyChangeSupport.java:343)
> at 
> java.desktop/java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:335)
> at 
> java.desktop/java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:268)
> at java.desktop/java.awt.Component.firePropertyChange(Component.java:8716)
> at 
> java.desktop/javax.swing.JFileChooser.setCurrentDirectory(JFileChooser.java:610)
> at java.desktop/javax.swing.JFileChooser.<init>(JFileChooser.java:364)
> at java.desktop/javax.swing.JFileChooser.<init>(JFileChooser.java:310)
> at 
> net.sourceforge.squirrel_sql.client.session.filemanager.FileChooserManager.initNewFileChooser(FileChooserManager.java:44)
> at 
> net.sourceforge.squirrel_sql.client.session.filemanager.FileChooserManager.<init>(FileChooserManager.java:34)
> at 
> net.sourceforge.squirrel_sql.client.session.filemanager.FileManagementCore.<init>(FileManagementCore.java:39)
> at 
> net.sourceforge.squirrel_sql.client.session.filemanager.FileHandler.<init>(FileHandler.java:36)
> at 
> net.sourceforge.squirrel_sql.client.session.SQLPanelAPI.<init>(SQLPanelAPI.java:86)
> at 
> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.<init>(SQLPanel.java:161)
> at 
> net.sourceforge.squirrel_sql.client.session.mainpanel.sqltab.SQLTab.createSqlPanel(SQLTab.java:26)
> at 
> net.sourceforge.squirrel_sql.client.session.mainpanel.sqltab.BaseSQLTab.getComponent(BaseSQLTab.java:59)
> at 
> net.sourceforge.squirrel_sql.client.gui.session.MainPanel.addMainPanelTab(MainPanel.java:177)
> at 
> net.sourceforge.squirrel_sql.client.gui.session.MainPanel.<init>(MainPanel.java:98)
> at 
> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.createGUI(SessionPanel.java:255)
> at 
> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.initialize(SessionPanel.java:120)
> at 
> net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.createGUI(SessionInternalFrame.java:118)
> at 
> net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.<init>(SessionInternalFrame.java:52)
> at 
> net.sourceforge.squirrel_sql.client.gui.WindowManager.createInternalFrame(WindowManager.java:337)
> at 
> net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:362)
> at 
> java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:318)
> at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773)
> at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:720)
> at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:714)
> at 
> java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
> at 
> java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
> at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
> at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:103)
> at 
> java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
> at 
> java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
> at 
> java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
> at 
> java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
> at 
> java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
> at 
> java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Can't open second session

[Brian <bri...@br...>]

Something changed a few days ago. Now I can open a first session just fine. But if I open a second session tab, (no matter which aliases I pick for first or second,) it says "Error opening session"

I have also tried changing the OpenJDK version. Currently using 19.






Error opening session

java.lang.IllegalArgumentException: Comparison method violates its general contract!

at java.base/java.util.ComparableTimSort.mergeHi(ComparableTimSort.java:870)

at java.base/java.util.ComparableTimSort.mergeAt(ComparableTimSort.java:487)

at java.base/java.util.ComparableTimSort.mergeCollapse(ComparableTimSort.java:413)

at java.base/java.util.ComparableTimSort.sort(ComparableTimSort.java:213)

at java.base/java.util.Arrays.sort(Arrays.java:1041)

at java.desktop/sun.awt.shell.Win32ShellFolderManager2.get(Win32ShellFolderManager2.java:315)

at java.desktop/sun.awt.shell.ShellFolder.get(ShellFolder.java:274)

at java.desktop/javax.swing.plaf.metal.MetalFileChooserUI$DirectoryComboBoxModel.addItem(MetalFileChooserUI.java:1031)

at java.desktop/javax.swing.plaf.metal.MetalFileChooserUI.doDirectoryChanged(MetalFileChooserUI.java:719)

at java.desktop/javax.swing.plaf.metal.MetalFileChooserUI$5.propertyChange(MetalFileChooserUI.java:808)

at java.desktop/java.beans.PropertyChangeSupport.fire(PropertyChangeSupport.java:343)

at java.desktop/java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:335)

at java.desktop/java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:268)

at java.desktop/java.awt.Component.firePropertyChange(Component.java:8716)

at java.desktop/javax.swing.JFileChooser.setCurrentDirectory(JFileChooser.java:610)

at java.desktop/javax.swing.JFileChooser.<init>(JFileChooser.java:364)

at java.desktop/javax.swing.JFileChooser.<init>(JFileChooser.java:310)

at net.sourceforge.squirrel_sql.client.session.filemanager.FileChooserManager.initNewFileChooser(FileChooserManager.java:44)

at net.sourceforge.squirrel_sql.client.session.filemanager.FileChooserManager.<init>(FileChooserManager.java:34)

at net.sourceforge.squirrel_sql.client.session.filemanager.FileManagementCore.<init>(FileManagementCore.java:39)

at net.sourceforge.squirrel_sql.client.session.filemanager.FileHandler.<init>(FileHandler.java:36)

at net.sourceforge.squirrel_sql.client.session.SQLPanelAPI.<init>(SQLPanelAPI.java:86)

at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.<init>(SQLPanel.java:161)

at net.sourceforge.squirrel_sql.client.session.mainpanel.sqltab.SQLTab.createSqlPanel(SQLTab.java:26)

at net.sourceforge.squirrel_sql.client.session.mainpanel.sqltab.BaseSQLTab.getComponent(BaseSQLTab.java:59)

at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.addMainPanelTab(MainPanel.java:177)

at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.<init>(MainPanel.java:98)

at net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.createGUI(SessionPanel.java:255)

at net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.initialize(SessionPanel.java:120)

at net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.createGUI(SessionInternalFrame.java:118)

at net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.<init>(SessionInternalFrame.java:52)

at net.sourceforge.squirrel_sql.client.gui.WindowManager.createInternalFrame(WindowManager.java:337)

at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:362)

at java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:318)

at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773)

at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:720)

at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:714)

at java.base/java.security.AccessController.doPrivileged(AccessController.java:399)

at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)

at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)

at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:103)

at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)

at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)

at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)

at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)

at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Re: [Squirrel-sql-users] Squirrel 4.5.1 not loading blob/clob contents?

[Gerd W. <ger...@t-...>]

Ivo,

this issue required some restructuring of the BLOB and CLOB loading 
configurations. Here's the excerpt from our change log on the changes:

Data types BLOB and CLOB loading configuration was restructured and fixed.
   Both data types now offer the following loading options:
    - Read contents when table is first loaded (offers to limit the 
amount of data to read)
    - Read contents when table cell becomes visible
    - Read contents when table cell is focused
    - Do not read contents
   See menu File --> Global Preferences --> tab "Data Type Controls" --> 
sections BLOB and CLOB


The first snapshot that contains these changes is available here
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20230121_0057/

or here
https://github.com/squirrel-sql-client/squirrel-sql-snapshot-releases/releases/tag/snapshot-20230121_0057


Please give it a try.

Gerd




Am 11.01.23 um 14:21 schrieb Ivo Krab:
> Hi,
> 
> Don't know if this is a bug or a config problem in my setup. I recently 
> installed 4.5.1 next to the 4.0.0 I'd been using so far (with java 11 
> and adapted launch .bat to use the correct java), but I notice problems 
> with blob/clob columns. DB is Oracle 19c, driver ojdbc10.jar
> 
> When the "Data Type Controls" options "Read contents when table is first 
> loaded" is unchecked, the table shows just <blob> or <clob> (whereas 
> 4.0.0. would after display still load the actual contents as they scroll 
> into view in the table). However, double-clicking a cell to open it 
> keeps showing just that, instead of loading the actual contents as I 
> think it's supposed to do. Also I do not see any option to force-load 
> the contents manually.
> 
> When the option to pre-load is checked, the table shows for a clob for 
> example "<ns2:notifyEmployeeAttributionDecision xmlns:ns2="... (so a 
> truncated string to match the column width), but when I double-click to 
> open, it still shows the truncated string instead of the full contents! 
> Same with the bytes representation of a blob. Also remains truncated at 
> the intial column width of the table...
> 
> Any pointers as to what I might be doing wrong?
> 
> Kr.
> 
>      Ivo Krab
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Squirrel 4.5.1 not loading blob/clob contents?

[Ivo K. <evi...@gm...>]

Hi,

Don't know if this is a bug or a config problem in my setup. I recently
installed 4.5.1 next to the 4.0.0 I'd been using so far (with java 11 and
adapted launch .bat to use the correct java), but I notice problems with
blob/clob columns. DB is Oracle 19c, driver ojdbc10.jar

When the "Data Type Controls" options "Read contents when table is first
loaded" is unchecked, the table shows just <blob> or <clob> (whereas 4.0.0.
would after display still load the actual contents as they scroll into view
in the table). However, double-clicking a cell to open it keeps showing
just that, instead of loading the actual contents as I think it's supposed
to do. Also I do not see any option to force-load the contents manually.

When the option to pre-load is checked, the table shows for a clob for
example "<ns2:notifyEmployeeAttributionDecision xmlns:ns2="... (so a
truncated string to match the column width), but when I double-click to
open, it still shows the truncated string instead of the full contents!
Same with the bytes representation of a blob. Also remains truncated at the
intial column width of the table...

Any pointers as to what I might be doing wrong?

Kr.

    Ivo Krab

Re: [Squirrel-sql-users] Cannot connect to mysql

[Gerd W. <ger...@t-...>]

In case you know a bit of Java you may try to reproduce your error with 
the attached test class. If this works you should contact your DB-Admin.

Gerd

Am 09.10.22 um 13:25 schrieb Martin Röth via Squirrel-sql-users:
> Hi,
> 
> I am trying to connect to a mysql database from squirrel.
> 
> I installed squirrel sql client version 4.4.0 on a Windows 11 PC.
> 
> The mysql database (Maria DB 10) is running on a synology NAS System.
> 
> I retrieved the mysql-connector-java-8.0.30.jar and copied it into 
> squirrel lib folder .
> 
> Alias was set up with URL jdbc:mysql://DS220Plus:3306/clubman – instead 
> of hostname DS220Plus I also tried localhost and the exact IP address of 
> my Synology.
> 
> The rights for accessing the database (clubman) are setup within mysql 
> for the user account (that I used for connecting) as well as for the 
> host with all privileges.
> 
> I also tried with firewall deactivated.
> 
> Database is up and running and I am able to connect via phpMyAdmin.
> 
> But when I am trying to connect via squirrel I always get the message
> 
> „Unexpected Error occurred attempting to open an SQL connection.
> 
> class java.net.ConnectException: Connection refused: connect“
> 
> Here is the stack trace:
> 
> java.net.ConnectException: Connection refused: connect
> 
>              at java.base/java.net.PlainSocketImpl.waitForConnect(Native 
> Method)
> 
>              at 
> java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:107)
> 
>              at 
> java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
> 
>              at 
> java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
> 
>              at 
> java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
> 
>              at 
> java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
> 
>              at java.base/java.net.Socket.connect(Socket.java:591)
> 
>              at 
> com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
> 
>              at 
> com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
> 
>              at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
> 
>              at 
> com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)
> 
>              at 
> com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)
> 
>              at 
> com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
> 
>              at 
> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
> 
>              at 
> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
> 
>              at 
> net.sourceforge.squirrel_sql.fw.sql.SQLConnector.getSqlConnection(SQLConnector.java:58)
> 
>              at 
> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:110)
> 
>              at 
> net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:155)
> 
>              at 
> net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConnectionCommand.lambda$execute$0(OpenConnectionCommand.java:89)
> 
>              at 
> java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
> 
>              at 
> java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
> 
>              at 
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> 
>              at 
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> 
>              at java.base/java.lang.Thread.run(Thread.java:834)
> 
> Maybe I did something wrong? Maybe the wrong driver?
> 
> Thanks for help.
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] SquirreL installation instructions: jar file naming

[Gerd W. <ger...@t-...>]

Thanks for the pointer, Ralf.

Is corrected.

Gerd

Am 18.10.22 um 09:31 schrieb Pfiszter, Ralf:
> Hi,
> 
> I just found that on your homepage in the “installation” section the jar 
> file name is not mentioned correctly in every case:
> 
> The MacOS jar is named squirrel-sql-<version>-*install*.jar - that is 
> correct.
> 
> However, the downloadable Windows/Linux/others jar is (currently) named 
> squirrel-sql-<version>-*standard*.jar
> 
> Maybe this can be aligned somewhen? (Or the latter jar being renamed 
> accordingly…?)
> 
> In every case it is a great tool.
> 
> Mit freundlichen Grüßen / Best regards
> Dipl.-Ing. (BA) Ralf Pfiszter
> 
> ------------------------------------------------------------------------
> 
> *IT Services - Entwicklung
> Grazer Wechselseitige Versicherung AG*
> 
> Pestalozzistraße 73, 8010 Graz
> Tel.:     +43 316 908031 6602
> Fax:     +43 316 803796602
> Mail: Ral...@gr... <mailto:Ral...@gr...>
> Web: www.grawe.at <http://www.grawe.at>
> 
> FN 37748m, Landes- als Handelsgericht Graz
> 
> *Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail ausdrucken! *
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] SquirreL installation instructions: jar file naming

[Pfiszter, R. <Ral...@gr...>]

Hi,

I just found that on your homepage in the "installation" section the jar file name is not mentioned correctly in every case:
The MacOS jar is named squirrel-sql-<version>-install.jar - that is correct.
However, the downloadable Windows/Linux/others jar is (currently) named squirrel-sql-<version>-standard.jar

Maybe this can be aligned somewhen? (Or the latter jar being renamed accordingly...?)

In every case it is a great tool.

Mit freundlichen Grüßen / Best regards
Dipl.-Ing. (BA) Ralf Pfiszter
________________________________
IT Services - Entwicklung
Grazer Wechselseitige Versicherung AG
Pestalozzistraße 73, 8010 Graz
Tel.:     +43 316 908031 6602
Fax:     +43 316 803796602
Mail:     Ral...@gr...<mailto:Ral...@gr...>
Web:    www.grawe.at<http://www.grawe.at>

FN 37748m, Landes- als Handelsgericht Graz
Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail ausdrucken!

[Squirrel-sql-users] Cannot connect to mysql

[Martin R. <mro...@go...>]

Hi,

 

I am trying to connect to a mysql database from squirrel.

 

I installed squirrel sql client version 4.4.0 on a Windows 11 PC.

The mysql database (Maria DB 10) is running on a synology NAS System.

I retrieved the mysql-connector-java-8.0.30.jar and copied it into squirrel
lib folder .

Alias was set up with URL jdbc:mysql://DS220Plus:3306/clubman – instead of
hostname DS220Plus I also tried localhost and the exact IP address of my
Synology.

The rights for accessing the database (clubman) are setup within mysql for
the user account (that I used for connecting) as well as for the host with
all privileges.

I also tried with firewall deactivated.

Database is up and running and I am able to connect via phpMyAdmin.

But when I am trying to connect via squirrel I always get the message

„Unexpected Error occurred attempting to open an SQL connection.

class java.net.ConnectException: Connection refused: connect“

 

Here is the stack trace:

java.net.ConnectException: Connection refused: connect

            at java.base/java.net.PlainSocketImpl.waitForConnect(Native
Method)

            at
java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:107)

            at
java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl
.java:399)

            at
java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSoc
ketImpl.java:242)

            at
java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.j
ava:224)

            at
java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)

            at java.base/java.net.Socket.connect(Socket.java:591)

            at
com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.ja
va:153)

            at
com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnectio
n.java:63)

            at com.mysql.cj.NativeSession.connect(NativeSession.java:120)

            at
com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)

            at
com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)

            at
com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)

            at
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)

            at
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198
)

            at
net.sourceforge.squirrel_sql.fw.sql.SQLConnector.getSqlConnection(SQLConnect
or.java:58)

            at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriver
Manager.java:110)

            at
net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConn
ectionCommand.executeConnect(OpenConnectionCommand.java:155)

            at
net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConn
ectionCommand.lambda$execute$0(OpenConnectionCommand.java:89)

            at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java
:515)

            at
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

            at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecut
or.java:1128)

            at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecu
tor.java:628)

            at java.base/java.lang.Thread.run(Thread.java:834)

 

Maybe I did something wrong? Maybe the wrong driver?

 

Thanks for help.

[Squirrel-sql-users] Panels stop rendering on Mac

[Brady H. <bjh...@us...>]

Hi, I recently received a new laptop and I am trying to set it up similar to my prior box.
I downloaded/installed squirrel and it initially starts fine. However, very shortly after starting it begins to stop rendering panels. For instance, I can clone an alias, and while changing it rendering stops. Any subsequent panels are not rendered including pop-ups to exit.  Once I finally exit I can restart, and it runs for short while before failing again. I’ve tried all of the Look-and-Feels and they all stop rendering after a short time.

Squirrel Version: snapshot20220907_2225 (started with 4.4.0 MACOS)
Laptop: MacBook Pro, macOS Monterery 12.6, chip Apple M1 Max
JRE: openjdk version "17.0.4.1-ea" 2022-08-12

Regards, Brady

[Squirrel-sql-users] possible bug mysql jconnector mysql

[Gerd W. <ger...@t-...>]

Am 21.08.22 um 22:34 schrieb crystal:
> Hi Gerd-
> 
> This is the type of problem i am having.
> I set autocommit off and then I do a partial transaction.
> It doesn't show up in the processlist at all.
> I think if it is a partial query, it show up in process list.
> If not, how can you tell what is going on with a partial transaction?
> 
> Do you have any ideas why it doesn't list the partial queries?
> 
> I feel about as crazy as a gang of loons right now .
> mysql  Ver 8.0.30-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
> 
> Please see below...
> 
> THANKS
> 
> mysql> set autocommit=0;
> Query OK, 0 rows affected (0.00 sec)
> mysql> start transaction;
> Query OK, 0 rows affected (0.00 sec)
> mysql> update a1 set bar = 'qy' where foo = 2;
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1  Changed: 1  Warnings: 0
> mysql> show processlist;
> +----+-----------------+-----------+------+---------+------+------------------------+------------------+
> | Id | User            | Host      | db   | Command | Time | State                  | Info             |
> +----+-----------------+-----------+------+---------+------+------------------------+------------------+
> |  5 | event_scheduler | localhost | NULL | Daemon  |  126 | Waiting on empty queue | NULL             |
> |  8 | root            | localhost | mydb | Query   |    0 | init                   | show processlist |
> +----+-----------------+-----------+------+---------+------+------------------------+------------------+
> 2 rows in set (0.00 sec)
> 
> 


Sorry I don't know MySQL's command line interface too well.

But JDBC isn't designed for partial or nested transactions. With JDBC a 
connection is either in autocommit mode or the current transaction may 
be either committed or rolled back.

As SQuirreL is built on top of JDBC it isn't designed to do more neither.

Gerd

Re: [Squirrel-sql-users] Export CSV-No numeric commas

[Justin T. <JU...@lo...>]

Got it.  Thank you

Re: [Squirrel-sql-users] possible bug mysql jconnector mysql

[Gerd W. <ger...@t-...>]

Am 20.08.22 um 22:30 schrieb crystal via Squirrel-sql-users:
> Hi all-
> 
> It seems that in the same session (i hit new sql tab) even after i click 
> autocommit off it seems to save the update before it is committed.
> 
> I am also wondering if that is part of the reason why when i run this 
> query that only one transaction id shows:
> 
> SELECT tx.trx_id
> FROM information_schema.innodb_trx tx
> WHERE tx.trx_mysql_thread_id = connection_id()
> 
> please check it out and let me know when you have a chance.
> 


Sorry, I can't reproduce or don't understand your problem. Here's what I 
tried:

1. Switch autocommit off

2. Change some data, then select the data in the same Session --> The 
change is visible. Open another Session (i.e. another connection) the 
change is _not_ visible.
Whenever I open a new SQL tab (ctrl+n) in the first Session the change 
is visible there, too. This is because the SQL tab belongs to the first 
Session and uses the same connection.

This behavior is right and as intended. To my understanding it also 
matches the result of your innodb_trx select statement.


Perhaps you expect a SQL tab to use its own connection. This is not what 
SQL tabs are meant to do. To use another connection you should open a 
new Session.

Gerd