You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(9) |
Feb
(4) |
Mar
(20) |
Apr
(10) |
May
(5) |
Jun
(2) |
Jul
(10) |
Aug
(4) |
Sep
(15) |
Oct
(5) |
Nov
(8) |
Dec
(2) |
| 2003 |
Jan
(11) |
Feb
(5) |
Mar
(10) |
Apr
(20) |
May
(24) |
Jun
(13) |
Jul
(6) |
Aug
(5) |
Sep
(10) |
Oct
(10) |
Nov
(9) |
Dec
(7) |
| 2004 |
Jan
(4) |
Feb
(10) |
Mar
(5) |
Apr
(18) |
May
(18) |
Jun
(14) |
Jul
(24) |
Aug
(14) |
Sep
(6) |
Oct
(18) |
Nov
(5) |
Dec
(3) |
| 2005 |
Jan
(5) |
Feb
(1) |
Mar
(5) |
Apr
(10) |
May
(10) |
Jun
(16) |
Jul
(46) |
Aug
(36) |
Sep
(16) |
Oct
(11) |
Nov
(12) |
Dec
(29) |
| 2006 |
Jan
(33) |
Feb
(45) |
Mar
(42) |
Apr
(23) |
May
(23) |
Jun
(21) |
Jul
(19) |
Aug
(23) |
Sep
(17) |
Oct
(50) |
Nov
(74) |
Dec
(44) |
| 2007 |
Jan
(35) |
Feb
(18) |
Mar
(46) |
Apr
(25) |
May
(26) |
Jun
(24) |
Jul
(33) |
Aug
(4) |
Sep
(41) |
Oct
(43) |
Nov
(23) |
Dec
(42) |
| 2008 |
Jan
(26) |
Feb
(20) |
Mar
(21) |
Apr
(18) |
May
(28) |
Jun
(32) |
Jul
(25) |
Aug
(28) |
Sep
(27) |
Oct
(34) |
Nov
(16) |
Dec
(42) |
| 2009 |
Jan
(21) |
Feb
(36) |
Mar
(40) |
Apr
(51) |
May
(27) |
Jun
(13) |
Jul
(38) |
Aug
(40) |
Sep
(5) |
Oct
(14) |
Nov
(4) |
Dec
(7) |
| 2010 |
Jan
(16) |
Feb
(10) |
Mar
(38) |
Apr
(83) |
May
(27) |
Jun
(41) |
Jul
(57) |
Aug
(24) |
Sep
(14) |
Oct
(22) |
Nov
(28) |
Dec
(42) |
| 2011 |
Jan
(52) |
Feb
(13) |
Mar
(41) |
Apr
(14) |
May
(24) |
Jun
(14) |
Jul
(16) |
Aug
(15) |
Sep
(19) |
Oct
(20) |
Nov
(35) |
Dec
(48) |
| 2012 |
Jan
(30) |
Feb
(9) |
Mar
(33) |
Apr
(15) |
May
(13) |
Jun
(13) |
Jul
(57) |
Aug
(20) |
Sep
(18) |
Oct
(29) |
Nov
(28) |
Dec
(9) |
| 2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
| 2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
| 2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
| 2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
| 2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
| 2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
| 2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
| 2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
| 2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
(3) |
Nov
(3) |
Dec
|
| 2025 |
Jan
|
Feb
(5) |
Mar
(33) |
Apr
(8) |
May
(10) |
Jun
(7) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Gerd W. <ger...@t-...> - 2024-05-14 18:35:33
|
Am 04.04.24 um 20:21 schrieb info: > Could developers consider adding a few lines, to auto-adjust column > width to whichever is greater: the width of the title or that of the > longest column value, up to to a reasonable maximum? > Please see menu File --> Global Preferences --> tab General --> Section "When adjusting table column widths a maximum width may be defined here" on the right. |
|
From: info <in...@dr...> - 2024-04-04 18:22:10
|
Could developers consider adding a few lines, to auto-adjust column width to whichever is greater: the width of the title or that of the longest column value, up to to a reasonable maximum? |
|
From: info <in...@dr...> - 2024-03-06 21:29:51
|
They look odd and confusing On 2024-03-06 02:48 PM, Gerd Wagner wrote: > > > Am 05.03.24 um 22:42 schrieb info: >> Do they need to be there? >> > > They are strings and could be changed of course I just doubt they need > or should be. > |
|
From: Gerd W. <ger...@t-...> - 2024-03-06 19:48:16
|
Am 05.03.24 um 22:42 schrieb info: > Do they need to be there? > They are strings and could be changed of course I just doubt they need or should be. |
|
From: info <in...@dr...> - 2024-03-05 21:42:40
|
Do they need to be there? On 2024-03-05 02:06 PM, Gerd Wagner wrote: > > Am 03.03.24 um 18:10 schrieb info: >> What do the highlighted in yellow parts mean? >> >> > > Those are the method names of the JDBC-API's class ResultSetMetaData > which provide the information displayed in the table below. > |
|
From: Gerd W. <ger...@t-...> - 2024-03-05 19:06:53
|
Am 03.03.24 um 18:10 schrieb info: > What do the highlighted in yellow parts mean? > > Those are the method names of the JDBC-API's class ResultSetMetaData which provide the information displayed in the table below. |
|
From: info <in...@dr...> - 2024-03-03 21:14:47
|
What do the highlighted in yellow parts mean? |
|
From: Gerd W. <ger...@t-...> - 2024-01-17 18:51:13
|
Am 16.01.24 um 12:54 schrieb Nicholas Foley: > Hi all, > > I’m wondering if someone may be able to help me. We use a jdbc driver to > connect to an oracle database. I’m trying to get data from this database > in an automated way, unfortunately our IT are removing the ODBC driver > we did have. So I’m wondering is there a way I can launch squirrel via a > custom batch file. And include some text that’ll tell it to use this > driver, with this alias setup and this username/password and run this > SQL statement and return a specific filename I provide. This’ll then run > squirrel ideally without showing the screen, and automatically return > the results to the file given and then close that squirrel window. > > Thanks For the following you will need the latest version (4.6.0) of SQuirreL. It won't work with version 3.6. Go to the squirrelcli sub directory of your SQuirreL installation and open a Powershell in this directory. Try if you can execute the command .\squirrelcli.bat -help If this doesn't work open the squirrelcli.bat file in some editor and put SET JAVA_HOME=<pathToYourJavaJDKInstallationDir> in the first line of the file an try to execute the command again. If the command executes correctly it will explain the command line parameters you can use for the command. Here's an example that may come close to what you want: .\squirrelcli.bat -alias <yourAliasName> -sql "<yourSql>" -toFileFormatted <pathToYourOutputFile> Gerd |
|
From: Nicholas F. <gui...@ho...> - 2024-01-16 11:54:22
|
Hi all, I'm wondering if someone may be able to help me. We use a jdbc driver to connect to an oracle database. I'm trying to get data from this database in an automated way, unfortunately our IT are removing the ODBC driver we did have. So I'm wondering is there a way I can launch squirrel via a custom batch file. And include some text that'll tell it to use this driver, with this alias setup and this username/password and run this SQL statement and return a specific filename I provide. This'll then run squirrel ideally without showing the screen, and automatically return the results to the file given and then close that squirrel window. Thanks |
|
From: Steve H. <st...@we...> - 2024-01-13 15:10:45
|
Hi All, I have set up a GitHub repo that generates installers for Mac, Windows, and Linux nightly off of the master branch. Once installed, it will automatically receive the latest version from master, every time you open the app. This is the repo https://github.com/shannah/squirrel-sql-releases I set this up for my own use, but thought I would share, in case others find it useful. Full disclosure: The tool that I'm using to generate the installers, jDeploy, is a tool that I develop and maintain. Best regards Steve |
|
From: Gerd W. <ger...@t-...> - 2023-12-09 19:20:45
|
Am 07.12.23 um 18:19 schrieb Mike Barker:
> My point was that I don’t think it is a VPN issue. I can connect to my
> databases over VPN using squirrelcli, but not using squirrel UI, even
> though both are using the same aliases. What is the difference between
> the squirrelcli connection and the UI connection?
>
The error message from your first mail shows that the problem occurs at
a code section that both SQuirreL's CLI and UI use.
Here are things you may try:
1. If in use disable the MySQL Plugin, see menu Plugins --> summary.
Please restart SQuirreL after you disabled it.
2. Right click your MySQL Alias choose "Alias Properties" --> tab
"Driver Properties". Make sure "User driver properties" is unchecked.
3. In case you know some Java you may experiment with the Java code
below to reproduce the problem. If you were able to reproduce it this
way that should make it easier to tell if it's a SQuirreL or
database/driver or VPN problem.
Gerd
---- Java code ----
package mysqltest;
import java.sql.Connection;
import java.sql.Driver;
import java.util.Properties;
public class MySqlTest
{
public static void main(String[] args)
{
try
{
Driver driver = (Driver)
(Class.forName("com.mysql.cj.jdbc.Driver").getDeclaredConstructor().newInstance());
Properties props = new Properties();
props.put("user", "<yourUserName>");
props.put("password", "<yourPassword>");
Connection con = driver.connect("<yourJdbcUrl>", props);
System.out.println("SUCCESSFULLY CONNECTED!");
}
catch (Exception e)
{
System.out.println("FAILED TO CONNECT. ERROR MESSAGE:");
e.printStackTrace();
}
}
}
|
|
From: Mike B. <mb...@on...> - 2023-12-07 17:20:22
|
My point was that I don’t think it is a VPN issue. I can connect to my databases over VPN using squirrelcli, but not using squirrel UI, even though both are using the same aliases. What is the difference between the squirrelcli connection and the UI connection?
—Mike
> On Dec 7, 2023, at 12:33 AM, Leo Liebenauer-Welsch <lw...@we...> wrote:
>
> I don't think that's an issue of the client (Squirrel). If you can connect to other applications via VPN perhaps the DB-access is restricted/blocked for those trying to connect via VPN. Might be a security breach.
>
> good luck
>
> leo
>
> Am 07.12.23 um 02:49 schrieb Mike Barker:
>> I still cannot connect to my DBs. I discovered squirrelcli and installed it in my Mac Squirrel directory. I made one change to squirrelcli.sh. It executes and brings up the jshell prompt. I’m able to connect using one of my aliases from Squirrel UI and query the DB. How is CLI connection different from the connection using the UI?
>>
>> I have added "&traceProtocol=true&logXaCommands=true” to the JDBC string. It spews out a lot of information at the command line, though not shown below. None of that is logged when using the UI, at least I can’t find it.
>>
>> There is something in the UI that is keeping me from connecting to the DBs.
>>
>> Thanks for any help.
>>
>> --Mike
>>
>> /Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli> squirrelcli.sh
>> /Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli
>> Picked up JAVA_TOOL_OPTIONS: -Djava.net.preferIPv4Stack=true
>> Entering JShell based mode.
>> Picked up JAVA_TOOL_OPTIONS: -Djava.net.preferIPv4Stack=true
>> Picked up _JAVA_OPTIONS: -Dsquirrel.home='/Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli'/..
>>
>> ------------------------------------------------------------------
>> -- Welcome to the SQuirreL CLI (Command Line Interface)
>> -- Enter help() for information.
>> -- Enter /exit to leave.
>> ------------------------------------------------------------------
>>
>> | Welcome to JShell -- Version 11.0.17
>> | For an introduction type: /help intro
>>
>> jshell> connect("sso-dev")
>>
>> jshell> exec("select count(*) from user")
>> count(*)
>> --------
>> 175383
>> jshell>
>>
>>
>>
>>
>>> On Nov 29, 2023, at 4:13 PM, Mike Barker <mb...@on...> <mailto:mb...@on...> wrote:
>>>
>>> Hi,
>>> I use AWS VPN to access our remote MySQL DBs. I use SQuirrel SQL 4.6.0 as my primary SQL IDE.
>>>
>>> Since Nov 13, I have been unable to access any DBs remotely over the VPN. My team discovered that AWS VPN doesn't like IP6 traffic, so I've disabled it on my Mac. I've also set globally JAVA_TOOL_OPTIONS="-Djava.net.preferIPv4Stack=true". These changes have allowed my local Java development servers to access the DBs over AWS VPN. My apps as well as SQuirrel SQL use the mysql jar below. However, I still can't use SQuirrel SQL; the connection times out.
>>>
>>> Here's my environment:
>>> MacOS 14.1.1
>>> Java (Eclipse Adoptium) 11.0.17+8
>>> mysql-connector-j-8.0.33.jar
>>> MySQL 8.0.34
>>> AWS VPN Client 3.8.0
>>>
>>> Any thoughts on what I can set inside or outside of SQuirrel SQL?
>>>
>>> —Mike
>>
|
|
From: Leo Liebenauer-W. <lw...@we...> - 2023-12-07 08:00:14
|
I don't think that's an issue of the client (Squirrel). If you can
connect to other applications via VPN perhaps the DB-access is
restricted/blocked for those trying to connect via VPN. Might be a
security breach.
good luck
leo
Am 07.12.23 um 02:49 schrieb Mike Barker:
> I still cannot connect to my DBs. I discovered squirrelcli and
> installed it in my Mac Squirrel directory. I made one change to
> squirrelcli.sh. It executes and brings up the jshell prompt. I’m
> able to connect using one of my aliases from Squirrel UI and query the
> DB. How is CLI connection different from the connection using the UI?
>
> I have added "&traceProtocol=true&logXaCommands=true” to the JDBC
> string. It spews out a lot of information at the command line, though
> not shown below. None of that is logged when using the UI, at least I
> can’t find it.
>
> There is something in the UI that is keeping me from connecting to the
> DBs.
>
> Thanks for any help.
>
> --Mike
>
> //Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli>
> squirrelcli.sh/
> //Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli/
> /Picked up JAVA_TOOL_OPTIONS: -Djava.net.preferIPv4Stack=true/
> /Entering JShell based mode./
> /Picked up JAVA_TOOL_OPTIONS: -Djava.net.preferIPv4Stack=true/
> /Picked up _JAVA_OPTIONS:
> -Dsquirrel.home='/Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli'/../
> /
> /
> /------------------------------------------------------------------/
> /-- Welcome to the SQuirreL CLI (Command Line Interface)/
> /-- Enter help() for information./
> /-- Enter /exit to leave./
> /------------------------------------------------------------------/
> /
> /
> /| Welcome to JShell -- Version 11.0.17/
> /| For an introduction type: /help intro/
> /
> /
> /jshell> connect("sso-dev")/
> /
> /
> /jshell> exec("select count(*) from user")/
> /count(*)/
> /--------/
> / 175383/
> /jshell>/
>
>
>
>
>> On Nov 29, 2023, at 4:13 PM, Mike Barker <mb...@on...> wrote:
>>
>> Hi,
>> I use AWS VPN to access our remote MySQL DBs. I use SQuirrel SQL
>> 4.6.0 as my primary SQL IDE.
>>
>> Since Nov 13, I have been unable to access any DBs remotely over the
>> VPN. My team discovered that AWS VPN doesn't like IP6 traffic, so
>> I've disabled it on my Mac. I've also set globally
>> JAVA_TOOL_OPTIONS="-Djava.net.preferIPv4Stack=true". These changes
>> have allowed my local Java development servers to access the DBs over
>> AWS VPN. My apps as well as SQuirrel SQL use the mysql jar below.
>> However, I still can't use SQuirrel SQL; the connection times out.
>>
>> Here's my environment:
>> MacOS 14.1.1
>> Java (Eclipse Adoptium) 11.0.17+8
>> mysql-connector-j-8.0.33.jar
>> MySQL 8.0.34
>> AWS VPN Client 3.8.0
>>
>> Any thoughts on what I can set inside or outside of SQuirrel SQL?
>>
>> —Mike
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
--
*Weberhofer GmbH*
information technologies *DI Leo Liebenauer-Welsch*
Software Entwicklung
Blindengasse 52/3
1080 Wien
Austria +43 (0)1 5454421 <tel:+4315454421>
www.weberhofer.at <http://www.weberhofer.at>
UID: ATU55277701, Firmenbuch: 225566s, Handelsgericht Wien
|
|
From: Mike B. <mb...@on...> - 2023-12-07 02:02:34
|
I still cannot connect to my DBs. I discovered squirrelcli and installed it in my Mac Squirrel directory. I made one change to squirrelcli.sh. It executes and brings up the jshell prompt. I’m able to connect using one of my aliases from Squirrel UI and query the DB. How is CLI connection different from the connection using the UI?
I have added "&traceProtocol=true&logXaCommands=true” to the JDBC string. It spews out a lot of information at the command line, though not shown below. None of that is logged when using the UI, at least I can’t find it.
There is something in the UI that is keeping me from connecting to the DBs.
Thanks for any help.
--Mike
/Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli> squirrelcli.sh
/Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli
Picked up JAVA_TOOL_OPTIONS: -Djava.net.preferIPv4Stack=true
Entering JShell based mode.
Picked up JAVA_TOOL_OPTIONS: -Djava.net.preferIPv4Stack=true
Picked up _JAVA_OPTIONS: -Dsquirrel.home='/Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli'/..
------------------------------------------------------------------
-- Welcome to the SQuirreL CLI (Command Line Interface)
-- Enter help() for information.
-- Enter /exit to leave.
------------------------------------------------------------------
| Welcome to JShell -- Version 11.0.17
| For an introduction type: /help intro
jshell> connect("sso-dev")
jshell> exec("select count(*) from user")
count(*)
--------
175383
jshell>
> On Nov 29, 2023, at 4:13 PM, Mike Barker <mb...@on...> wrote:
>
> Hi,
> I use AWS VPN to access our remote MySQL DBs. I use SQuirrel SQL 4.6.0 as my primary SQL IDE.
>
> Since Nov 13, I have been unable to access any DBs remotely over the VPN. My team discovered that AWS VPN doesn't like IP6 traffic, so I've disabled it on my Mac. I've also set globally JAVA_TOOL_OPTIONS="-Djava.net.preferIPv4Stack=true". These changes have allowed my local Java development servers to access the DBs over AWS VPN. My apps as well as SQuirrel SQL use the mysql jar below. However, I still can't use SQuirrel SQL; the connection times out.
>
> Here's my environment:
> MacOS 14.1.1
> Java (Eclipse Adoptium) 11.0.17+8
> mysql-connector-j-8.0.33.jar
> MySQL 8.0.34
> AWS VPN Client 3.8.0
>
> Any thoughts on what I can set inside or outside of SQuirrel SQL?
>
> —Mike
|
|
From: Mike B. <mb...@on...> - 2023-11-29 23:27:24
|
Hi, I use AWS VPN to access our remote MySQL DBs. I use SQuirrel SQL 4.6.0 as my primary SQL IDE. Since Nov 13, I have been unable to access any DBs remotely over the VPN. My team discovered that AWS VPN doesn't like IP6 traffic, so I've disabled it on my Mac. I've also set globally JAVA_TOOL_OPTIONS="-Djava.net.preferIPv4Stack=true". These changes have allowed my local Java development servers to access the DBs over AWS VPN. My apps as well as SQuirrel SQL use the mysql jar below. However, I still can't use SQuirrel SQL; the connection times out. Here's my environment: MacOS 14.1.1 Java (Eclipse Adoptium) 11.0.17+8 mysql-connector-j-8.0.33.jar MySQL 8.0.34 AWS VPN Client 3.8.0 Any thoughts on what I can set inside or outside of SQuirrel SQL? —Mike registerDriver: com.mysql.cj.jdbc.Driver@265c887a SQLState(08001) vendor code(0) java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74) at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188) at net.sourceforge.squirrel_sql.fw.sql.SQLConnector.getSqlConnection(SQLConnector.java:58) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:110) at net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:155) at net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConnectionCommand.lambda$execute$0(OpenConnectionCommand.java:89) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) |
|
From: Stanimir S. <s7...@ne...> - 2023-08-31 13:36:18
|
Wed, 30 Aug 2023 10:23:36 -0400, /info/: > Is Squirrel really necessary for running batch files? The DB server's > CLI should be able to do it. Squirrel is an IDE. That's the point, apart from universal GUI client SQuirreL could also be used as universal CLI/console client. Anyone could install the specific database SQL tools, otherwise. -- Stanimir |
|
From: <xr...@se...> - 2023-08-30 16:40:36
|
Hi, all, thank You for hints. I solved it. In SQuirreL, very easily, no hack, no coding, just GUI: SQuirreL -> menu -> Plugins -> Summary -> select plugin named SQL Entry Code Completion -> click Unload. Than till the next start of SQuirreL You disabled analyzing of SQL code, which causes the slowdown, almost freeze. Now it responses in real time. SQuirreL is great, when You know, how to use it! Regards, Stepan |
|
From: info <in...@dr...> - 2023-08-30 15:24:14
|
Is Squirrel really necessary for running batch files? The DB server's CLI should be able to do it. Squirrel is an IDE. On 2023-08-30 09:44 AM, Stanimir Stamenkov via Squirrel-sql-users wrote: > Wed, 30 Aug 2023 11:41:11 +0200 (CEST), /Stepan/: > >> Now I have problem. I have a SQL several files each one with about >> 6.000 SQL commands. I need to run each file against one database from >> time to time. But when I open this file, SQuirreL hangs for several >> minutes. Is there any nice workaround in GUI of SQuirreL? I guess >> something like run SQL from file without opening in TextArea, bypass >> checking of SQL... > > Haven't used it myself but I'm aware there's a Command Line Interface > (since v3.9.0) [1]: > >> See Readme.txt in the squirrelcli/ subdirectory of your SQuirreL >> installation. > > The "Readme.txt" [2] says: > >> The squirrelcli* scripts offers two modes: >> 1. The batch mode which, as mentioned above, you can learn about by >> entering squirrelcli* -help on your command line. >> 2. The Java JShell based mode which can be entered by executing the >> script with no parameter (or -userdir only). This requires JDK (not >> JRE) as JShell is only available in JDKs. > [1] > https://github.com/squirrel-sql-client/squirrel-sql-code/blob/ca6c285/sql12/core/doc/changes.txt#L1917-L1918 > [2] > https://github.com/squirrel-sql-client/squirrel-sql-code/blob/ca6c285/sql12/launcher/squirrelcli/Readme.txt > |
|
From: Stanimir S. <s7...@ne...> - 2023-08-30 14:15:29
|
Wed, 30 Aug 2023 11:41:11 +0200 (CEST), /Stepan/: > Now I have problem. I have a SQL several files each one with about 6.000 > SQL commands. I need to run each file against one database from time to > time. But when I open this file, SQuirreL hangs for several minutes. Is > there any nice workaround in GUI of SQuirreL? I guess something like run > SQL from file without opening in TextArea, bypass checking of SQL... Haven't used it myself but I'm aware there's a Command Line Interface (since v3.9.0) [1]: > See Readme.txt in the squirrelcli/ subdirectory of your SQuirreL installation. The "Readme.txt" [2] says: > The squirrelcli* scripts offers two modes: > 1. The batch mode which, as mentioned above, you can learn about by > entering squirrelcli* -help on your command line. > 2. The Java JShell based mode which can be entered by executing the > script with no parameter (or -userdir only). This requires JDK (not > JRE) as JShell is only available in JDKs. [1] https://github.com/squirrel-sql-client/squirrel-sql-code/blob/ca6c285/sql12/core/doc/changes.txt#L1917-L1918 [2] https://github.com/squirrel-sql-client/squirrel-sql-code/blob/ca6c285/sql12/launcher/squirrelcli/Readme.txt -- Stanimir |
|
From: <xr...@se...> - 2023-08-30 09:44:06
|
Hello, I am using SQuirreL for many years for many different databases... Great SW! Now I have problem. I have a SQL several files each one with about 6.000 SQL commands. I need to run each file against one database from time to time. But when I open this file, SQuirreL hangs for several minutes. Is there any nice workaround in GUI of SQuirreL? I guess something like run SQL from file without opening in TextArea, bypass checking of SQL... Thank You in advance for answer, Stepan |
|
From: Miguel G. <mig...@ya...> - 2023-08-23 07:05:37
|
Hi, I know officially it´s not supported the migration of h2 database of sonarqube to postgresql but I am playing around to see if that´s possible after I read this thread: How to convert H2Database database file to MySQL database .sql file? | | | | | | | | | | | How to convert H2Database database file to MySQL database .sql file? I have some data in H2Database file and I want to convert it to MySQL .sql database file. What are the methods I... | | | I followed the suggestion and used Squirrel-SQL to try to migrate from H2 to PostgreSQL. For comparing the outputs I have setup three Sonarqube 8.9.10 LTS instances: 1) a Sonarqube instance with H2 with historical data of past scans. 2) a Sonarqube instance with PostgreSQL with just one scan. 3) Another instance of Sonarqube with PostgreSQL with the data migrated from instance 1. That way using Squirrel-SQL I can compare and see if there is any difference. I can see the data has been copied, primary keys, imported and exported key and indexes have been copied too. I have enabled debug mode in Sonarqube to see If I see any error from any query. The curious thing is that there is some data Sonarqube can display like individual projects but not list all projects in the dashboard. Any suggestion of what I should look at or how I could compare both PostgreSQL databases to see where the issue might be? Thanks again, Miguel |
|
From: Greg B. <gjb...@ho...> - 2023-05-22 12:31:01
|
Gerd, Thank you. Nice that no one else will need to experience this issue going forward. Gregory J Blajian gjb...@ho... -----Original Message----- From: Gerd Wagner <ger...@t-...> Sent: Friday, May 19, 2023 07:09 To: Greg Blajian <gjb...@ho...>; Stanimir Stamenkov <s7...@ne...>; squ...@li... Subject: Re: [Squirrel-sql-users] Issue launching squirrel client Sorry for the inconvenience. I just committed a change that should prevent such problems in the future. The according change log excerpt is: Prevented SQuirreL from failing to start when an erroneous Json configuration exists. Such an error will now be logged and a default/empty configuration will be used. Gerd Am 18.05.23 um 21:43 schrieb Greg Blajian: > Stanimir, > > THANK YOU SO MUCH! > You were 100% on target with that (two of the .json files were 100% empty/blank). I figured it was a corrupt file I just did not know where to look. Back up and running. You ROCK!!!! Thank you again! > > Gregory J Blajian > gjb...@ho... > > -----Original Message----- > From: Stanimir Stamenkov via Squirrel-sql-users > <squ...@li...> > Sent: Thursday, May 18, 2023 13:17 > To: squ...@li... > Subject: Re: [Squirrel-sql-users] Issue launching squirrel client > > Thu, 18 May 2023 13:02:15 +0000, /Greg Blajian/: > >> $ java -jar squirrel-sql.jar >> >> java.lang.RuntimeException: >> com.fasterxml.jackson.databind.JsonMappingException: No content to >> map due to end-of-input at [Source: >> java.io.InputStreamReader@248af7cf; >> line: 1, column: 1] >> ... >> at >> net.sourceforge.squirrel_sql.client.gui.recentfiles.RecentFilesManage >> r >> .initJSonBean(RecentFilesManager.java:89) >> at >> net.sourceforge.squirrel_sql.client.Application.loadRecentFileHistory >> ( >> Application.java:1060) >> ... > > Seems like you're having a corrupt "RecentFilesJsonBean.json": > > * > https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithu > b.com%2Fsquirrel-sql-client%2Fsquirrel-sql-code%2Fblob%2F1a950b28b%2Fs > ql12%2Fcore%2Fsrc%2Fnet%2Fsourceforge%2Fsquirrel_sql%2Fclient%2FApplic > ation.java%23L1060&data=05%7C01%7C%7C27f3c996ec334ff35a6908db58596a6d% > 7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638200913276466206%7CUnkn > own%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwi > LCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=IABASFjwudtqKm10gXz7NfNiVWpq0PJjw > TJOQicgCdc%3D&reserved=0 > * > https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithu > b.com%2Fsquirrel-sql-client%2Fsquirrel-sql-code%2Fblob%2F1a950b28b%2Fs > ql12%2Fcore%2Fsrc%2Fnet%2Fsourceforge%2Fsquirrel_sql%2Fclient%2Futil%2 > FApplicationFiles.java%23L200-L202&data=05%7C01%7C%7C27f3c996ec334ff35 > a6908db58596a6d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638200913 > 276466206%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIi > LCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=0v%2Bmvuk%2Bw2HHQ > yID7E%2F1CUiwuc9KB6MVobsdonP2Ifo%3D&reserved=0 > > Try deleting it (move it away or rename it): > > > ren %USERPROFILE%\.squirrel-sql\RecentFilesJsonBean.json > RecentFilesJsonBean.json.bak > > Alternatively, you may open it in Notepad - if the content is empty (as it seems from the exception message), enter an empty JSON object and save it back: > > {} > > -- > Stanimir > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists > .sourceforge.net%2Flists%2Flistinfo%2Fsquirrel-sql-users&data=05%7C01% > 7C%7C27f3c996ec334ff35a6908db58596a6d%7C84df9e7fe9f640afb435aaaaaaaaaa > aa%7C1%7C0%7C638200913276466206%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLj > AwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&s > data=QM%2Bc3o%2Bvjk7MIUZ9%2FhqH6jgmqjOMl8DPgAV9yLH7o3E%3D&reserved=0 > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists > .sourceforge.net%2Flists%2Flistinfo%2Fsquirrel-sql-users&data=05%7C01% > 7C%7C27f3c996ec334ff35a6908db58596a6d%7C84df9e7fe9f640afb435aaaaaaaaaa > aa%7C1%7C0%7C638200913276466206%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLj > AwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&s > data=QM%2Bc3o%2Bvjk7MIUZ9%2FhqH6jgmqjOMl8DPgAV9yLH7o3E%3D&reserved=0 |
|
From: Gerd W. <ger...@t-...> - 2023-05-19 12:15:14
|
Stanimir's information is the most accurate. But easier to find is the second installer panel, see the attached screenshot. Gerd Am 18.05.23 um 19:24 schrieb Stanimir Stamenkov via Squirrel-sql-users: > Tue, 16 May 2023 19:09:36 +0200, /Ben/: > >> What is the latest Squirrel version which works with Java v8? > > Looking at: > > * > https://github.com/squirrel-sql-client/squirrel-sql-code/blob/90e68ebdb/sql12/core/doc/changes.txt#L741-L744 > > If I'm not mistaken, it should be 4.2.0 (04/05/2021). The next one – > 4.3.0 (10/02/2021) requires Java 11. > |
|
From: Gerd W. <ger...@t-...> - 2023-05-19 11:09:01
|
Sorry for the inconvenience. I just committed a change that should prevent such problems in the future. The according change log excerpt is: Prevented SQuirreL from failing to start when an erroneous Json configuration exists. Such an error will now be logged and a default/empty configuration will be used. Gerd Am 18.05.23 um 21:43 schrieb Greg Blajian: > Stanimir, > > THANK YOU SO MUCH! > You were 100% on target with that (two of the .json files were 100% empty/blank). I figured it was a corrupt file I just did not know where to look. Back up and running. You ROCK!!!! Thank you again! > > Gregory J Blajian > gjb...@ho... > > -----Original Message----- > From: Stanimir Stamenkov via Squirrel-sql-users <squ...@li...> > Sent: Thursday, May 18, 2023 13:17 > To: squ...@li... > Subject: Re: [Squirrel-sql-users] Issue launching squirrel client > > Thu, 18 May 2023 13:02:15 +0000, /Greg Blajian/: > >> $ java -jar squirrel-sql.jar >> >> java.lang.RuntimeException: >> com.fasterxml.jackson.databind.JsonMappingException: No content to map >> due to end-of-input at [Source: java.io.InputStreamReader@248af7cf; >> line: 1, column: 1] >> ... >> at >> net.sourceforge.squirrel_sql.client.gui.recentfiles.RecentFilesManager >> .initJSonBean(RecentFilesManager.java:89) >> at >> net.sourceforge.squirrel_sql.client.Application.loadRecentFileHistory( >> Application.java:1060) >> ... > > Seems like you're having a corrupt "RecentFilesJsonBean.json": > > * > https://github.com/squirrel-sql-client/squirrel-sql-code/blob/1a950b28b/sql12/core/src/net/sourceforge/squirrel_sql/client/Application.java#L1060 > * > https://github.com/squirrel-sql-client/squirrel-sql-code/blob/1a950b28b/sql12/core/src/net/sourceforge/squirrel_sql/client/util/ApplicationFiles.java#L200-L202 > > Try deleting it (move it away or rename it): > > > ren %USERPROFILE%\.squirrel-sql\RecentFilesJsonBean.json > RecentFilesJsonBean.json.bak > > Alternatively, you may open it in Notepad - if the content is empty (as it seems from the exception message), enter an empty JSON object and save it back: > > {} > > -- > Stanimir > > > _______________________________________________ > 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 |
|
From: Greg B. <gjb...@ho...> - 2023-05-18 19:43:55
|
Stanimir, THANK YOU SO MUCH! You were 100% on target with that (two of the .json files were 100% empty/blank). I figured it was a corrupt file I just did not know where to look. Back up and running. You ROCK!!!! Thank you again! Gregory J Blajian gjb...@ho... -----Original Message----- From: Stanimir Stamenkov via Squirrel-sql-users <squ...@li...> Sent: Thursday, May 18, 2023 13:17 To: squ...@li... Subject: Re: [Squirrel-sql-users] Issue launching squirrel client Thu, 18 May 2023 13:02:15 +0000, /Greg Blajian/: > $ java -jar squirrel-sql.jar > > java.lang.RuntimeException: > com.fasterxml.jackson.databind.JsonMappingException: No content to map > due to end-of-input at [Source: java.io.InputStreamReader@248af7cf; > line: 1, column: 1] > ... > at > net.sourceforge.squirrel_sql.client.gui.recentfiles.RecentFilesManager > .initJSonBean(RecentFilesManager.java:89) > at > net.sourceforge.squirrel_sql.client.Application.loadRecentFileHistory( > Application.java:1060) > ... Seems like you're having a corrupt "RecentFilesJsonBean.json": * https://github.com/squirrel-sql-client/squirrel-sql-code/blob/1a950b28b/sql12/core/src/net/sourceforge/squirrel_sql/client/Application.java#L1060 * https://github.com/squirrel-sql-client/squirrel-sql-code/blob/1a950b28b/sql12/core/src/net/sourceforge/squirrel_sql/client/util/ApplicationFiles.java#L200-L202 Try deleting it (move it away or rename it): > ren %USERPROFILE%\.squirrel-sql\RecentFilesJsonBean.json RecentFilesJsonBean.json.bak Alternatively, you may open it in Notepad - if the content is empty (as it seems from the exception message), enter an empty JSON object and save it back: {} -- Stanimir _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
