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

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

[Erwan D. <erw...@gm...>]

Hi,
When I was working with squirrel on iseries I had the same slow startup
problem.
I had attributed it to the large number of libraries and very large number
of files (tables) in each Library that squirrel has to scan on Startup.
IIRC I mitigated the problem by loading only a small number of libraries
(schemas) and not caching them in Squirrel.

HTH
Erwan



Le mar. 10 nov. 2020 à 19:47, info <in...@dr...> a écrit :

> Once I deleted all aliases, the start time returned to normal 1-2
> seconds and shutdown time to instant.
> Now I am almost positive that it was a remote iSeries alias that slowed
> everything down.
> But there I hit a roadblock. I am not able to import my aliases back. I
> load the ZIP file, it shows all of my aliases in the import window, but
> dragging them back to the now emply alias list does not work. They drag
> but do not drop. What am I missing? I tried the Update button but it did
> not do anything either. Will I have to recreate all aliases from scratch?
>
> On 2020-11-09 05:06 PM, info wrote:
> > Exported the aliases and tried deleting MySQL aliases (I have 2x).
> > Beforehand I checked if any of my aliases had connect on startup. None
> > had.
> > Anyhow, this changed nothing at all.
> > Yes, I should be able to build Squirrel. I used to step through the
> > code of Ms Sql plugin a few years back in Netbeans.
> >
> > On 2020-11-09 04:18 PM, Gerd Wagner wrote:
> >> It's the best guess the logs brought me to.
> >> I could only be quite sure if I'd be able to reproduce your problem
> >> which I still can't.
> >>
> >> If you could build and debug SQuirreL on your system this would be a
> >> fair chance to find out what the problem is. For some information on
> >> this see
> >> http://www.squirrelsql.org/index.php?page=programing
> >>
> >> Gerd
> >>
> >> Am 08.11.20 um 23:27 schrieb info:
> >>> Does this explain the 30 second delay before the shutdown?
> >>> I do have 2x MySQL aliases, and when I click on them, each connects
> >>> almost instantaneously. They lead to a server on my LAN. However I
> >>> do not recall ever checking off the connect at startup option since
> >>> started using Squirrel many years ago. I will double check if any of
> >>> them have it.
> >
> >
> >
> >
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >
>
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

Once I deleted all aliases, the start time returned to normal 1-2 
seconds and shutdown time to instant.
Now I am almost positive that it was a remote iSeries alias that slowed 
everything down.
But there I hit a roadblock. I am not able to import my aliases back. I 
load the ZIP file, it shows all of my aliases in the import window, but 
dragging them back to the now emply alias list does not work. They drag 
but do not drop. What am I missing? I tried the Update button but it did 
not do anything either. Will I have to recreate all aliases from scratch?

On 2020-11-09 05:06 PM, info wrote:
> Exported the aliases and tried deleting MySQL aliases (I have 2x). 
> Beforehand I checked if any of my aliases had connect on startup. None 
> had.
> Anyhow, this changed nothing at all.
> Yes, I should be able to build Squirrel. I used to step through the 
> code of Ms Sql plugin a few years back in Netbeans.
>
> On 2020-11-09 04:18 PM, Gerd Wagner wrote:
>> It's the best guess the logs brought me to.
>> I could only be quite sure if I'd be able to reproduce your problem 
>> which I still can't.
>>
>> If you could build and debug SQuirreL on your system this would be a 
>> fair chance to find out what the problem is. For some information on 
>> this see
>> http://www.squirrelsql.org/index.php?page=programing
>>
>> Gerd
>>
>> Am 08.11.20 um 23:27 schrieb info:
>>> Does this explain the 30 second delay before the shutdown?
>>> I do have 2x MySQL aliases, and when I click on them, each connects 
>>> almost instantaneously. They lead to a server on my LAN. However I 
>>> do not recall ever checking off the connect at startup option since 
>>> started using Squirrel many years ago. I will double check if any of 
>>> them have it.
>
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] unsubscribe

[Kevin B. <Kev...@ph...>]

Kevin Beard | Software Specialist | Enterprise Technology Group
Physicians Mutual | 2600 Dodge Street | Omaha, NE 68131
Direct: 402.930.2635 - Helpdesk: 402.633.5777 |
PhysiciansMutual.com<http://www.physiciansmutual.com/> | kev...@Ph...<mailto:kev...@Ph...>
Insurance for all of us.(tm)
health | life | retirement



--------------------------------------------------------------------------
This message and any attachments are confidential, may contain privileged information, and are intended solely for the recipient named above.
If you are not the intended recipient, or a person responsible for delivery to the named recipient, you are notified that any review, distribution, dissemination or copying is prohibited.
If you have received this message in error, you should notify the sender by return email and delete the message from your computer system.

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

Exported the aliases and tried deleting MySQL aliases (I have 2x). 
Beforehand I checked if any of my aliases had connect on startup. None had.
Anyhow, this changed nothing at all.
Yes, I should be able to build Squirrel. I used to step through the code 
of Ms Sql plugin a few years back in Netbeans.

On 2020-11-09 04:18 PM, Gerd Wagner wrote:
> It's the best guess the logs brought me to.
> I could only be quite sure if I'd be able to reproduce your problem 
> which I still can't.
>
> If you could build and debug SQuirreL on your system this would be a 
> fair chance to find out what the problem is. For some information on 
> this see
> http://www.squirrelsql.org/index.php?page=programing
>
> Gerd
>
> Am 08.11.20 um 23:27 schrieb info:
>> Does this explain the 30 second delay before the shutdown?
>> I do have 2x MySQL aliases, and when I click on them, each connects 
>> almost instantaneously. They lead to a server on my LAN. However I do 
>> not recall ever checking off the connect at startup option since 
>> started using Squirrel many years ago. I will double check if any of 
>> them have it.

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

It's the best guess the logs brought me to.
I could only be quite sure if I'd be able to reproduce your problem 
which I still can't.

If you could build and debug SQuirreL on your system this would be a 
fair chance to find out what the problem is. For some information on 
this see
http://www.squirrelsql.org/index.php?page=programing

Gerd

Am 08.11.20 um 23:27 schrieb info:
> Does this explain the 30 second delay before the shutdown?
> I do have 2x MySQL aliases, and when I click on them, each connects 
> almost instantaneously. They lead to a server on my LAN. However I do 
> not recall ever checking off the connect at startup option since started 
> using Squirrel many years ago. I will double check if any of them have it.
> 
> On 2020-11-08 05:21 PM, Gerd Wagner wrote:
>> Looks like an Alias connecting to MYSQL during SQuirreL's startup is 
>> causing problems. Please see if there is such an Alias with "Connect 
>> at application startup" checked.The error messages pointing to this are:
>>
>> 2020-11-06 21:33:02,555 [AWT-EventQueue-1] ERROR 
>> net.sourceforge.squirrel_sql.client.gui.db.AliasesAndDriversManager - 
>> Could not find class com.mysql.cj.jdbc.Driver in neither the Java 
>> class path nor the Extra class path of the MariaDB Driver for MySQL 
>> and MariaDB driver definition:
>> java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
>>
>> and
>>
>> java.lang.NumberFormatException: For input string: "3306>]"
>>     at java.lang.NumberFormatException.forInputString(Unknown Source)
>>     at java.lang.Integer.parseInt(Unknown Source)
>>     at java.lang.Integer.parseInt(Unknown Source)
>>     at 
>> com.mysql.cj.conf.ConnectionUrlParser.parseHostPortPair(ConnectionUrlParser.java:500) 
>>
>>
>>
>>
>>
>>
>> In the new snapshot
>> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20201108_2305/ 
>>
>>
>> Aliases that are connected to during startup are written to SQuirreL's 
>> log file. The new log entries look like this:
>> 2020-11-08 22:58:49,696 [AWT-EventQueue-1] INFO 
>> net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToStartupAliasesCommand 
>>  - Connecting during Application start to Alias: "<Alias-name>" 
>> (JDBC-URL: <jdbc-Url>)
>>
>>
>> Hope this helps
>> Gerd
>>
>> Am 08.11.20 um 03:27 schrieb info:
>>> Logs attached.
>>>
>>> On 2020-11-07 03:58 PM, Gerd Wagner wrote:
>>>> You may post SQuirreL's logs. Here are the steps
>>>>
>>>> - Close SQuirreL
>>>> - Go to the logs directory of your SQuirreL user dir
>>>> - Delete or move away all existing log files (this is to prevent 
>>>> sending unnecessary big log files).
>>>> - Open and Close SQuirreL
>>>> - Send the log file that was newly created.
>>>>
>>>> Gerd 
>>>
>>>
>>>
>>> _______________________________________________
>>> Squirrel-sql-users mailing list
>>> Squ...@li...
>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>>
>>
> 
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] unsubscribe

[Yudong Q. <Yud...@dm...>]

Please remove me from the mail list.

Thank you!

Yudong Qian


--------------------------------------------------------------------------------------- This E-mail, including any attachments, may contain confidential information. If you are not the intended recipient, please notify the sender, do not disclose its contents to others, and delete it from your system. Any other use of this E-mail and/or attachments is prohibited. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. ------------------------------------------------------------------------------   

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

Does this explain the 30 second delay before the shutdown?
I do have 2x MySQL aliases, and when I click on them, each connects 
almost instantaneously. They lead to a server on my LAN. However I do 
not recall ever checking off the connect at startup option since  
started using Squirrel many years ago. I will double check if any of 
them have it.

On 2020-11-08 05:21 PM, Gerd Wagner wrote:
> Looks like an Alias connecting to MYSQL during SQuirreL's startup is 
> causing problems. Please see if there is such an Alias with "Connect 
> at application startup" checked.The error messages pointing to this are:
>
> 2020-11-06 21:33:02,555 [AWT-EventQueue-1] ERROR 
> net.sourceforge.squirrel_sql.client.gui.db.AliasesAndDriversManager - 
> Could not find class com.mysql.cj.jdbc.Driver in neither the Java 
> class path nor the Extra class path of the MariaDB Driver for MySQL 
> and MariaDB driver definition:
> java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
>
> and
>
> java.lang.NumberFormatException: For input string: "3306>]"
>     at java.lang.NumberFormatException.forInputString(Unknown Source)
>     at java.lang.Integer.parseInt(Unknown Source)
>     at java.lang.Integer.parseInt(Unknown Source)
>     at 
> com.mysql.cj.conf.ConnectionUrlParser.parseHostPortPair(ConnectionUrlParser.java:500)
>
>
>
>
>
> In the new snapshot
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20201108_2305/ 
>
>
> Aliases that are connected to during startup are written to SQuirreL's 
> log file. The new log entries look like this:
> 2020-11-08 22:58:49,696 [AWT-EventQueue-1] INFO 
> net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToStartupAliasesCommand 
>  - Connecting during Application start to Alias: "<Alias-name>" 
> (JDBC-URL: <jdbc-Url>)
>
>
> Hope this helps
> Gerd
>
> Am 08.11.20 um 03:27 schrieb info:
>> Logs attached.
>>
>> On 2020-11-07 03:58 PM, Gerd Wagner wrote:
>>> You may post SQuirreL's logs. Here are the steps
>>>
>>> - Close SQuirreL
>>> - Go to the logs directory of your SQuirreL user dir
>>> - Delete or move away all existing log files (this is to prevent 
>>> sending unnecessary big log files).
>>> - Open and Close SQuirreL
>>> - Send the log file that was newly created.
>>>
>>> Gerd 
>>
>>
>>
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

Looks like an Alias connecting to MYSQL during SQuirreL's startup is 
causing problems. Please see if there is such an Alias with "Connect at 
application startup" checked.The error messages pointing to this are:

2020-11-06 21:33:02,555 [AWT-EventQueue-1] ERROR 
net.sourceforge.squirrel_sql.client.gui.db.AliasesAndDriversManager  - 
Could not find class com.mysql.cj.jdbc.Driver in neither the Java class 
path nor the Extra class path of the MariaDB Driver for MySQL and 
MariaDB driver definition:
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver

and

java.lang.NumberFormatException: For input string: "3306>]"
	at java.lang.NumberFormatException.forInputString(Unknown Source)
	at java.lang.Integer.parseInt(Unknown Source)
	at java.lang.Integer.parseInt(Unknown Source)
	at 
com.mysql.cj.conf.ConnectionUrlParser.parseHostPortPair(ConnectionUrlParser.java:500)





In the new snapshot
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20201108_2305/

Aliases that are connected to during startup are written to SQuirreL's 
log file. The new log entries look like this:
2020-11-08 22:58:49,696 [AWT-EventQueue-1] INFO 
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToStartupAliasesCommand 
  - Connecting during Application start to Alias: "<Alias-name>" 
(JDBC-URL: <jdbc-Url>)


Hope this helps
Gerd

Am 08.11.20 um 03:27 schrieb info:
> Logs attached.
> 
> On 2020-11-07 03:58 PM, Gerd Wagner wrote:
>> You may post SQuirreL's logs. Here are the steps
>>
>> - Close SQuirreL
>> - Go to the logs directory of your SQuirreL user dir
>> - Delete or move away all existing log files (this is to prevent 
>> sending unnecessary big log files).
>> - Open and Close SQuirreL
>> - Send the log file that was newly created.
>>
>> Gerd 
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

Logs attached.

On 2020-11-07 03:58 PM, Gerd Wagner wrote:
> You may post SQuirreL's logs. Here are the steps
>
> - Close SQuirreL
> - Go to the logs directory of your SQuirreL user dir
> - Delete or move away all existing log files (this is to prevent 
> sending unnecessary big log files).
> - Open and Close SQuirreL
> - Send the log file that was newly created.
>
> Gerd 

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

You may post SQuirreL's logs. Here are the steps

- Close SQuirreL
- Go to the logs directory of your SQuirreL user dir
- Delete or move away all existing log files (this is to prevent sending 
unnecessary big log files).
- Open and Close SQuirreL
- Send the log file that was newly created.

Gerd

Am 07.11.20 um 04:06 schrieb info:
> Tried downgrading the JDK down to 1.8.40 - no difference.
> Tried disabling all drivers - no difference. I cannot delete aliases but 
> without drivers they have nothing to load, have they?
> 
> I solved the memory problem by adding -Xmx256M argument to the bat file, 
> but the 15 second start hang and 30 second shutdown hang are still there 
> - no difference.
> 
> I could email logs if something could be gleaned from them. Lots of 
> exceptions in them.
> 
> 
> 
> On 2020-11-06 07:01 PM, info wrote:
>> I am currently on the most recent available download for Windows, it's 
>> 4... something as of 2x days ago. It behaves the same as 3.9, whether 
>> I run one or another.
>>
>> Like I said, I've already tried to remove Sqlite:
>>
>> > I tried to unload SQLite but it did not change anything.
>>
>> This means that I deleted Sqlite alias and removed the extra classpath 
>> from the driver config, rendering it (X) in the list.
>>
>> I distinctly remember having to pass Java command line argument to 
>> allow memory over 256 MB or something along these lines. How can it 
>> load more without me passing that parameter? If it matters, I am on 
>> JDK 1.8.121 which is the same one where I had to pass the argument.
>>
>> The loading screen gets stuck on loading JDBC drivers. On closing the 
>> app, it hangs for 30 seconds and then asks to save any open files. 
>> Once told to save or not, it shuts down instantaneously.
>>
>> Is there any trace log?
>>
>>
>> On 2020-11-06 02:24 PM, Gerd Wagner wrote:
>>> Sorry, I can't reproduce your problem using
>>> https://github.com/xerial/sqlite-jdbc/releases/tag/3.32.3.2
>>> which is latest today. ;)
>>>
>>> Could you give some more details?
>>>
>>> Here are some things you may try:
>>> - Delete all SQLite Aliases.
>>> - Remove the SQLite driver from SQuirreL's driver definition. Either 
>>> by deleting its "Extra Class Path" entry (recommended way to use a 
>>> driver) or by removing it from SQuirreL's lib directory (NOT the 
>>> recommended way to use a driver). Anyway after this the driver 
>>> definition should appear unchecked (red crossed) in your drivers list.
>>>
>>> Gerd
>>>
>>> Am 06.11.20 um 12:53 schrieb info:
>>>> Hi all,
>>>>
>>>> A long-time Squirrel user here. Up until now I never had any issues. 
>>>> Been using mostly versions up to 3.9 with all kinds of databases for 
>>>> years. Currently I am working on a project that connects to every 
>>>> imaginable database, and I have the following JDBC drivers loaded:
>>>>
>>>> DB2 JDBC-SQLJ 10.5
>>>>
>>>> iSeries JTOpen 7.10
>>>>
>>>> JTDS 1.3.1
>>>>
>>>> MySQL connector 5.1.40
>>>>
>>>> PostgreSQL 9.4.12
>>>>
>>>> SQLite whatever latest is today.
>>>>
>>>> I am almost positive that until I loaded SQLite, the startup and 
>>>> shutdown times were reasonable, within a few seconds. Since I loaded 
>>>> it, everything changed. It now takes up to 20 seconds to start the 
>>>> app and up to 30-40 seconds for it to shut down. It starts up with 
>>>> 800 MB of RAM allocated and grows to about 1.1 GB over the course of 
>>>> me running a handful of queries that return a handful of records 
>>>> from a couple of those back ends, no more than 1-2 back ends at a 
>>>> time. I never run anything that returns huge datasets.
>>>>
>>>> I tried to unload SQLite but it did not change anything.
>>>>
>>>> Since the machine that I am developing on is constrained on RAM (8 
>>>> GB) and I have to run local Oracle tuned to use only 1 GB, DB2, MS 
>>>> SQL also tuned to use up to 1 GB, and Postgress, the memory 
>>>> utilization of Squirrel has become a considerable annoyance. I do 
>>>> not recall it ever using more than 256 MB of RAM without specifying 
>>>> Java command line option in the past. I am certainly not passing the 
>>>> memory option to Java to increase memory allocation. So it is a 
>>>> mystery what is going on.
>>>>
>>>> I unloaded almost all plugins but there was very small difference in 
>>>> memory utilization. The UI has changed to vanilla AWT so it seems, 
>>>> and it is kind of nimbler to respond, but the overall problem remains.
>>>>
>>>> Any ideas?
>>>>
>>>> Thanks for your help!
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Squirrel-sql-users mailing list
>>>> Squ...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>>
>>
>>
>>
>>
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
> 
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Clean install of 4.1 fails with no splash screen

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

Not to worry: installed openjdk, and problem went away.

Sorry for the noise.

Roger

---
***************************
Roger Hill
***************************

On 2020-11-07 06:50, Roger Hill wrote:

> Hi.
> 
> Returning to Squirrel after a few years. Just downloaded 4.1 standard, 
> installed ok. Java is version 11, on Lubuntu 20.10.
> 
> When I run the startup script I get:
> 
> rhill@banana:~/squirrel-sql-4.1.0$ ./squirrel-sql.sh
> java.lang.UnsatisfiedLinkError: no splashscreen in java.library.path: 
> [/usr/java/packages/lib, /usr/lib/x86_64-linux-gnu/jni, 
> /lib/x86_64-linux-gnu, /usr/lib/x86_64-linux-gnu, /usr/lib/jni, /lib, 
> /usr/lib]
> at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2670)
> at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:830)
> at java.base/java.lang.System.loadLibrary(System.java:1873)
> at java.desktop/java.awt.SplashScreen$1.run(SplashScreen.java:134)
> at java.desktop/java.awt.SplashScreen$1.run(SplashScreen.java:132)
> at java.base/java.security.AccessController.doPrivileged(Native Method)
> at 
> java.desktop/java.awt.SplashScreen.getSplashScreen(SplashScreen.java:131)
> at 
> net.sourceforge.squirrel_sql.client.gui.SquirrelSplashScreen.<init>(SquirrelSplashScreen.java:37)
> at 
> net.sourceforge.squirrel_sql.client.Application.startup(Application.java:211)
> at 
> net.sourceforge.squirrel_sql.client.Main.doApplicationStartup(Main.java:119)
> at 
> net.sourceforge.squirrel_sql.client.Main.lambda$startApp$0(Main.java:111)
> at 
> java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:313)
> at 
> java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:770)
> at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
> at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
> at java.base/java.security.AccessController.doPrivileged(Native Method)
> at 
> java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
> at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:740)
> at 
> net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
> 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)
> 
> Where should I start to resolve this, please?
> 
> Regards
> 
> Roger
> 
> --
> ***************************
> Roger Hill
> ***************************
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Clean install of 4.1 fails with no splash screen

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

Hi.

Returning to Squirrel after a few years. Just downloaded 4.1 standard, 
installed ok. Java is version 11, on Lubuntu 20.10.

When I run the startup script I get:

rhill@banana:~/squirrel-sql-4.1.0$ ./squirrel-sql.sh
java.lang.UnsatisfiedLinkError: no splashscreen in java.library.path: 
[/usr/java/packages/lib, /usr/lib/x86_64-linux-gnu/jni, 
/lib/x86_64-linux-gnu, /usr/lib/x86_64-linux-gnu, /usr/lib/jni, /lib, 
/usr/lib]
at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2670)
at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:830)
at java.base/java.lang.System.loadLibrary(System.java:1873)
at java.desktop/java.awt.SplashScreen$1.run(SplashScreen.java:134)
at java.desktop/java.awt.SplashScreen$1.run(SplashScreen.java:132)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at 
java.desktop/java.awt.SplashScreen.getSplashScreen(SplashScreen.java:131)
at 
net.sourceforge.squirrel_sql.client.gui.SquirrelSplashScreen.<init>(SquirrelSplashScreen.java:37)
at 
net.sourceforge.squirrel_sql.client.Application.startup(Application.java:211)
at 
net.sourceforge.squirrel_sql.client.Main.doApplicationStartup(Main.java:119)
at 
net.sourceforge.squirrel_sql.client.Main.lambda$startApp$0(Main.java:111)
at 
java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:313)
at 
java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:770)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at 
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:740)
at 
net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
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)

Where should I start to resolve this, please?

Regards

Roger

-- 
***************************
Roger Hill
***************************

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

Tried downgrading the JDK down to 1.8.40 - no difference.
Tried disabling all drivers - no difference. I cannot delete aliases but 
without drivers they have nothing to load, have they?

I solved the memory problem by adding -Xmx256M argument to the bat file, 
but the 15 second start hang and 30 second shutdown hang are still there 
- no difference.

I could email logs if something could be gleaned from them. Lots of 
exceptions in them.



On 2020-11-06 07:01 PM, info wrote:
> I am currently on the most recent available download for Windows, it's 
> 4... something as of 2x days ago. It behaves the same as 3.9, whether 
> I run one or another.
>
> Like I said, I've already tried to remove Sqlite:
>
> > I tried to unload SQLite but it did not change anything.
>
> This means that I deleted Sqlite alias and removed the extra classpath 
> from the driver config, rendering it (X) in the list.
>
> I distinctly remember having to pass Java command line argument to 
> allow memory over 256 MB or something along these lines. How can it 
> load more without me passing that parameter? If it matters, I am on 
> JDK 1.8.121 which is the same one where I had to pass the argument.
>
> The loading screen gets stuck on loading JDBC drivers. On closing the 
> app, it hangs for 30 seconds and then asks to save any open files. 
> Once told to save or not, it shuts down instantaneously.
>
> Is there any trace log?
>
>
> On 2020-11-06 02:24 PM, Gerd Wagner wrote:
>> Sorry, I can't reproduce your problem using
>> https://github.com/xerial/sqlite-jdbc/releases/tag/3.32.3.2
>> which is latest today. ;)
>>
>> Could you give some more details?
>>
>> Here are some things you may try:
>> - Delete all SQLite Aliases.
>> - Remove the SQLite driver from SQuirreL's driver definition. Either 
>> by deleting its "Extra Class Path" entry (recommended way to use a 
>> driver) or by removing it from SQuirreL's lib directory (NOT the 
>> recommended way to use a driver). Anyway after this the driver 
>> definition should appear unchecked (red crossed) in your drivers list.
>>
>> Gerd
>>
>> Am 06.11.20 um 12:53 schrieb info:
>>> Hi all,
>>>
>>> A long-time Squirrel user here. Up until now I never had any issues. 
>>> Been using mostly versions up to 3.9 with all kinds of databases for 
>>> years. Currently I am working on a project that connects to every 
>>> imaginable database, and I have the following JDBC drivers loaded:
>>>
>>> DB2 JDBC-SQLJ 10.5
>>>
>>> iSeries JTOpen 7.10
>>>
>>> JTDS 1.3.1
>>>
>>> MySQL connector 5.1.40
>>>
>>> PostgreSQL 9.4.12
>>>
>>> SQLite whatever latest is today.
>>>
>>> I am almost positive that until I loaded SQLite, the startup and 
>>> shutdown times were reasonable, within a few seconds. Since I loaded 
>>> it, everything changed. It now takes up to 20 seconds to start the 
>>> app and up to 30-40 seconds for it to shut down. It starts up with 
>>> 800 MB of RAM allocated and grows to about 1.1 GB over the course of 
>>> me running a handful of queries that return a handful of records 
>>> from a couple of those back ends, no more than 1-2 back ends at a 
>>> time. I never run anything that returns huge datasets.
>>>
>>> I tried to unload SQLite but it did not change anything.
>>>
>>> Since the machine that I am developing on is constrained on RAM (8 
>>> GB) and I have to run local Oracle tuned to use only 1 GB, DB2, MS 
>>> SQL also tuned to use up to 1 GB, and Postgress, the memory 
>>> utilization of Squirrel has become a considerable annoyance. I do 
>>> not recall it ever using more than 256 MB of RAM without specifying 
>>> Java command line option in the past. I am certainly not passing the 
>>> memory option to Java to increase memory allocation. So it is a 
>>> mystery what is going on.
>>>
>>> I unloaded almost all plugins but there was very small difference in 
>>> memory utilization. The UI has changed to vanilla AWT so it seems, 
>>> and it is kind of nimbler to respond, but the overall problem remains.
>>>
>>> Any ideas?
>>>
>>> Thanks for your help!
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Squirrel-sql-users mailing list
>>> Squ...@li...
>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

I am currently on the most recent available download for Windows, it's 
4... something as of 2x days ago. It behaves the same as 3.9, whether I 
run one or another.

Like I said, I've already tried to remove Sqlite:

 > I tried to unload SQLite but it did not change anything.

This means that I deleted Sqlite alias and removed the extra classpath 
from the driver config, rendering it (X) in the list.

I distinctly remember having to pass Java command line argument to allow 
memory over 256 MB or something along these lines. How can it load more 
without me passing that parameter? If it matters, I am on JDK 1.8.121 
which is the same one where I had to pass the argument.

The loading screen gets stuck on loading JDBC drivers. On closing the 
app, it hangs for 30 seconds and then asks to save any open files. Once 
told to save or not, it shuts down instantaneously.

Is there any trace log?


On 2020-11-06 02:24 PM, Gerd Wagner wrote:
> Sorry, I can't reproduce your problem using
> https://github.com/xerial/sqlite-jdbc/releases/tag/3.32.3.2
> which is latest today. ;)
>
> Could you give some more details?
>
> Here are some things you may try:
> - Delete all SQLite Aliases.
> - Remove the SQLite driver from SQuirreL's driver definition. Either 
> by deleting its "Extra Class Path" entry (recommended way to use a 
> driver) or by removing it from SQuirreL's lib directory (NOT the 
> recommended way to use a driver). Anyway after this the driver 
> definition should appear unchecked (red crossed) in your drivers list.
>
> Gerd
>
> Am 06.11.20 um 12:53 schrieb info:
>> Hi all,
>>
>> A long-time Squirrel user here. Up until now I never had any issues. 
>> Been using mostly versions up to 3.9 with all kinds of databases for 
>> years. Currently I am working on a project that connects to every 
>> imaginable database, and I have the following JDBC drivers loaded:
>>
>> DB2 JDBC-SQLJ 10.5
>>
>> iSeries JTOpen 7.10
>>
>> JTDS 1.3.1
>>
>> MySQL connector 5.1.40
>>
>> PostgreSQL 9.4.12
>>
>> SQLite whatever latest is today.
>>
>> I am almost positive that until I loaded SQLite, the startup and 
>> shutdown times were reasonable, within a few seconds. Since I loaded 
>> it, everything changed. It now takes up to 20 seconds to start the 
>> app and up to 30-40 seconds for it to shut down. It starts up with 
>> 800 MB of RAM allocated and grows to about 1.1 GB over the course of 
>> me running a handful of queries that return a handful of records from 
>> a couple of those back ends, no more than 1-2 back ends at a time. I 
>> never run anything that returns huge datasets.
>>
>> I tried to unload SQLite but it did not change anything.
>>
>> Since the machine that I am developing on is constrained on RAM (8 
>> GB) and I have to run local Oracle tuned to use only 1 GB, DB2, MS 
>> SQL also tuned to use up to 1 GB, and Postgress, the memory 
>> utilization of Squirrel has become a considerable annoyance. I do not 
>> recall it ever using more than 256 MB of RAM without specifying Java 
>> command line option in the past. I am certainly not passing the 
>> memory option to Java to increase memory allocation. So it is a 
>> mystery what is going on.
>>
>> I unloaded almost all plugins but there was very small difference in 
>> memory utilization. The UI has changed to vanilla AWT so it seems, 
>> and it is kind of nimbler to respond, but the overall problem remains.
>>
>> Any ideas?
>>
>> Thanks for your help!
>>
>>
>>
>>
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

Sorry, I can't reproduce your problem using
https://github.com/xerial/sqlite-jdbc/releases/tag/3.32.3.2
which is latest today. ;)

Could you give some more details?

Here are some things you may try:
- Delete all SQLite Aliases.
- Remove the SQLite driver from SQuirreL's driver definition. Either by 
deleting its "Extra Class Path" entry (recommended way to use a driver) 
or by removing it from SQuirreL's lib directory (NOT the recommended way 
to use a driver). Anyway after this the driver definition should appear 
unchecked (red crossed) in your drivers list.

Gerd

Am 06.11.20 um 12:53 schrieb info:
> Hi all,
> 
> A long-time Squirrel user here. Up until now I never had any issues. 
> Been using mostly versions up to 3.9 with all kinds of databases for 
> years. Currently I am working on a project that connects to every 
> imaginable database, and I have the following JDBC drivers loaded:
> 
> DB2 JDBC-SQLJ 10.5
> 
> iSeries JTOpen 7.10
> 
> JTDS 1.3.1
> 
> MySQL connector 5.1.40
> 
> PostgreSQL 9.4.12
> 
> SQLite whatever latest is today.
> 
> I am almost positive that until I loaded SQLite, the startup and 
> shutdown times were reasonable, within a few seconds. Since I loaded it, 
> everything changed. It now takes up to 20 seconds to start the app and 
> up to 30-40 seconds for it to shut down. It starts up with 800 MB of RAM 
> allocated and grows to about 1.1 GB over the course of me running a 
> handful of queries that return a handful of records from a couple of 
> those back ends, no more than 1-2 back ends at a time. I never run 
> anything that returns huge datasets.
> 
> I tried to unload SQLite but it did not change anything.
> 
> Since the machine that I am developing on is constrained on RAM (8 GB) 
> and I have to run local Oracle tuned to use only 1 GB, DB2, MS SQL also 
> tuned to use up to 1 GB, and Postgress, the memory utilization of 
> Squirrel has become a considerable annoyance. I do not recall it ever 
> using more than 256 MB of RAM without specifying Java command line 
> option in the past. I am certainly not passing the memory option to Java 
> to increase memory allocation. So it is a mystery what is going on.
> 
> I unloaded almost all plugins but there was very small difference in 
> memory utilization. The UI has changed to vanilla AWT so it seems, and 
> it is kind of nimbler to respond, but the overall problem remains.
> 
> Any ideas?
> 
> Thanks for your help!
> 
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Memory utilization and slow start up and shutdown

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

Hi all,

A long-time Squirrel user here. Up until now I never had any issues. 
Been using mostly versions up to 3.9 with all kinds of databases for 
years. Currently I am working on a project that connects to every 
imaginable database, and I have the following JDBC drivers loaded:

DB2 JDBC-SQLJ 10.5

iSeries JTOpen 7.10

JTDS 1.3.1

MySQL connector 5.1.40

PostgreSQL 9.4.12

SQLite whatever latest is today.

I am almost positive that until I loaded SQLite, the startup and 
shutdown times were reasonable, within a few seconds. Since I loaded it, 
everything changed. It now takes up to 20 seconds to start the app and 
up to 30-40 seconds for it to shut down. It starts up with 800 MB of RAM 
allocated and grows to about 1.1 GB over the course of me running a 
handful of queries that return a handful of records from a couple of 
those back ends, no more than 1-2 back ends at a time. I never run 
anything that returns huge datasets.

I tried to unload SQLite but it did not change anything.

Since the machine that I am developing on is constrained on RAM (8 GB) 
and I have to run local Oracle tuned to use only 1 GB, DB2, MS SQL also 
tuned to use up to 1 GB, and Postgress, the memory utilization of 
Squirrel has become a considerable annoyance. I do not recall it ever 
using more than 256 MB of RAM without specifying Java command line 
option in the past. I am certainly not passing the memory option to Java 
to increase memory allocation. So it is a mystery what is going on.

I unloaded almost all plugins but there was very small difference in 
memory utilization. The UI has changed to vanilla AWT so it seems, and 
it is kind of nimbler to respond, but the overall problem remains.

Any ideas?

Thanks for your help!

Re: [Squirrel-sql-users] Always show all 3 decimals for timestamps

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

Is committed to our GIT repository and will from now be available in 
future snapshots and versions. The first snapshot containing the change is
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20201105_0156

Excerpt from change log:
Option to always use three digit milliseconds in default SQL Timestamp 
display.
   See menu File --> Global Preference  --> tab "Data Type Controls"
   --> section "Timestamp (SQL type 93)" --> checkbox "Always display 
milliseconds in three digits".

Gerd


Am 26.10.20 um 12:04 schrieb Miene, Benedikt:
> Hi there,
> 
> while using SQuirreL SQL Client 3.9.1 we got some confusions with the 
> display of timestamps.
> 
> The last 0´s of a timestamps milliseconds are trimmed, for example:
> 
> The timestamp 2020-10-26 09:00:05.100 is displayed as 2020-10-26 09:00:05.1
> 
> It isn´t wrong but it confused some people as we also use other SQL 
> tools that always show them.
> 
> Is there a way to always show all 3 decimals for a timestamp?
> 
> Thanks for your help!
> 
> Benedikt
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] Always show all 3 decimals for timestamps

[Miene, B. <b....@mp...>]

Hi there,

while using SQuirreL SQL Client 3.9.1 we got some confusions with the display of timestamps.
The last 0´s of a timestamps milliseconds are trimmed, for example:

The timestamp 2020-10-26 09:00:05.100 is displayed as 2020-10-26 09:00:05.1

It isn´t wrong but it confused some people as we also use other SQL tools that always show them.

Is there a way to always show all 3 decimals for a timestamp?


Thanks for your help!

Benedikt

Re: [Squirrel-sql-users] [Experimental] Hires icons on hidpi screens

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

Mon, 7 Sep 2020 17:46:44 +0300, /Stanimir Stamenkov/:

> I've been working on providing hires icons for SQuirreL SQL for use on 
> hidpi screens for sometime now.  Gerd has been kind to produce and host 
> an experimental build showcasing the changes:
> 
> -   https://sourceforge.net/projects/squirrel-sql/files/experimental/hires_icons/ 
> 
> The effect of this is only seen on hidpi screens using Java 9+ (Java 8 
> is generally not hidpi-aware)...

There's now updated build which adds hidpi support for Java 8 as well:

https://sourceforge.net/projects/squirrel-sql/files/experimental/hires_icons_2/

There are few possible details for making it effective with Java 8:

1. On Windows one may have to adjust the Java executable (javaw.exe) 
properties like:

javaw.exe Properties / Compatibility / Change High DPI settings

https://i.imgur.com/jjpDgfI.png

High DPI scaling override / Scaling performed by: Application

https://i.imgur.com/a5msK7m.png

2. With some L&Fs such as the built-in Metal and Nimbus one may need to 
manually adjust font sizes via the SQuirreL Global Preferences / Fonts:

https://sourceforge.net/p/squirrel-sql/git/_discuss/thread/143ec88272/0cb1/attachment/squirrel-metal-fonts-java8.png

This is not generally necessary with JGoodies Plastic, for example.

Note on Java 8 hidpi support: Even with SQuirreL icons and SQuirreL 
specific UI scaled appropriately certain UI elements such as scroll-bars 
may not be scaled appropriately by the used L&F – compare JGoodies 
Plastic on Java 8 and Java 9:

Java 8: 
https://sourceforge.net/p/squirrel-sql/git/_discuss/thread/143ec88272/0cb1/attachment/squirrel-plastic-object-tree-java8.png
Java 9+: 
https://sourceforge.net/p/squirrel-sql/git/_discuss/thread/143ec88272/0cb1/attachment/squirrel-plastic-object-tree-java9.png

For full hidpi support/experience one may use FlatLaf [1]:

Java 8: 
https://sourceforge.net/p/squirrel-sql/git/_discuss/thread/143ec88272/0cb1/attachment/squirrel-flatlaf-object-tree-java8.png
Java
Java 9+: 
https://sourceforge.net/p/squirrel-sql/git/_discuss/thread/143ec88272/0cb1/attachment/squirrel-flatlaf-object-tree-java9.png

FlatLaf could be set up for use via the user "extralafs.properties" [2]:

# https://www.formdev.com/flatlaf/
classname0=com.formdev.flatlaf.FlatLightLaf
jars0=flatlaf-0.42.jar

classname1=com.formdev.flatlaf.FlatDarkLaf
jars1=flatlaf-0.42.jar

Find more details and screenshots in the merge request:

https://sourceforge.net/p/squirrel-sql/git/merge-requests/57

[1] https://www.formdev.com/flatlaf/
[2] 
https://sourceforge.net/p/squirrel-sql/git/ci/master/tree/sql12/plugins/laf/doc/readme.html?format=raw

-- 
Stanimir

Re: [Squirrel-sql-users] Search- and Replace-Windows do not opne

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

That's a bug. I just fixed it and released a snapshot with the fix:
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20200923_1743/

Sorry for the inconvenience.

Gerd


Am 21.09.20 um 07:50 schrieb Carsten Gruber:
> Hi,
> 
> with squirrel-sql-snapshot-20200915_2206 the search- and also the 
> replace-windows do not open.
> Mouseclick and also CRTL-S / CTRL-H do not work. Java ist up to date.
> 
> I didn’t check all snapshots, but in version 
> squirrel-sql-snapshot-20200708_2130 this problem didn’t exist.
> 
> Do you have any ideas?
> 
> Carsten Gruber
> 
> _________________________________________________
> 
> IT.UV Software GmbH / Alter Teichweg 23a / 22081 Hamburg
> _________________________________________________
> www.ituv-software.de <http://www.ituv-software.de/>
> 
> Amtsgericht Hamburg HRB 128254
> USt-IdNr. DE 811346554
> Geschäftsführung: Thomas Vogeler, Klaus Rojahn
> 
> 
> The contents of this e-mail are intended for the named addressee only.
> It contains information which may be confidential and which may also be 
> privileged.
> Unless you are the named addressee (or authorized to receive for the
> addressee) you may not copy or use it, or disclose it to anyone else.
> If you received it in error please notify us immediately and then 
> destroy it.
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] Search- and Replace-Windows do not opne

[Carsten G. <Car...@it...>]

Hi,

with squirrel-sql-snapshot-20200915_2206 the search- and also the replace-windows do not open.
Mouseclick and also CRTL-S / CTRL-H do not work. Java ist up to date.

I didn't check all snapshots, but in version squirrel-sql-snapshot-20200708_2130 this problem didn't exist.

Do you have any ideas?

Carsten Gruber
_________________________________________________

IT.UV Software GmbH / Alter Teichweg 23a / 22081 Hamburg
_________________________________________________
www.ituv-software.de<http://www.ituv-software.de/>
Amtsgericht Hamburg HRB 128254
USt-IdNr. DE 811346554
Geschäftsführung: Thomas Vogeler, Klaus Rojahn

The contents of this e-mail are intended for the named addressee only.
It contains information which may be confidential and which may also be privileged.
Unless you are the named addressee (or authorized to receive for the
addressee) you may not copy or use it, or disclose it to anyone else.
If you received it in error please notify us immediately and then destroy it.

Re: [Squirrel-sql-users] Redshift access via IAM

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

Do you have an error log or error message of the "blocking"?

Maybe this page will be of help:
https://www.cdata.com/kb/tech/redshift-jdbc-squirrel-sql.rst

Gerd

Am 24.08.20 um 12:46 schrieb Nicholas Tucci:
> Hi
> 
> I am trying to connect to redshift using IAM credentials (access key ID 
> and secret access key) and using the driver that can be downloaded from 
> AWS documentation:
> https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/1.2.47.1071/RedshiftJDBC42-1.2.47.1071.zip
> 
> Unfortunately when I use Squirrel SQL Client and try to configure the 
> IAM credentials to connect to the cluster I'm blocked and I can't insert 
> the needed values.
> 
> Is there anything I can do to connect to Redshift via IAM credentials 
> using Squirrel Client?
> 
> I am waiting for a kind reply,
> Nicholas
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] [Experimental] Hires icons on hidpi screens

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

Hi all.

I've been working on providing hires icons for SQuirreL SQL for use on 
hidpi screens for sometime now.  Gerd has been kind to produce and host 
an experimental build showcasing the changes:

- 
https://sourceforge.net/projects/squirrel-sql/files/experimental/hires_icons/

The effect of this is only seen on hidpi screens using Java 9+ (Java 8 
is generally not hidpi-aware).  I would like to find out whether people 
find useful the way icons are painted on hidpi screens with this 
experimental build.  Personally I find the improvement essential for 
non-integral scale factor screens, f.e. 1.25 (125%), 1.5 (150%), 1.75 
(175%).  See some screenshots for comparison:

-   Screen scaling 125% original: https://i.imgur.com/R65Vq4Q.png
-   Screen scaling 125% hires icons: https://i.imgur.com/k3yj336.png
-   Screen scaling 150% original: https://i.imgur.com/n7F06M7.png
-   Screen scaling 150% hires icons: https://i.imgur.com/BWaD0mP.png
-   Screen scaling 200% original: https://i.imgur.com/X569kdU.png
-   Screen scaling 200% hires icons: https://i.imgur.com/goyCLCE.png

but it would be best if you could try out the experimental build and 
provide feedback to this thread.  Hope you like it.

---

Here are some technical details.  The hires icon variants are produced 
from the original ones using 2xBRZ:

-   https://sourceforge.net/projects/xbrz

This provides some very nice scaled up variants – sharp with preserved 
detail as much as there could be.

For non-integral scale factor monitors, the 2x variants are dynamically 
smoothly scaled (down) to the target resolution.  This produces much 
better result than smoothly (bicubic interpolation) scaling up the 
original variants.

For even more details one could check out the various incarnations of my 
attempts at this so far:

-   https://sourceforge.net/p/squirrel-sql/git/merge-requests/50
-   https://sourceforge.net/p/squirrel-sql/git/merge-requests/52
-   https://sourceforge.net/p/squirrel-sql/git/merge-requests/55
-   https://sourceforge.net/p/squirrel-sql/git/merge-requests/57

-- 
Stanimir

[Squirrel-sql-users] Redshift access via IAM

[Nicholas T. <nic...@bi...>]

Hi

I am trying to connect to redshift using IAM credentials (access key ID and
secret access key) and using the driver that can be downloaded from AWS
documentation:
https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/1.2.47.1071/RedshiftJDBC42-1.2.47.1071.zip

Unfortunately when I use Squirrel SQL Client and try to configure the IAM
credentials to connect to the cluster I'm blocked and I can't insert the
needed values.

Is there anything I can do to connect to Redshift via IAM credentials using
Squirrel Client?

I am waiting for a kind reply,
Nicholas

Re: [Squirrel-sql-users] EXTERNAL: Query fails to execute

[Fritz, L. <Lar...@xy...>]

It seems the default values depend on the underlying platform, as I found this in the Oracle docs site from a link in the stackoverflow article you provided:

Default Value

-Xss default values are platform-specific, as defined in Table 2-9<https://docs.oracle.com/cd/E13150_01/jrockit_jvm/jrockit/jrdocs/refman/optionX.html#wp1024112>.
Table 2-9 -Xss Default Values

Platform

Default

Windows IA32

64 KB

Linux IA32

128 KB

Windows x86_64

128 KB

Linux x86_64

256 KB

Windows IA64

320 KB

Linux IA64

1024 KB (1 MB)

Solaris Sparc

512 KB




So in my case it's only 256K.  I will try experimenting with Xss instead of Xmx and see what happens.



Thx to all who responded!


Larry Fritz
Application Engineer | Sensus<https://sensus.com/> | Xylem<http://www.xyleminc.com/>
M:  469-275-6042
Lar...@xy...<mailto:Lar...@xy...>

LinkedIn<https://www.linkedin.com/company/sensus> | Twitter<https://twitter.com/SensusGlobal> | YouTube<https://www.youtube.com/c/SensusGlobal> | Facebook<https://www.facebook.com/SensusGlobal/> | Instagram<https://www.instagram.com/sensusglobal/> | 3D Tour<https://apps.kaonadn.net/5277329597136896/index.html>

[cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55]

-----Original Message-----
From: John Hardin [mailto:jh...@im...]
Sent: Tuesday, August 4, 2020 10:51
To: Squirrel SQL users list <squ...@li...>
Subject: Re: [Squirrel-sql-users] EXTERNAL: Query fails to execute



On Tue, 4 Aug 2020, Ferreira, Matt via Squirrel-sql-users wrote:



> Are you using the included shell script? My initial thought is that you might need to increase the max memory settings. The default is set to 256:

> -Xmx256m

>>

> From: Fritz, Larry <Lar...@xy...<mailto:Lar...@xy...>>

> Sent: Tuesday, August 4, 2020 10:34 AM

> To: squ...@li...<mailto:squ...@li...>

> Subject: EXTERNAL: [Squirrel-sql-users] Query fails to execute

>

> 2020-08-03 16:02:37,711 [AWT-EventQueue-1] ERROR

> net.sourceforge.squirrel_sql.client.Main  - Exception occurred

> dispatching Event

> java.awt.event.MouseEvent[MOUSE_RELEASED,(401,124),absolute(401,123),b

> utton=1,modifiers=Button1,clickCount=1] on frame0

> java.lang.StackOverflowError



I don't know whether adjusting the heap size (-Xmx) will help this one.

For a stack overflow error, also consider adding a -Xss parameter to the JRE command line, e.g. -Xss12m



see https://stackoverflow.com/questions/3700459/how-to-increase-the-java-stack-size



I don't know offhand what the default is so I can't suggest a new value, sorry.





--

  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/

  jh...@im...<mailto:jh...@im...>    FALaholic #11174     pgpk -a jh...@im...<mailto:jh...@im...>

  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79

-----------------------------------------------------------------------

   A good high-school education is still essential,

   and college is where you go to get one.            -- MiddleAgedKen

-----------------------------------------------------------------------

  Today: the 285th anniversary of John Peter Zenger's acquittal





_______________________________________________

Squirrel-sql-users mailing list

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

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