You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(48) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(13) |
Feb
(17) |
Mar
(30) |
Apr
(7) |
May
(3) |
Jun
|
Jul
(3) |
Aug
(10) |
Sep
(8) |
Oct
(28) |
Nov
(24) |
Dec
(6) |
| 2003 |
Jan
(2) |
Feb
(6) |
Mar
(3) |
Apr
(7) |
May
(11) |
Jun
(14) |
Jul
(39) |
Aug
(9) |
Sep
(4) |
Oct
(21) |
Nov
(6) |
Dec
(26) |
| 2004 |
Jan
(3) |
Feb
(18) |
Mar
(9) |
Apr
(19) |
May
(8) |
Jun
(14) |
Jul
(11) |
Aug
(22) |
Sep
(11) |
Oct
(6) |
Nov
|
Dec
(3) |
| 2005 |
Jan
(8) |
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
(8) |
Jul
(4) |
Aug
(8) |
Sep
(3) |
Oct
(19) |
Nov
(12) |
Dec
|
| 2006 |
Jan
(3) |
Feb
(5) |
Mar
(4) |
Apr
(5) |
May
|
Jun
|
Jul
(2) |
Aug
(6) |
Sep
(36) |
Oct
(10) |
Nov
(40) |
Dec
(17) |
| 2007 |
Jan
(5) |
Feb
(2) |
Mar
(10) |
Apr
(7) |
May
(26) |
Jun
(31) |
Jul
(14) |
Aug
(12) |
Sep
(14) |
Oct
(8) |
Nov
(1) |
Dec
(9) |
| 2008 |
Jan
(2) |
Feb
(13) |
Mar
(3) |
Apr
(8) |
May
(1) |
Jun
(3) |
Jul
(6) |
Aug
(16) |
Sep
(2) |
Oct
|
Nov
(8) |
Dec
(3) |
| 2009 |
Jan
(2) |
Feb
(2) |
Mar
(4) |
Apr
(8) |
May
(5) |
Jun
(7) |
Jul
(1) |
Aug
(6) |
Sep
(5) |
Oct
(2) |
Nov
(3) |
Dec
(3) |
| 2010 |
Jan
(11) |
Feb
(7) |
Mar
(2) |
Apr
(4) |
May
|
Jun
(2) |
Jul
(2) |
Aug
(5) |
Sep
|
Oct
(5) |
Nov
(6) |
Dec
(4) |
| 2011 |
Jan
(7) |
Feb
(4) |
Mar
(26) |
Apr
(3) |
May
|
Jun
|
Jul
(10) |
Aug
(11) |
Sep
(11) |
Oct
(3) |
Nov
(3) |
Dec
|
| 2012 |
Jan
(5) |
Feb
(4) |
Mar
(4) |
Apr
(2) |
May
(7) |
Jun
(1) |
Jul
(2) |
Aug
(1) |
Sep
(2) |
Oct
(10) |
Nov
(2) |
Dec
(4) |
| 2013 |
Jan
(3) |
Feb
(3) |
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
(2) |
Aug
(1) |
Sep
(5) |
Oct
(1) |
Nov
(5) |
Dec
(11) |
| 2014 |
Jan
|
Feb
(5) |
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
(4) |
Aug
(2) |
Sep
(2) |
Oct
|
Nov
(2) |
Dec
(1) |
| 2015 |
Jan
(2) |
Feb
(6) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
(1) |
Oct
|
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
(7) |
Mar
(3) |
Apr
(2) |
May
|
Jun
(5) |
Jul
(5) |
Aug
(1) |
Sep
(1) |
Oct
|
Nov
(3) |
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
|
Apr
(2) |
May
|
Jun
(3) |
Jul
(4) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
(6) |
Aug
(1) |
Sep
|
Oct
|
Nov
(6) |
Dec
|
| 2019 |
Jan
(1) |
Feb
(5) |
Mar
(3) |
Apr
|
May
(2) |
Jun
(2) |
Jul
|
Aug
|
Sep
(1) |
Oct
(2) |
Nov
(1) |
Dec
|
| 2020 |
Jan
(1) |
Feb
|
Mar
|
Apr
(4) |
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
(4) |
Dec
(2) |
| 2021 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2025 |
Jan
|
Feb
|
Mar
(3) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Gerd W. <ger...@t-...> - 2025-04-06 18:16:38
|
On 13.03.25 13:09, VERWERS, GARY wrote:> > I have been experimenting with updating the dependencies. I am > having some issues with JMeld as the new version has redefined > several API’s. > There is a fork of mine that wasn't merged yet by the JMeld maintainer. The fork is available here: https://github.com/gerdwagner/jmeld I just upgraded the fork to the latest version and checked it out. It seems to work alright. To build the updated version of the jar that is contained in SQuirreL you should build with Maven and use the attached patch of the pom.xml. > I would like to meet an talk about it. > I hope you don't mind sticking with the communication channels at GitHub or Sourceforge. Gerd |
|
From: VERWERS, G. <gv...@at...> - 2025-03-13 16:29:24
|
Thank you for responding to my request. I have no problem meeting all your requirements. The Gradle build will faster not slower. We should be able to do a complete build in well under 60 seconds. I started with a core build in under a second. I have been experimenting with updating the dependencies. I am having some issues with JMeld as the new version has redefined several API’s. I would like to meet an talk about it. From: Gerd Wagner <ger...@t-...> Sent: Wednesday, March 12, 2025 2:51 PM To: VERWERS, GARY <gv...@at...>; squ...@li... Cc: PULLABHOTLA, DILIP K <DP...@at...> Subject: Re: [Squirrel-sql-develop] I would like to convert Squirrel Sql into a gradle project. On 28. 02. 25 20: 46, VERWERS, GARY wrote: > Hi > > I want to convert Squirrel Sql into a gradle project and map all its dependencies to the Maven Repository. > > But I don't want to go to all that effort it you will not accept the On 28.02.25 20:46, VERWERS, GARY wrote: > Hi > > I want to convert Squirrel Sql into a gradle project and map all its dependencies to the Maven Repository. > > But I don't want to go to all that effort it you will not accept the change. It should make it easier to build, test, and deploy. > > Once that is done then we can start talking about updating the dependencies as many of them are dated. > > Please send me your feedback. > First of all thanks for your interest in SQuirreL and your offer. Here are some things I expect: 1. The build script should not be more complicated than today's Ant script. It would be Ok if it was somewhat longer because of the dependency list. 2. It must include building SQuirreL's plugins. 3. There is at least one dependency (rsyntax_RText-6.0.2.jar) which isn't available in Maven repositories. 4. Some of SQuirreL's libs are somewhat "hand crafted": -- There are libs with prefixes showing where they belong to, e.g. poi... -- There are libs packed as fat jar, e.g. jgit6.0.0.202111291000-r-with-dependencies.jar. -- Some dependencies of the libs are not included in SQuirreL's libs today. Including these should not make SQuirreL much bigger. If you see a chance to cope with these expectations feel free to give it a try. Nonetheless I won't guarantee I'll take the script without looking at it and without trying it out. Gerd |
|
From: Gerd W. <ger...@t-...> - 2025-03-12 19:51:32
|
On 28.02.25 20:46, VERWERS, GARY wrote: > Hi > > I want to convert Squirrel Sql into a gradle project and map all its dependencies to the Maven Repository. > > But I don't want to go to all that effort it you will not accept the change. It should make it easier to build, test, and deploy. > > Once that is done then we can start talking about updating the dependencies as many of them are dated. > > Please send me your feedback. > First of all thanks for your interest in SQuirreL and your offer. Here are some things I expect: 1. The build script should not be more complicated than today's Ant script. It would be Ok if it was somewhat longer because of the dependency list. 2. It must include building SQuirreL's plugins. 3. There is at least one dependency (rsyntax_RText-6.0.2.jar) which isn't available in Maven repositories. 4. Some of SQuirreL's libs are somewhat "hand crafted": -- There are libs with prefixes showing where they belong to, e.g. poi... -- There are libs packed as fat jar, e.g. jgit6.0.0.202111291000-r-with-dependencies.jar. -- Some dependencies of the libs are not included in SQuirreL's libs today. Including these should not make SQuirreL much bigger. If you see a chance to cope with these expectations feel free to give it a try. Nonetheless I won't guarantee I'll take the script without looking at it and without trying it out. Gerd |
|
From: VERWERS, G. <gv...@at...> - 2025-03-01 01:31:24
|
Hi I want to convert Squirrel Sql into a gradle project and map all its dependencies to the Maven Repository. But I don't want to go to all that effort it you will not accept the change. It should make it easier to build, test, and deploy. Once that is done then we can start talking about updating the dependencies as many of them are dated. Please send me your feedback. |
|
From: <Ste...@ha...> - 2023-03-14 14:17:11
|
Hello Gerd, manufacturer Progress confirmed it's a bad driver: "due to a product limitation always returns read committed" may I raise a change request: Option "Use URL only for reconnect" to skip this: Squirrel restores in a reconnected connection - Isolation level, which is your concern - Auto commit - Catalog, when applicable All these properties are read using standard JDBC API functions //Stefan ================================== Hannover Rück SE, Handelsregister (Commercial Register) Hannover HRB 6778 / E+S Rückversicherung AG, Handelsregister (Commercial Register) Hannover HRB 6117; für beide Gesellschaften gilt (applicable to both companies): Karl-Wiechert-Allee 50, 30625 Hannover, Germany; Sitz (registered office) der Gesellschaften: Hannover; Aufsichtsrat (Supervisory Board) Hannover Rück SE: Torsten Leue (Vorsitzender/Chairman). Vorstand (Executive Board) Hannover Rück SE: Jean-Jacques Henchoz (Vorsitzender/Chairman), Sven Althoff, Claude Chèvre, Clemens Jungsthöfel, Dr. Klaus Miller, Sharon Ooi,Dr. Michael Pickel, Silke Sehm; Aufsichtsrat (Supervisory Board) E+S Rückversicherung AG: Torsten Leue; Vorstand (Executive Board) E+S Rückversicherung AG: Dr. Michael Pickel (Vorsitzender/Chairman), Clemens Jungsthöfel, Dr. Klaus Miller Data privacy notice: We process personal data for our business purposes (e.g. providing reinsurance, reviewing and managing claims, advising insurers). Where the purpose of processing is to deal with other inquiries, the legal basis for processing is Art. 6 (1) f) GDPR (legitimate interest). As the responsible controller under data protection law, we provide information in accordance with the respective legal provisions governing data protection (e.g. further processing purposes, storage period, rights of data subjects): For Hannover Rück SE: https://www.hannover-re.com/privacy | For E+S Rückversicherung AG: https://www.es-rueck.de/datenschutz-es Hinweis zum Datenschutz: Wir verarbeiten personenbezogene Daten für unsere Geschäftszwecke (z.B. Angebot von Rückversicherung, Schadenprüfung und -regulierung, Beratung von Versicherungsunternehmen). Erfolgt die Verarbeitung zur Bearbeitung sonstiger Anfragen, ist die Rechtsgrundlage der Verarbeitung Art. 6 Abs. 1 f) DSGVO (berechtigtes Interesse). Als datenschutzrechtlich Verantwortliche informieren wir jeweils gemäß den gesetzlichen Bestimmungen zum Datenschutz (z.B. weitere Verarbeitungszwecke, Speicherdauer, Betroffenenrechte): Für die Hannover Rück SE: https://www.hannover-rueck.de/datenschutz | Für die E+S Rückversicherung AG: https://www.es-rueck.de/datenschutz-es |
|
From: Gerd W. <ger...@t-...> - 2023-03-12 19:09:06
|
Hello Stefan, Am 11.03.23 um 11:28 schrieb Ste...@ha...: > Is there a workaround in case of a bug in the driver? > Maybe Keep alive (the cause of reconnect): "SELECT 1 FROM [little table]where 1 = 0;" > This option exists: Open your Alias dialog. Click the Properties button. In the Properties dialog see the last tab named Connection. Gerd |
|
From: <Ste...@ha...> - 2023-03-11 10:28:52
|
Hello Gerd, Thank you for the detailed explanation, I never saw the "+" sign but wondered about the reconnection dialog in the source. If I understand it correctly the status should be a live status because transaction level is changed after connection has been established. But it shows the initial value: TRANSACTION_READ_COMMITTED I used the session script plugin but it's not rerun during reconnect. Then I tried this method in the connection string and failed too. Is there a workaround in case of a bug in the driver? Maybe Keep alive (the cause of reconnect): "SELECT 1 FROM [little table]where 1 = 0;" So this means it's a driver bug returning the incorrect transaction level. Plan B would be to implement an option for reconnect not to restore the current properties, simple skip the part reading and re-setting dynamic properties. (to get rid of poor drivers like this one which takes readonly but ignores it, no cancel, ...) //Stefan https://community.progress.com/s/article/P22446 -----Original Message----- From: Gerd Wagner <ger...@t-...> Sent: Samstag, 11. März 2023 03:03 To: Marquardt Stefan <Ste...@ha...>; squ...@li... Subject: Re: [Squirrel-sql-develop] Reconnect ignores URL settings (4.5.1) Am 08.03.23 um 07:33 schrieb Ste...@ha...: > After running a lot of tests I can confirm that the reconnect function > does NOT create a 100% identical session The Initialization String is not used anymore, need to check the code what reconnect is doing because defaultSchema is still the same after reconnect. > This is confusing that only a part of the URL seems to be used. > > jdbc:datadirect:openedge://localhost:12001;databaseName=test;truncateT > ooLarge=off;defaultSchema=pub;setQueryTimeout=60;InitializationString= > (SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED); > Could you please check the following: - Open a new Session - Click the topmost node in the Object tree - Select tab "Status" on the right - What transactionisolationLevel is displayed there? I suspect it is not "TRANSACTION_READ_UNCOMMITTED". If so please contact your JDBC driver vendor and ask him to return the correct isolation level when java.sql.Connection.getTransactionIsolation() is called. Some background information: As long as you don't edit the connection data in the reconnect dialog (see "+"-button) SQuirreL uses exactly the data given in your alias. But there are some properties that SQuirreL restores in a reconnected connection. Those are - Isolation level, which is your concern - Auto commit - Catalog, when applicable all these properties are read using standard JDBC API functions as for example java.sql.Connection.getTransactionIsolation(). Gerd ================================== Hannover Rück SE, Handelsregister (Commercial Register) Hannover HRB 6778 / E+S Rückversicherung AG, Handelsregister (Commercial Register) Hannover HRB 6117; für beide Gesellschaften gilt (applicable to both companies): Karl-Wiechert-Allee 50, 30625 Hannover, Germany; Sitz (registered office) der Gesellschaften: Hannover; Aufsichtsrat (Supervisory Board) Hannover Rück SE: Torsten Leue (Vorsitzender/Chairman). Vorstand (Executive Board) Hannover Rück SE: Jean-Jacques Henchoz (Vorsitzender/Chairman), Sven Althoff, Claude Chèvre, Clemens Jungsthöfel, Dr. Klaus Miller, Sharon Ooi,Dr. Michael Pickel, Silke Sehm; Aufsichtsrat (Supervisory Board) E+S Rückversicherung AG: Torsten Leue; Vorstand (Executive Board) E+S Rückversicherung AG: Dr. Michael Pickel (Vorsitzender/Chairman), Clemens Jungsthöfel, Dr. Klaus Miller Data privacy notice: We process personal data for our business purposes (e.g. providing reinsurance, reviewing and managing claims, advising insurers). Where the purpose of processing is to deal with other inquiries, the legal basis for processing is Art. 6 (1) f) GDPR (legitimate interest). As the responsible controller under data protection law, we provide information in accordance with the respective legal provisions governing data protection (e.g. further processing purposes, storage period, rights of data subjects): For Hannover Rück SE: https://www.hannover-re.com/privacy | For E+S Rückversicherung AG: https://www.es-rueck.de/datenschutz-es Hinweis zum Datenschutz: Wir verarbeiten personenbezogene Daten für unsere Geschäftszwecke (z.B. Angebot von Rückversicherung, Schadenprüfung und -regulierung, Beratung von Versicherungsunternehmen). Erfolgt die Verarbeitung zur Bearbeitung sonstiger Anfragen, ist die Rechtsgrundlage der Verarbeitung Art. 6 Abs. 1 f) DSGVO (berechtigtes Interesse). Als datenschutzrechtlich Verantwortliche informieren wir jeweils gemäß den gesetzlichen Bestimmungen zum Datenschutz (z.B. weitere Verarbeitungszwecke, Speicherdauer, Betroffenenrechte): Für die Hannover Rück SE: https://www.hannover-rueck.de/datenschutz | Für die E+S Rückversicherung AG: https://www.es-rueck.de/datenschutz-es |
|
From: Gerd W. <ger...@t-...> - 2023-03-11 02:03:06
|
Am 08.03.23 um 07:33 schrieb Ste...@ha...: > After running a lot of tests I can confirm that the reconnect function does NOT create a 100% identical session > The Initialization String is not used anymore, need to check the code what reconnect is doing because defaultSchema is still the same after reconnect. > This is confusing that only a part of the URL seems to be used. > > jdbc:datadirect:openedge://localhost:12001;databaseName=test;truncateTooLarge=off;defaultSchema=pub;setQueryTimeout=60;InitializationString=(SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED); > Could you please check the following: - Open a new Session - Click the topmost node in the Object tree - Select tab "Status" on the right - What transactionisolationLevel is displayed there? I suspect it is not "TRANSACTION_READ_UNCOMMITTED". If so please contact your JDBC driver vendor and ask him to return the correct isolation level when java.sql.Connection.getTransactionIsolation() is called. Some background information: As long as you don't edit the connection data in the reconnect dialog (see "+"-button) SQuirreL uses exactly the data given in your alias. But there are some properties that SQuirreL restores in a reconnected connection. Those are - Isolation level, which is your concern - Auto commit - Catalog, when applicable all these properties are read using standard JDBC API functions as for example java.sql.Connection.getTransactionIsolation(). Gerd |
|
From: <Ste...@ha...> - 2023-03-08 06:52:45
|
After running a lot of tests I can confirm that the reconnect function does NOT create a 100% identical session The Initialization String is not used anymore, need to check the code what reconnect is doing because defaultSchema is still the same after reconnect. This is confusing that only a part of the URL seems to be used. jdbc:datadirect:openedge://localhost:12001;databaseName=test;truncateTooLarge=off;defaultSchema=pub;setQueryTimeout=60;InitializationString=(SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED); ================================== Hannover Rück SE, Handelsregister (Commercial Register) Hannover HRB 6778 / E+S Rückversicherung AG, Handelsregister (Commercial Register) Hannover HRB 6117; für beide Gesellschaften gilt (applicable to both companies): Karl-Wiechert-Allee 50, 30625 Hannover, Germany; Sitz (registered office) der Gesellschaften: Hannover; Aufsichtsrat (Supervisory Board) Hannover Rück SE: Torsten Leue (Vorsitzender/Chairman). Vorstand (Executive Board) Hannover Rück SE: Jean-Jacques Henchoz (Vorsitzender/Chairman), Sven Althoff, Claude Chèvre, Clemens Jungsthöfel, Dr. Klaus Miller, Sharon Ooi,Dr. Michael Pickel, Silke Sehm; Aufsichtsrat (Supervisory Board) E+S Rückversicherung AG: Torsten Leue; Vorstand (Executive Board) E+S Rückversicherung AG: Dr. Michael Pickel (Vorsitzender/Chairman), Clemens Jungsthöfel, Dr. Klaus Miller Data privacy notice: We process personal data for our business purposes (e.g. providing reinsurance, reviewing and managing claims, advising insurers). Where the purpose of processing is to deal with other inquiries, the legal basis for processing is Art. 6 (1) f) GDPR (legitimate interest). As the responsible controller under data protection law, we provide information in accordance with the respective legal provisions governing data protection (e.g. further processing purposes, storage period, rights of data subjects): For Hannover Rück SE: https://www.hannover-re.com/privacy | For E+S Rückversicherung AG: https://www.es-rueck.de/datenschutz-es Hinweis zum Datenschutz: Wir verarbeiten personenbezogene Daten für unsere Geschäftszwecke (z.B. Angebot von Rückversicherung, Schadenprüfung und -regulierung, Beratung von Versicherungsunternehmen). Erfolgt die Verarbeitung zur Bearbeitung sonstiger Anfragen, ist die Rechtsgrundlage der Verarbeitung Art. 6 Abs. 1 f) DSGVO (berechtigtes Interesse). Als datenschutzrechtlich Verantwortliche informieren wir jeweils gemäß den gesetzlichen Bestimmungen zum Datenschutz (z.B. weitere Verarbeitungszwecke, Speicherdauer, Betroffenenrechte): Für die Hannover Rück SE: https://www.hannover-rueck.de/datenschutz | Für die E+S Rückversicherung AG: https://www.es-rueck.de/datenschutz-es |
|
From: Tim E. <tl...@ho...> - 2021-02-25 01:09:02
|
Thanks for the endorsement :) Here is the pull request for squirrel-sql to be added to the flathub repository: https://github.com/flathub/flathub/pull/2130 Here is a merge request (suggested by the flathub team) to host some of the metadata files in the squirrel sql repo: https://sourceforge.net/p/squirrel-sql/git/merge-requests/75/ On Tue, Feb 23, 2021 at 1:04 AM Johnathan James <ha...@gm...> wrote: > As a long time user with absolutely no say in how this project runs, I > think the flatpak is a great idea. > > On Mon, Feb 22, 2021 at 5:56 PM Tim Elliott <tl...@ho...> wrote: > >> I made some improvements: >> >> - The manifest now pulls in JDBC drivers for MySQL, PostgreSQL, and >> SQLite. >> - JDBC drivers are now in the classpath and no extra configuration is >> needed. >> - The SQuirreL SQL settings directory was changed to $XDG_CONFIG_HOME >> where flatpak expects config files to be stored. >> >> If there aren't any objections, I would like to submit this to the flathub >> registry. >> >> Thanks, >> Tim >> >> On Sat, Feb 20, 2021 at 1:03 AM Tim Elliott <tl...@ho...> wrote: >> >> > I packaged SQuirreL SQL as a Flatpak. The repository is here: >> > >> > https://github.com/ender672/flathub >> > >> > For now, I'm experimenting with this for personal use. Perhaps it can be >> > improved and submitted to a registry someday. Some issues: >> > >> > - The sandbox permissions are pretty restrictive at this point. The >> > only filesystems permissions are for a persistent (but sandboxed) >> > ~/.squirrel-sql directory. >> > - I only included the mariadb java connector, and it has to be >> > configured by adding the class path >> > /app/mariadb-java-connector/mariadb-java-client.jar to the driver. >> > - I'm not sure if I correctly named the flatpak app id >> > (org.squirrelsql.squirrelsql) >> > >> > Any feedback or suggestions for the above would be appreciated. >> > >> > Thanks, >> > Tim >> > >> >> _______________________________________________ >> Squirrel-sql-develop mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop >> > |
|
From: Johnathan J. <ha...@gm...> - 2021-02-23 01:04:34
|
As a long time user with absolutely no say in how this project runs, I think the flatpak is a great idea. On Mon, Feb 22, 2021 at 5:56 PM Tim Elliott <tl...@ho...> wrote: > I made some improvements: > > - The manifest now pulls in JDBC drivers for MySQL, PostgreSQL, and > SQLite. > - JDBC drivers are now in the classpath and no extra configuration is > needed. > - The SQuirreL SQL settings directory was changed to $XDG_CONFIG_HOME > where flatpak expects config files to be stored. > > If there aren't any objections, I would like to submit this to the flathub > registry. > > Thanks, > Tim > > On Sat, Feb 20, 2021 at 1:03 AM Tim Elliott <tl...@ho...> wrote: > > > I packaged SQuirreL SQL as a Flatpak. The repository is here: > > > > https://github.com/ender672/flathub > > > > For now, I'm experimenting with this for personal use. Perhaps it can be > > improved and submitted to a registry someday. Some issues: > > > > - The sandbox permissions are pretty restrictive at this point. The > > only filesystems permissions are for a persistent (but sandboxed) > > ~/.squirrel-sql directory. > > - I only included the mariadb java connector, and it has to be > > configured by adding the class path > > /app/mariadb-java-connector/mariadb-java-client.jar to the driver. > > - I'm not sure if I correctly named the flatpak app id > > (org.squirrelsql.squirrelsql) > > > > Any feedback or suggestions for the above would be appreciated. > > > > Thanks, > > Tim > > > > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
|
From: Tim E. <tl...@ho...> - 2021-02-23 00:56:37
|
I made some improvements: - The manifest now pulls in JDBC drivers for MySQL, PostgreSQL, and SQLite. - JDBC drivers are now in the classpath and no extra configuration is needed. - The SQuirreL SQL settings directory was changed to $XDG_CONFIG_HOME where flatpak expects config files to be stored. If there aren't any objections, I would like to submit this to the flathub registry. Thanks, Tim On Sat, Feb 20, 2021 at 1:03 AM Tim Elliott <tl...@ho...> wrote: > I packaged SQuirreL SQL as a Flatpak. The repository is here: > > https://github.com/ender672/flathub > > For now, I'm experimenting with this for personal use. Perhaps it can be > improved and submitted to a registry someday. Some issues: > > - The sandbox permissions are pretty restrictive at this point. The > only filesystems permissions are for a persistent (but sandboxed) > ~/.squirrel-sql directory. > - I only included the mariadb java connector, and it has to be > configured by adding the class path > /app/mariadb-java-connector/mariadb-java-client.jar to the driver. > - I'm not sure if I correctly named the flatpak app id > (org.squirrelsql.squirrelsql) > > Any feedback or suggestions for the above would be appreciated. > > Thanks, > Tim > |
|
From: Tim E. <tl...@ho...> - 2021-02-20 02:00:53
|
I packaged SQuirreL SQL as a Flatpak. The repository is here: https://github.com/ender672/flathub For now, I'm experimenting with this for personal use. Perhaps it can be improved and submitted to a registry someday. Some issues: - The sandbox permissions are pretty restrictive at this point. The only filesystems permissions are for a persistent (but sandboxed) ~/.squirrel-sql directory. - I only included the mariadb java connector, and it has to be configured by adding the class path /app/mariadb-java-connector/mariadb-java-client.jar to the driver. - I'm not sure if I correctly named the flatpak app id (org.squirrelsql.squirrelsql) Any feedback or suggestions for the above would be appreciated. Thanks, Tim |
|
From: Luca V. <luc...@gm...> - 2021-02-10 21:48:07
|
Hello, I would like to advertise a project that I am currently developing. A web frontend for SQuirreL SQL. The project, with some screenshots, is available here: https://github.com/luca-vercelli/squirrel-sql-web The project is still under development. Frontend is developed with Vuetify, while backend is a JAX-RS wrapper around SQuirreL's jar. I hope somebody can be interested in it. Regards Luca |
|
From: jose l. f. d. <jos...@ho...> - 2021-02-01 20:41:43
|
2021-02-01 20:55:27,396 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################
2021-02-01 20:55:27,400 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - # Starting SQuirreL SQL Client snapshot-20201226_2251 at 1/02/21 20:55
2021-02-01 20:55:27,400 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - SQuirreL SQL Client snapshot-20201226_2251 started: Mon Feb 01 20:55:27 CET 2021
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - Copyright (c) 2001-2020
Colin Bell, Gerd Wagner, Rob Manning and others
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.vendor: Oracle Corporation
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.version: 1.8.0_281
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.runtime.name: Java(TM) SE Runtime Environment
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.name: Windows 10
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.version: 10.0
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.arch: amd64
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.dir: D:\Program Files\squirrel-sql-snapshot-20201226_2251
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.home: C:\Users\jlfdiaz
2021-02-01 20:55:27,405 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.home: C:\Program Files\Java\jre1.8.0_281
2021-02-01 20:55:29,568 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.laf.LAFRegister - Setting lookandfeel class: javax.swing.plaf.metal.MetalLookAndFeel
2021-02-01 20:55:30,660 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.plugin.PluginQueryTokenizerPreferencesManager - prefs.xml not found - will be created
2021-02-01 20:55:30,670 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.refactoring.prefs.RefactoringPreferencesManager - prefs.xml not found - will be created
2021-02-01 20:55:30,753 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin laf created in 1 ms, loaded in 1.128 ms, initialized in 0 ms, total 1.129 ms.
2021-02-01 20:55:30,753 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin sqlscript created in 0 ms, loaded in 0 ms, initialized in 12 ms, total 12 ms.
2021-02-01 20:55:30,754 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin oracle created in 2 ms, loaded in 0 ms, initialized in 34 ms, total 36 ms.
2021-02-01 20:55:30,754 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin refactoring created in 1 ms, loaded in 0 ms, initialized in 7 ms, total 8 ms.
2021-02-01 20:55:30,754 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin codecompletion created in 2 ms, loaded in 0 ms, initialized in 7 ms, total 9 ms.
2021-02-01 20:55:30,755 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin sqlbookmark created in 2 ms, loaded in 0 ms, initialized in 6 ms, total 8 ms.
2021-02-01 20:55:30,755 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin syntax created in 1 ms, loaded in 0 ms, initialized in 48 ms, total 49 ms.
2021-02-01 20:55:30,755 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin dataimport created in 1 ms, loaded in 1 ms, initialized in 1 ms, total 3 ms.
2021-02-01 20:55:30,756 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin dbcopy created in 1 ms, loaded in 0 ms, initialized in 9 ms, total 10 ms.
2021-02-01 20:55:30,756 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin dbdiff created in 2 ms, loaded in 0 ms, initialized in 5 ms, total 7 ms.
2021-02-01 20:55:30,756 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin graph created in 1 ms, loaded in 0 ms, initialized in 7 ms, total 8 ms.
2021-02-01 20:55:52,665 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.AxionDialectExt$AxionDialectHelper
2021-02-01 20:55:52,692 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DB2DialectExt$DB2DialectHelper
2021-02-01 20:55:52,694 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DaffodilDialectExt$DaffodilDialectHelper
2021-02-01 20:55:52,695 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DB2DialectExt$DB2DialectHelper
2021-02-01 20:55:52,695 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DerbyDialectExt$DerbyDialectHelper
2021-02-01 20:55:52,697 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.FirebirdDialectExt$FirebirdDialectHelper
2021-02-01 20:55:52,699 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.FrontBaseDialectExt$FrontBaseDialectHelper
2021-02-01 20:55:52,699 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.GenericDialectHelper
2021-02-01 20:55:52,700 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.HADBDialectExt$HADBDialectHelper
2021-02-01 20:55:52,701 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.H2DialectExt$H2DialectHelper
2021-02-01 20:55:52,705 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.HSQLDialectExt$HSQLDialectHelper
2021-02-01 20:55:52,711 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.InformixDialectExt$InformixDialectHelper
2021-02-01 20:55:52,713 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.InterbaseDialectExt$InterbaseDialectHelper
2021-02-01 20:55:52,715 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.IngresDialectExt$IngresDialectHelper
2021-02-01 20:55:52,719 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.MAXDBDialectExt$MAXDBDialectHelper
2021-02-01 20:55:52,721 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.McKoiDialectExt$McKoiDialectHelper
2021-02-01 20:55:52,724 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.MySQLDialectExt$MySQLDialectHelper
2021-02-01 20:55:52,724 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.MySQLDialectExt$MySQLDialectHelper
2021-02-01 20:55:52,727 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.NetezzaDialextExt$NetezzaDialectHelper
2021-02-01 20:55:52,728 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.GreenplumDialectExt$GreenplumDialectHelper
2021-02-01 20:55:52,730 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.OracleDialectExt$OracleDialectHelper
2021-02-01 20:55:52,731 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.PointbaseDialectExt$PointbaseDialectHelper
2021-02-01 20:55:52,733 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.PostgreSQLDialectExt$PostgreSQLDialectHelper
2021-02-01 20:55:52,734 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.ProgressDialectExt$ProgressDialectHelper
2021-02-01 20:55:52,736 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.SybaseDialectExt$SybaseDialectHelper
2021-02-01 20:55:52,736 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.SybaseDialectExt$SybaseDialectHelper
2021-02-01 20:55:52,737 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.SQLServerDialectExt$SQLServerDialectHelper
2021-02-01 20:55:52,738 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.TimesTenDialectExt$TimesTenDialectHelper
2021-02-01 20:55:52,740 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.IntersystemsCacheDialectExt$CacheHelper
2021-02-01 20:55:52,741 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.GenericDialectHelper
2021-02-01 20:55:52,826 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual
2021-02-01 20:55:53,869 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin - setTimezoneForSession: attempting to set the session timezone to : Europe/Paris
2021-02-01 20:57:11,979 [Thread-6] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed to load stored procedures
java.sql.SQLSyntaxErrorException: ORA-00904: "ALL_ARGUMENTS"."SUBPROGRAM_ID": identificador no válido
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
at oracle.jdbc.OracleDatabaseMetaData.getProcedures(OracleDatabaseMetaData.java:1837)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:755)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:531)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:367)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:305)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:188)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:293)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
Caused by: Error : 904, Position : 1203, Sql = SELECT
-- Standalone procedures and functions
NULL AS procedure_cat,
owner AS procedure_schem,
object_name AS procedure_name,
NULL,
NULL,
NULL,
'Standalone procedure or function' AS remarks,
DECODE(object_type, 'PROCEDURE', 1,
'FUNCTION', 2,
0) AS procedure_type
, NULL AS specific_name
FROM all_objects
WHERE (object_type = 'PROCEDURE' OR object_type = 'FUNCTION')
AND owner LIKE :1 ESCAPE '/'
AND object_name LIKE :2 ESCAPE '/'
UNION ALL SELECT
-- Packaged procedures --
object_name AS procedure_cat,
owner AS procedure_schem,
procedure_name AS procedure_name,
NULL,
NULL,
NULL,
'Packaged procedure' AS remarks,
1 AS procedure_type
, NULL AS specific_name
FROM all_procedures
WHERE procedure_name IS NOT NULL
AND object_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND procedure_name LIKE :7 ESCAPE '/'
AND NOT EXISTS (SELECT NULL
FROM all_arguments
WHERE argument_name IS NULL
AND in_out = 'OUT'
AND data_level = 0
AND package_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND object_name LIKE :7 ESCAPE '/'
AND all_procedures.object_id = all_arguments.object_id AND all_procedures.subprogram_id = all_arguments.subprogram_id)UNION ALL SELECT
-- Packaged functions
package_name AS procedure_cat,
owner AS procedure_schem,
object_name AS procedure_name,
NULL,
NULL,
NULL,
'Packaged function' AS remarks,
2 AS procedure_type
, NULL AS specific_name
FROM all_arguments
WHERE argument_name IS NULL
AND in_out = 'OUT'
AND data_level = 0
AND package_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND object_name LIKE :7 ESCAPE '/'
ORDER BY procedure_schem, procedure_name
, OriginalSql = SELECT
-- Standalone procedures and functions
NULL AS procedure_cat,
owner AS procedure_schem,
object_name AS procedure_name,
NULL,
NULL,
NULL,
'Standalone procedure or function' AS remarks,
DECODE(object_type, 'PROCEDURE', 1,
'FUNCTION', 2,
0) AS procedure_type
, NULL AS specific_name
FROM all_objects
WHERE (object_type = 'PROCEDURE' OR object_type = 'FUNCTION')
AND owner LIKE :1 ESCAPE '/'
AND object_name LIKE :2 ESCAPE '/'
UNION ALL SELECT
-- Packaged procedures --
object_name AS procedure_cat,
owner AS procedure_schem,
procedure_name AS procedure_name,
NULL,
NULL,
NULL,
'Packaged procedure' AS remarks,
1 AS procedure_type
, NULL AS specific_name
FROM all_procedures
WHERE procedure_name IS NOT NULL
AND object_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND procedure_name LIKE :7 ESCAPE '/'
AND NOT EXISTS (SELECT NULL
FROM all_arguments
WHERE argument_name IS NULL
AND in_out = 'OUT'
AND data_level = 0
AND package_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND object_name LIKE :7 ESCAPE '/'
AND all_procedures.object_id = all_arguments.object_id AND all_procedures.subprogram_id = all_arguments.subprogram_id)UNION ALL SELECT
-- Packaged functions
package_name AS procedure_cat,
owner AS procedure_schem,
object_name AS procedure_name,
NULL,
NULL,
NULL,
'Packaged function' AS remarks,
2 AS procedure_type
, NULL AS specific_name
FROM all_arguments
WHERE argument_name IS NULL
AND in_out = 'OUT'
AND data_level = 0
AND package_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND object_name LIKE :7 ESCAPE '/'
ORDER BY procedure_schem, procedure_name
, Error Msg = ORA-00904: "ALL_ARGUMENTS"."SUBPROGRAM_ID": identificador no válido
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 24 more
|
|
From: Gerd W. <ger...@t-...> - 2021-01-11 20:50:57
|
Am 05.01.21 um 18:05 schrieb jose luis fernandez diaz: > Hi, > > I can't start "SQL Squirrel". See attached log file. > The log looks like there was a problem with your SQuirreL user directory. You could try a new SQuirreL installation into an empty directory. If that doesn't help you may try to rename your existing SQuirreL user directory and let SQuirreL create a new one from scratch. The just released snapshot "snapshot-20210111_2140" would probably give better log messages in your scenario. You may give that a try, too. Gerd |
|
From: jose l. f. d. <jos...@ho...> - 2021-01-05 17:40:25
|
Hi, I can't start "SQL Squirrel". See attached log file. Regards, Jose Luis |
|
From: jose l. f. d. <jos...@ho...> - 2020-12-08 15:38:14
|
Hi, When I try to open a new session this error is shown: Logged by net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCacheSerializer at 8/12/20 15:59: Failed to load Schema cache. Note: this can happen when the SQuirreL version changed STACK TRACE java.io.StreamCorruptedException: invalid type code: 00 at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.util.ArrayList.readObject(Unknown Source) at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at java.io.ObjectStreamClass.invokeReadObject(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.util.TreeMap.buildFromSorted(Unknown Source) at java.util.TreeMap.buildFromSorted(Unknown Source) at java.util.TreeMap.buildFromSorted(Unknown Source) at java.util.TreeMap.buildFromSorted(Unknown Source) at java.util.TreeMap.buildFromSorted(Unknown Source) at java.util.TreeMap.buildFromSorted(Unknown Source) at java.util.TreeMap.buildFromSorted(Unknown Source) at java.util.TreeMap.buildFromSorted(Unknown Source) at java.util.TreeMap.readObject(Unknown Source) at sun.reflect.GeneratedMethodAccessor88.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at java.io.ObjectStreamClass.invokeReadObject(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.defaultReadFields(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.defaultReadFields(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.defaultReadFields(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCacheSerializer.privateLoad(SchemaInfoCacheSerializer.java:84) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCacheSerializer.load(SchemaInfoCacheSerializer.java:38) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:171) at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:240) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Unknown Source) Regards, Jose Luis |
|
From: jose l. f. d. <jos...@ho...> - 2020-12-07 20:46:27
|
Hi, Please, delete this bug. The problem was that my user only had read permission on that file. It is not a issue of "SQL Squirrel" Regards, Jose Luis. ________________________________ De: jose luis fernandez diaz <jos...@ho...> Enviado: domingo, 22 de noviembre de 2020 21:58 Para: squ...@li... <squ...@li...> Asunto: props.properties (Access Denied) Hi, When I try to exit "SQL Squirrel" it shows this error: java.lang.RuntimeException: java.io.FileNotFoundException: C:\Users\jose_\.squirrel-sql\props.properties (Acceso denegado) But the file exists and I can open it with Notepad. See attached images. Regards, Jose Luis |
|
From: jose l. f. d. <jos...@ho...> - 2020-11-24 18:21:56
|
Hi, Client gone stalled for 30 minutes while writing. This is the log: 2020-11-23 21:20:29,651 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:25:29,710 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:30:29,783 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:35:29,848 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:40:29,944 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:45:30,024 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 08:27:00,644 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 08:27:00,981 [Session Connection Keep-Alive (FACC)] ERROR net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - run: unexpected exception while executing sql (select 1 from dual ): Excepción de E/S: Connection reset by peer: socket write error java.sql.SQLException: Excepción de E/S: Connection reset by peer: socket write error at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:820) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1315) at net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive.run(SessionConnectionKeepAlive.java:78) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-11-24 08:32:01,014 [Session Connection Keep-Alive (FACC)] ERROR net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - run: unexpected exception while executing sql (select 1 from dual ): Conexión cerrada java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:780) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:756) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.createStatement(SQLConnection.java:277) at net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive.run(SessionConnectionKeepAlive.java:74) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-11-24 08:37:01,022 [Session Connection Keep-Alive (FACC)] ERROR net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - run: unexpected exception while executing sql (select 1 from dual java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:780) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:756) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.createStatement(SQLConnection.java:277) at net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive.run(SessionConnectionKeepAlive.java:74) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-11-24 08:42:01,025 [Session Connection Keep-Alive (FACC)] ERROR net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - run: unexpected exception while executing sql (select 1 from dual ): Conexión cerrada java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:780) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:756) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.createStatement(SQLConnection.java:277) at net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive.run(SessionConnectionKeepAlive.java:74) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-11-24 08:46:30,821 [Thread-2] ERROR net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter - getErrorPosition: Unexpected exception - Conexión cerrada java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:977) at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:943) at net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter.getErrorPosition(OracleExceptionFormatter.java:206) at net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter.format(OracleExceptionFormatter.java:152) at net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter.format(DefaultExceptionFormatter.java:68) at net.sourceforge.squirrel_sql.client.session.Session.formatException(Session.java:1195) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionHandler.sqlExecutionException(SQLExecutionHandler.java:458) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.handleError(SQLExecuterTask.java:621) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.runDirect(SQLExecuterTask.java:264) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:137) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-11-24 08:46:33,470 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.fw.sql.SQLConnection - Error while closing connection java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Conexión cerrada at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:206) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.close(SQLConnection.java:122) at net.sourceforge.squirrel_sql.client.session.Session.closeSQLConnection(Session.java:548) at net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:588) at net.sourceforge.squirrel_sql.client.session.action.reconnect.ReconnectAction.actionPerformed(ReconnectAction.java:55) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.AbstractButton.doClick(AbstractButton.java:376) at javax.swing.AbstractButton.doClick(AbstractButton.java:356) at javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:811) at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1668) at javax.swing.JComponent.processKeyBinding(JComponent.java:2882) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:699) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:677) at javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:307) at javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:293) at javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2974) at javax.swing.JComponent.processKeyBindings(JComponent.java:2966) at javax.swing.JComponent.processKeyEvent(JComponent.java:2845) at java.awt.Component.processEvent(Component.java:6316) at java.awt.Container.processEvent(Container.java:2239) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:835) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1103) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:974) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:800) at java.awt.Component.dispatchEventImpl(Component.java:4760) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Window.dispatchEventImpl(Window.java:2746) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84) at java.awt.EventQueue$4.run(EventQueue.java:733) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.awt.EventQueue.dispatchEvent(EventQueue.java:730) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) Caused by: java.lang.RuntimeException: java.sql.SQLException: Conexión cerrada at net.sourceforge.squirrel_sql.fw.sql.SQLConnection._closeIntern(SQLConnection.java:181) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.lambda$close$0(SQLConnection.java:120) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1195) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection._closeIntern(SQLConnection.java:160) ... 6 more 2020-11-24 08:46:34,307 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Successfully restored database meta data 2020-11-24 08:46:34,309 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 08:51:34,409 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 08:53:29,010 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=net.sourceforge.squirrel_sql.client.session.parser.ParserEventsProcessor$$Lambda$186/1854716438@784a69bf,notifier=null,catchExceptions=false,when=1606204409009] on sun.awt.windows.WToolkit@5578757b net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 8, column 66. Encountered: <EOF> after : "\'100469351\nminus\nselect cta_facturac, cod_factura, cod_factreal, tot_baseimpo_e, tot_impemi, COD_LOCSEGREGADA, cod_causaemi from PFA_PCOBFACTMES_NUBICO \n\n\n\n\ninsert into PFA_PCOBFACTMES_NUBICO select * from PFA_PCOBFACTMES" at net.sf.jsqlparser.parser.CCJSqlParserTokenManager.getNextToken(CCJSqlParserTokenManager.java:4572) at net.sf.jsqlparser.parser.CCJSqlParser.jj_scan_token(CCJSqlParser.java:21414) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_66(CCJSqlParser.java:17638) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_139(CCJSqlParser.java:18005) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_253(CCJSqlParser.java:18082) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_137(CCJSqlParser.java:18246) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_59(CCJSqlParser.java:18329) at net.sf.jsqlparser.parser.CCJSqlParser.jj_2_59(CCJSqlParser.java:14315) at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:7079) at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:7060) at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:7031) at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:6028) at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:3614) at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:3787) at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:3469) at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:3462) at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:119) at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:70) at net.sourceforge.squirrel_sql.client.session.parser.kernel.JSqlParserAdapter.executeParsing(JSqlParserAdapter.java:31) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread._onParse(ParserThread.java:100) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.onParse(ParserThread.java:68) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.lambda$parseInBackground$1(ParserThread.java:59) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2020-11-24 08:53:30,759 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=net.sourceforge.squirrel_sql.client.session.parser.ParserEventsProcessor$$Lambda$186/1854716438@2aad8431,notifier=null,catchExceptions=false,when=1606204410757] on sun.awt.windows.WToolkit@5578757b net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 8, column 66. Encountered: <EOF> after : "\'100469351\nminus\nselect cta_facturac, cod_factura, cod_factreal, tot_baseimpo_e, tot_impemi, COD_LOCSEGREGADA, cod_causaemi from PFA_PCOBFACTMES_NUBICO \n\n\n\n\ninsert into PFA_PCOBFACTMES_NUBICO select * from PFA_PCOBFACTMES" at net.sf.jsqlparser.parser.CCJSqlParserTokenManager.getNextToken(CCJSqlParserTokenManager.java:4572) at net.sf.jsqlparser.parser.CCJSqlParser.jj_scan_token(CCJSqlParser.java:21414) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_66(CCJSqlParser.java:17638) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_139(CCJSqlParser.java:18005) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_253(CCJSqlParser.java:18082) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_137(CCJSqlParser.java:18246) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_59(CCJSqlParser.java:18329) at net.sf.jsqlparser.parser.CCJSqlParser.jj_2_59(CCJSqlParser.java:14315) at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:7079) at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:7060) at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:7031) at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:6028) at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:3614) at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:3787) at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:3469) at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:3462) at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:119) at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:70) at net.sourceforge.squirrel_sql.client.session.parser.kernel.JSqlParserAdapter.executeParsing(JSqlParserAdapter.java:31) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread._onParse(ParserThread.java:100) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.onParse(ParserThread.java:68) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.lambda$parseInBackground$1(ParserThread.java:59) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2020-11-24 08:56:34,493 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 09:01:33,571 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 09:06:33,370 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual |
|
From: jose l. f. d. <jos...@ho...> - 2020-11-22 21:31:56
|
Hi, When I try to exit "SQL Squirrel" it shows this error: java.lang.RuntimeException: java.io.FileNotFoundException: C:\Users\jose_\.squirrel-sql\props.properties (Acceso denegado) But the file exists and I can open it with Notepad. See attached images. Regards, Jose Luis |
|
From: Gerd W. <ger...@t-...> - 2020-11-05 01:22:24
|
Sorry there are no such tags or branches. The way a release revision can be found is to "git annotate" our change log located at sql12/core/doc/changes.txt in our GIT repository. The line of interest in changes.txt is the one of with the SQuirreL version. The revision number for the version 4.1.0 is: 2275883a51889a738ba2d696fc5548aa21032b32 Gerd Am 02.11.20 um 18:27 schrieb Luca Vercelli: > Hello, > I am searching for the source code of a specific release of squirrelsql, > the 4.1.0. Where can I find it? Maybe there is some tag on git? I already > searched for such a tag, but I cannot see anything that matches. > Regards > Luca > > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
|
From: Luca V. <luc...@gm...> - 2020-11-02 17:28:11
|
Hello, I am searching for the source code of a specific release of squirrelsql, the 4.1.0. Where can I find it? Maybe there is some tag on git? I already searched for such a tag, but I cannot see anything that matches. Regards Luca |
|
From: jose l. f. d. <jos...@ho...> - 2020-08-24 22:46:31
|
Hi, When I was doing the client stalled from 20 minutes. This is the log: 2020-08-24 22:38:11,555 [Thread-2] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-08-24 22:38:11,571 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - run: unexpected exception while executing sql (select 1 from dual ): Excepción de E/S: Connection reset by peer: socket write error java.sql.SQLException: Excepción de E/S: Connection reset by peer: socket write error at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:820) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1315) at net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive.run(SessionConnectionKeepAlive.java:78) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-08-24 22:43:11,626 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - run: unexpected exception while executing sql (select 1 from dual ): Conexión cerrada java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:780) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:756) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.createStatement(SQLConnection.java:277) at net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive.run(SessionConnectionKeepAlive.java:74) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-08-24 22:46:00,725 [Thread-4] ERROR net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter - getErrorPosition: Unexpected exception - Conexión cerrada java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:977) at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:943) at net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter.getErrorPosition(OracleExceptionFormatter.java:206) at net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter.format(OracleExceptionFormatter.java:152) at net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter.format(DefaultExceptionFormatter.java:68) at net.sourceforge.squirrel_sql.client.session.Session.formatException(Session.java:1195) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionHandler.sqlExecutionException(SQLExecutionHandler.java:458) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.handleError(SQLExecuterTask.java:621) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.runDirect(SQLExecuterTask.java:264) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:137) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-08-24 22:46:02,976 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.fw.sql.SQLConnection - Error while closing connection java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Conexión cerrada at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:206) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.close(SQLConnection.java:122) at net.sourceforge.squirrel_sql.client.session.Session.closeSQLConnection(Session.java:548) at net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:588) at net.sourceforge.squirrel_sql.client.session.action.reconnect.ReconnectAction.actionPerformed(ReconnectAction.java:55) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.AbstractButton.doClick(AbstractButton.java:376) at javax.swing.AbstractButton.doClick(AbstractButton.java:356) at javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:811) at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1668) at javax.swing.JComponent.processKeyBinding(JComponent.java:2882) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:699) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:677) at javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:307) at javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:293) at javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2974) at javax.swing.JComponent.processKeyBindings(JComponent.java:2966) at javax.swing.JComponent.processKeyEvent(JComponent.java:2845) at java.awt.Component.processEvent(Component.java:6316) at java.awt.Container.processEvent(Container.java:2239) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:835) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1103) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:974) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:800) at java.awt.Component.dispatchEventImpl(Component.java:4760) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84) at java.awt.EventQueue$4.run(EventQueue.java:733) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.awt.EventQueue.dispatchEvent(EventQueue.java:730) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) Caused by: java.lang.RuntimeException: java.sql.SQLException: Conexión cerrada at net.sourceforge.squirrel_sql.fw.sql.SQLConnection._closeIntern(SQLConnection.java:181) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.lambda$close$0(SQLConnection.java:120) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1195) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection._closeIntern(SQLConnection.java:160) ... 6 more 2020-08-24 22:46:03,648 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.KeyEvent[KEY_PRESSED,keyCode=10,keyText=Intro,keyChar=Intro,modifiers=Ctrl,extModifiers=Ctrl,keyLocation=KEY_LOCATION_STANDARD,rawCode=13,primaryLevelUnicode=13,scancode=28,extendedKeyCode=0xa] on net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1761x1640,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@3aded2a0,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=sun.swing.PrintColorUIResource[r=51,g=51,b=51],disabledTextColor=javax.swing.plaf.ColorUIResource[r=184,g=207,b=229],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=sun.swing.PrintColorUIResource[r=51,g=51,b=51],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=20,word=true,wrap=false] java.lang.NullPointerException at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoUpdateCheck.<init>(SchemaInfoUpdateCheck.java:61) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.<init>(SQLExecuterTask.java:100) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionHandler.<init>(SQLExecutionHandler.java:77) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel.executeSQL(SQLResultExecuterPanel.java:283) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel.executeSQL(SQLResultExecuterPanel.java:258) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel.execute(SQLResultExecuterPanel.java:227) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel._runExecuter(SQLPanel.java:340) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.runCurrentExecuter(SQLPanel.java:320) at net.sourceforge.squirrel_sql.client.session.SQLPanelAPI.executeCurrentSQL(SQLPanelAPI.java:479) at net.sourceforge.squirrel_sql.client.session.action.ExecuteSqlAction.actionPerformed(ExecuteSqlAction.java:56) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.AbstractButton.doClick(AbstractButton.java:376) at javax.swing.AbstractButton.doClick(AbstractButton.java:356) at javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:811) at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1668) at javax.swing.JComponent.processKeyBinding(JComponent.java:2882) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:699) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:677) at javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:307) at javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:293) at javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2974) at javax.swing.JComponent.processKeyBindings(JComponent.java:2966) at javax.swing.JComponent.processKeyEvent(JComponent.java:2845) at java.awt.Component.processEvent(Component.java:6316) at java.awt.Container.processEvent(Container.java:2239) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:835) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1103) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:974) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:800) at java.awt.Component.dispatchEventImpl(Component.java:4760) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Window.dispatchEventImpl(Window.java:2746) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84) at java.awt.EventQueue$4.run(EventQueue.java:733) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.awt.EventQueue.dispatchEvent(EventQueue.java:730) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) 2020-08-24 22:46:04,231 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Successfully restored database meta data 2020-08-24 22:46:04,232 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-08-24 22:51:04,785 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-08-24 22:56:05,146 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual Regards, Jose Luis. |
|
From: Gerd W. <ger...@t-...> - 2020-04-15 20:17:52
|
There is no Session timeout in SQuirreL. But there is a login time out, see menu File --> Global Preferences --> Tab SQL and an option to define a "Keep alive" statement, see Alias Properties --> tab Connection. For loading large scripts you may better use the plain editor, see menu File --> New Session Properties --> tab Syntax Gerd Am 13.04.20 um 17:00 schrieb Marcos Javier Dvoskin: > H i Gred, > > Where can I set the session time-out ? > > The problem I’m having is that I have to load a quite large file (about > 17000 rows with inserts command) and then execute it. It takes around 2 > o 3 minutes for the file to be loaded. When the file was loaded , the > session expired. That’s why I need to set this parameter (Session > timeout) to a bigger one . > > Regards, > > Marcos > |
