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: Ferreira, M. <Mat...@fi...> - 2020-08-04 16:56:39
|
Deferring to John 😊 Matthew Ferreira Principal Technology Engineer / Team Lead T: +1.978.275.5231 E: mat...@wo... FIS | Advancing the way the world pays, banks and invests™ -----Original Message----- From: John Hardin <jh...@im...> Sent: Tuesday, August 4, 2020 11:51 AM To: Squirrel SQL users list <squ...@li...> Subject: Re: [Squirrel-sql-users] EXTERNAL: Query fails to execute On Tue, 4 Aug 2020, Ferreira, Matt via Squirrel-sql-users wrote: > Are you using the included shell script? My initial thought is that you might need to increase the max memory settings. The default is set to 256: > -Xmx256m >> > From: Fritz, Larry <Lar...@xy...> > Sent: Tuesday, August 4, 2020 10:34 AM > To: squ...@li... > Subject: EXTERNAL: [Squirrel-sql-users] Query fails to execute > > 2020-08-03 16:02:37,711 [AWT-EventQueue-1] ERROR > net.sourceforge.squirrel_sql.client.Main - Exception occurred > dispatching Event > java.awt.event.MouseEvent[MOUSE_RELEASED,(401,124),absolute(401,123),b > utton=1,modifiers=Button1,clickCount=1] on frame0 > java.lang.StackOverflowError I don't know whether adjusting the heap size (-Xmx) will help this one. For a stack overflow error, also consider adding a -Xss parameter to the JRE command line, e.g. -Xss12m see https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F3700459%2Fhow-to-increase-the-java-stack-size&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7Ce359afcf896741cc4c2308d838953828%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321560837295718&sdata=0xXRap5dM8j%2BSplft1Rf8%2F%2Bez5deQ6tbicMGrR4T5uM%3D&reserved=0 I don't know offhand what the default is so I can't suggest a new value, sorry. -- John Hardin KA7OHZ https://eur02.safelinks.protection.outlook.com/?url=http:%2F%2Fwww.impsec.org%2F~jhardin%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7Ce359afcf896741cc4c2308d838953828%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321560837295718&sdata=sIIeRX8JHbxqFAg6isU5ATZE36FmiJSiffAC7lAtEXI%3D&reserved=0 jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- A good high-school education is still essential, and college is where you go to get one. -- MiddleAgedKen ----------------------------------------------------------------------- Today: the 285th anniversary of John Peter Zenger's acquittal _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fsquirrel-sql-users&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7Ce359afcf896741cc4c2308d838953828%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321560837295718&sdata=IQOd5gWwbchyIQft9%2B5L3lLwqAx9IHNvvSXFMBSEllQ%3D&reserved=0 The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. |
|
From: John H. <jh...@im...> - 2020-08-04 16:40:15
|
On Tue, 4 Aug 2020, Ferreira, Matt via Squirrel-sql-users wrote: > Are you using the included shell script? My initial thought is that you might need to increase the max memory settings. The default is set to 256: > -Xmx256m >> > From: Fritz, Larry <Lar...@xy...> > Sent: Tuesday, August 4, 2020 10:34 AM > To: squ...@li... > Subject: EXTERNAL: [Squirrel-sql-users] Query fails to execute > > 2020-08-03 16:02:37,711 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(401,124),absolute(401,123),button=1,modifiers=Button1,clickCount=1] on frame0 > java.lang.StackOverflowError I don't know whether adjusting the heap size (-Xmx) will help this one. For a stack overflow error, also consider adding a -Xss parameter to the JRE command line, e.g. -Xss12m see https://stackoverflow.com/questions/3700459/how-to-increase-the-java-stack-size I don't know offhand what the default is so I can't suggest a new value, sorry. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- A good high-school education is still essential, and college is where you go to get one. -- MiddleAgedKen ----------------------------------------------------------------------- Today: the 285th anniversary of John Peter Zenger's acquittal |
|
From: Fritz, L. <Lar...@xy...> - 2020-08-04 15:44:35
|
It's not in my script, which would explain why my grep couldn't find it: "$JAVACMD" -cp "$CP" -splash:"$SQUIRREL_SQL_HOME/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main --log-config-file "$UNIX_STYLE_HOME"/log4j.properties --squirrel-home "$UNIX_STYLE_HOME" $NATIVE_LAF_PROP $SCRIPT_ARGS I'll try adding it and see if it resolves the problem. Larry Fritz Application Engineer | Sensus<https://sensus.com/> | Xylem<http://www.xyleminc.com/> M: 469-275-6042 Lar...@xy...<mailto:Lar...@xy...> LinkedIn<https://www.linkedin.com/company/sensus> | Twitter<https://twitter.com/SensusGlobal> | YouTube<https://www.youtube.com/c/SensusGlobal> | Facebook<https://www.facebook.com/SensusGlobal/> | Instagram<https://www.instagram.com/sensusglobal/> | 3D Tour<https://apps.kaonadn.net/5277329597136896/index.html> [cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55] From: Ferreira, Matt [mailto:Mat...@fi...] Sent: Tuesday, August 4, 2020 10:37 To: Fritz, Larry <Lar...@xy...>; squ...@li... Subject: RE: EXTERNAL: [Squirrel-sql-users] Query fails to execute At the very end of the script, the full line is: # Launch SQuirreL application $JAVACMD -Xmx256m -cp "$TMP_CP" $MACOSX_SQUIRREL_PROPS -splash:icons/splash.jpg net.sourceforge.squirrel_sql.client.Main --log-config-file "$UNIX_STYLE_HOME"/log4j.properties --squirrel-home "$UNIX_STYLE_HOME" $NATIVE_LAF_PROP $SCRIPT_ARGS Change the highlighted to 512 or 1024 (I'm running an older version, so it might be a little different) Matthew Ferreira Principal Technology Engineer / Team Lead [cid:ima...@01...0206D0] T: +1.978.275.5231 E: mat...@wo...<mailto:mat...@wo...> FIS | Advancing the way the world pays, banks and invests(tm) [cid:ima...@01...0206D0]<https://www.facebook.com/FIStoday>[cid:ima...@01...0206D0]<https://twitter.com/FISGlobal>[cid:ima...@01...0206D0]<https://www.linkedin.com/company/fis> From: Fritz, Larry <Lar...@xy...<mailto:Lar...@xy...>> Sent: Tuesday, August 4, 2020 11:35 AM To: Ferreira, Matt <Mat...@fi...<mailto:Mat...@fi...>>; squ...@li...<mailto:squ...@li...> Subject: RE: EXTERNAL: [Squirrel-sql-users] Query fails to execute Yes, the application shortcut is running the .sh file provided without any changes. Guessing I can just add the argument with the desired setting to the shortcut properties, as I don't see it set in the script itself nor can I find it in any of the properties files: -Xmx1024m Larry Fritz Application Engineer | Sensus<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsensus.com%2F&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856506672&sdata=BJwHGsI%2Bg8jjAnNy3gU15VgIahPq5lq2A8ED8cd5meI%3D&reserved=0> | Xylem<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.xyleminc.com%2F&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856516624&sdata=hdPshk8YJ%2FW2J9vWsSSiZZFUYcU%2BeIVRSpab1pusFS4%3D&reserved=0> M: 469-275-6042 Lar...@xy...<mailto:Lar...@xy...> LinkedIn<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fsensus&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856516624&sdata=cpMJFXxVwzvwvAX3fK7pJRlF0Y5n5CkkYV7e9WPjfwk%3D&reserved=0> | Twitter<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FSensusGlobal&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856526583&sdata=kk0%2BfH59j6TGQWq4K%2BQW147yj2hw8FN2XrSc6Ur6xTU%3D&reserved=0> | YouTube<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fc%2FSensusGlobal&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856526583&sdata=q8t7hrfHy%2BEXp%2FmnkF%2B3jPlfXYusnrdWvUdZregB5D8%3D&reserved=0> | Facebook<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FSensusGlobal%2F&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856526583&sdata=VQSeTsw1rXvbGfH83RQbCbleEb9PVKvt%2B5uCgx5hquM%3D&reserved=0> | Instagram<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fsensusglobal%2F&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856536561&sdata=qeDBkTnagnJIQUzrapSNRo5MGM7qKgoKseRAgc1YgeU%3D&reserved=0> | 3D Tour<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapps.kaonadn.net%2F5277329597136896%2Findex.html&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856536561&sdata=Nkf%2FZKIsW0sbtGn5TVxNfP3z3Tm9hNZeTFg7VTxgo9g%3D&reserved=0> [cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55] From: Ferreira, Matt [mailto:Mat...@fi...] Sent: Tuesday, August 4, 2020 10:15 To: Fritz, Larry <Lar...@xy...<mailto:Lar...@xy...>>; squ...@li...<mailto:squ...@li...> Subject: RE: EXTERNAL: [Squirrel-sql-users] Query fails to execute Are you using the included shell script? My initial thought is that you might need to increase the max memory settings. The default is set to 256: -Xmx256m Depending on how big your query file is, it might be bumping up against that (especially if you've run other stuff and haven't done manual GC) - if you have the memory try going to 512 or 1024 Matthew Ferreira Principal Technology Engineer / Team Lead [cid:ima...@01...0206D0] T: +1.978.275.5231 E: mat...@wo...<mailto:mat...@wo...> FIS | Advancing the way the world pays, banks and invests(tm) [cid:ima...@01...0206D0]<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FFIStoday&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856546510&sdata=goZaWNBsWsWbk8LJSzZS7YwAEftVoM%2BtBKjkIEz8rfg%3D&reserved=0>[cid:ima...@01...0206D0]<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FFISGlobal&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856546510&sdata=yDy1ah0llYesZjDz1k%2BfAtRqUuPiM%2FrmQ7kOHZwMIwE%3D&reserved=0>[cid:ima...@01...0206D0]<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Ffis&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856546510&sdata=f1Uoz06SYbJRoK%2BAJq%2FKQqv8cFO8eXBdyRr7x%2BIwh1k%3D&reserved=0> From: Fritz, Larry <Lar...@xy...<mailto:Lar...@xy...>> Sent: Tuesday, August 4, 2020 10:34 AM To: squ...@li...<mailto:squ...@li...> Subject: EXTERNAL: [Squirrel-sql-users] Query fails to execute Using Squirrel-SQL 4.0.0 on Linux Mint 19.3 running inside VirtualBox. Executing a long SQL file containing multiple queries sometimes fails to execute, and I do mean sometimes. It will work one day and not a few days later. And breaking the file into smaller queries, when that is possible, works fine, so it isn't the queries themselves which are problematic. Errors like the following appear in the squirrel-sql.log file whenever the problem occurs, varying only in the numbers. The only "mouse event" involved is clicking the "run all SQLs in editor" button. 2020-08-03 16:02:37,711 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(401,124),absolute(401,123),button=1,modifiers=Button1,clickCount=1] on frame0 java.lang.StackOverflowError 2020-08-03 16:03:38,117 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(402,121),absolute(402,120),button=1,modifiers=Button1,clickCount=1] on frame0 java.lang.StackOverflowError Each is followed by over 900 lines like " at java.base/java.util.regex.Pattern$<pattern>.match(Pattern.java:<digits>)", for example: at java.base/java.util.regex.Pattern$GroupTail.match(Pattern.java:4863) Using the keyboard shortcut, <shift><ctrl><Enter>, also results in an error: 2020-08-04 09:21:54,697 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.KeyEvent[KEY_PRESSED,keyCode=10,keyText=Enter,keyChar=Enter,modifiers=Alt+Shift,extModifiers=Alt+Shift,keyLocation=KEY_LOCATION_STANDARD,rawCode=36,primaryLevelUnicode=10,scancode=0,extendedKeyCode=0xa] on net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox[,69,0,167x24,layout=javax.swing.plaf.metal.MetalComboBoxUI$MetalComboBoxLayoutManager,alignmentX=0.0,alignmentY=0.0,border=,flags=328,maximumSize=java.awt.Dimension[width=167,height=24],minimumSize=,preferredSize=,isEditable=false,lightWeightPopupEnabled=true,maximumRowCount=8,selectedItemReminder=FlexnetDB] java.lang.StackOverflowError I tried searching the lists and bug reports but could not find anything comparable to this problem. Larry Fritz Application Engineer | Sensus<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsensus.com%2F&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856556463&sdata=K9W%2Fx930xJg5fc%2FYox%2B5wqWKbTnXhcMWrfnoD4BVr50%3D&reserved=0> | Xylem<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.xyleminc.com%2F&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856556463&sdata=DllBX%2F5LCJXgpxezq5GKlMwKKqtPyoeMTwKNuLV%2BkVg%3D&reserved=0> M: 469-275-6042 Lar...@xy...<mailto:Lar...@xy...> LinkedIn<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fsensus&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856566421&sdata=pOSN1ZevgUQ163t%2FLD124usruwWn3xscjiQF74i5w2k%3D&reserved=0> | Twitter<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FSensusGlobal&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856566421&sdata=zGZzEkcB8N7TOEInx8rx1uJ%2BJYDL0V0HE7jOPrv%2BrBc%3D&reserved=0> | YouTube<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fc%2FSensusGlobal&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856576375&sdata=o%2FEm%2BmCZfRuK2qADujreh9xTvxrUIfBx5xd2fvWz1FI%3D&reserved=0> | Facebook<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FSensusGlobal%2F&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856576375&sdata=3u0zRpOlqf8t3eHuKlN5Cr10UmC%2BynUMu%2BVU5puoqfY%3D&reserved=0> | Instagram<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fsensusglobal%2F&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856586334&sdata=nLtQ2GEzBQFyEPw0or4GQ7%2BY4ZUsr5V%2FzGc5lExXQFg%3D&reserved=0> | 3D Tour<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapps.kaonadn.net%2F5277329597136896%2Findex.html&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7C148b8364bad4427e799808d8388be994%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637321520856586334&sdata=AVMcNAUbh5G1w92AzEO4cY0v3s1O6cE%2B4f23ZZtceXs%3D&reserved=0> [cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55] The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. |
|
From: Roger H. <rh...@hi...> - 2020-08-04 15:36:14
|
Hi Larry It's a while since I did this, but it sounds like you need to increase the memory parameter for java in the startup script..it is something like Mx=512M. Sorry this is vague, but it might get you on the right track. Good luck. Roger Get BlueMail for Android On 4 Aug 2020, 16:07, at 16:07, "Fritz, Larry" <lar...@xy...> wrote: >Using Squirrel-SQL 4.0.0 on Linux Mint 19.3 running inside VirtualBox. > > >Executing a long SQL file containing multiple queries sometimes fails >to execute, and I do mean sometimes. It will work one day and not a >few days later. And breaking the file into smaller queries, when that >is possible, works fine, so it isn't the queries themselves which are >problematic. Errors like the following appear in the squirrel-sql.log >file whenever the problem occurs, varying only in the numbers. The >only "mouse event" involved is clicking the "run all SQLs in editor" >button. > >2020-08-03 16:02:37,711 [AWT-EventQueue-1] ERROR >net.sourceforge.squirrel_sql.client.Main - Exception occurred >dispatching Event >java.awt.event.MouseEvent[MOUSE_RELEASED,(401,124),absolute(401,123),button=1,modifiers=Button1,clickCount=1] >on frame0 >java.lang.StackOverflowError > >2020-08-03 16:03:38,117 [AWT-EventQueue-1] ERROR >net.sourceforge.squirrel_sql.client.Main - Exception occurred >dispatching Event >java.awt.event.MouseEvent[MOUSE_RELEASED,(402,121),absolute(402,120),button=1,modifiers=Button1,clickCount=1] >on frame0 >java.lang.StackOverflowError > >Each is followed by over 900 lines like " at >java.base/java.util.regex.Pattern$<pattern>.match(Pattern.java:<digits>)", >for example: >at java.base/java.util.regex.Pattern$GroupTail.match(Pattern.java:4863) > > >Using the keyboard shortcut, <shift><ctrl><Enter>, also results in an >error: > >2020-08-04 09:21:54,697 [AWT-EventQueue-1] ERROR >net.sourceforge.squirrel_sql.client.Main - Exception occurred >dispatching Event >java.awt.event.KeyEvent[KEY_PRESSED,keyCode=10,keyText=Enter,keyChar=Enter,modifiers=Alt+Shift,extModifiers=Alt+Shift,keyLocation=KEY_LOCATION_STANDARD,rawCode=36,primaryLevelUnicode=10,scancode=0,extendedKeyCode=0xa] >on >net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox[,69,0,167x24,layout=javax.swing.plaf.metal.MetalComboBoxUI$MetalComboBoxLayoutManager,alignmentX=0.0,alignmentY=0.0,border=,flags=328,maximumSize=java.awt.Dimension[width=167,height=24],minimumSize=,preferredSize=,isEditable=false,lightWeightPopupEnabled=true,maximumRowCount=8,selectedItemReminder=FlexnetDB] >java.lang.StackOverflowError > > >I tried searching the lists and bug reports but could not find anything >comparable to this problem. > >Larry Fritz >Application Engineer | Sensus<https://sensus.com/> | >Xylem<http://www.xyleminc.com/> >M: 469-275-6042 >Lar...@xy...<mailto:Lar...@xy...> > >LinkedIn<https://www.linkedin.com/company/sensus> | >Twitter<https://twitter.com/SensusGlobal> | >YouTube<https://www.youtube.com/c/SensusGlobal> | >Facebook<https://www.facebook.com/SensusGlobal/> | >Instagram<https://www.instagram.com/sensusglobal/> | 3D >Tour<https://apps.kaonadn.net/5277329597136896/index.html> > >[cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55] > > > >------------------------------------------------------------------------ > > > >------------------------------------------------------------------------ > >_______________________________________________ >Squirrel-sql-users mailing list >Squ...@li... >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Fritz, L. <Lar...@xy...> - 2020-08-04 15:34:56
|
Yes, the application shortcut is running the .sh file provided without any changes. Guessing I can just add the argument with the desired setting to the shortcut properties, as I don't see it set in the script itself nor can I find it in any of the properties files: -Xmx1024m Larry Fritz Application Engineer | Sensus<https://sensus.com/> | Xylem<http://www.xyleminc.com/> M: 469-275-6042 Lar...@xy...<mailto:Lar...@xy...> LinkedIn<https://www.linkedin.com/company/sensus> | Twitter<https://twitter.com/SensusGlobal> | YouTube<https://www.youtube.com/c/SensusGlobal> | Facebook<https://www.facebook.com/SensusGlobal/> | Instagram<https://www.instagram.com/sensusglobal/> | 3D Tour<https://apps.kaonadn.net/5277329597136896/index.html> [cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55] From: Ferreira, Matt [mailto:Mat...@fi...] Sent: Tuesday, August 4, 2020 10:15 To: Fritz, Larry <Lar...@xy...>; squ...@li... Subject: RE: EXTERNAL: [Squirrel-sql-users] Query fails to execute Are you using the included shell script? My initial thought is that you might need to increase the max memory settings. The default is set to 256: -Xmx256m Depending on how big your query file is, it might be bumping up against that (especially if you've run other stuff and haven't done manual GC) - if you have the memory try going to 512 or 1024 Matthew Ferreira Principal Technology Engineer / Team Lead [cid:image002.png@01D66A49.DCABC5D0] T: +1.978.275.5231 E: mat...@wo...<mailto:mat...@wo...> FIS | Advancing the way the world pays, banks and invests(tm) [cid:image003.png@01D66A49.DCABC5D0]<https://www.facebook.com/FIStoday>[cid:image004.png@01D66A49.DCABC5D0]<https://twitter.com/FISGlobal>[cid:image005.png@01D66A49.DCABC5D0]<https://www.linkedin.com/company/fis> From: Fritz, Larry <Lar...@xy...<mailto:Lar...@xy...>> Sent: Tuesday, August 4, 2020 10:34 AM To: squ...@li...<mailto:squ...@li...> Subject: EXTERNAL: [Squirrel-sql-users] Query fails to execute Using Squirrel-SQL 4.0.0 on Linux Mint 19.3 running inside VirtualBox. Executing a long SQL file containing multiple queries sometimes fails to execute, and I do mean sometimes. It will work one day and not a few days later. And breaking the file into smaller queries, when that is possible, works fine, so it isn't the queries themselves which are problematic. Errors like the following appear in the squirrel-sql.log file whenever the problem occurs, varying only in the numbers. The only "mouse event" involved is clicking the "run all SQLs in editor" button. 2020-08-03 16:02:37,711 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(401,124),absolute(401,123),button=1,modifiers=Button1,clickCount=1] on frame0 java.lang.StackOverflowError 2020-08-03 16:03:38,117 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(402,121),absolute(402,120),button=1,modifiers=Button1,clickCount=1] on frame0 java.lang.StackOverflowError Each is followed by over 900 lines like " at java.base/java.util.regex.Pattern$<pattern>.match(Pattern.java:<digits>)", for example: at java.base/java.util.regex.Pattern$GroupTail.match(Pattern.java:4863) Using the keyboard shortcut, <shift><ctrl><Enter>, also results in an error: 2020-08-04 09:21:54,697 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.KeyEvent[KEY_PRESSED,keyCode=10,keyText=Enter,keyChar=Enter,modifiers=Alt+Shift,extModifiers=Alt+Shift,keyLocation=KEY_LOCATION_STANDARD,rawCode=36,primaryLevelUnicode=10,scancode=0,extendedKeyCode=0xa] on net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox[,69,0,167x24,layout=javax.swing.plaf.metal.MetalComboBoxUI$MetalComboBoxLayoutManager,alignmentX=0.0,alignmentY=0.0,border=,flags=328,maximumSize=java.awt.Dimension[width=167,height=24],minimumSize=,preferredSize=,isEditable=false,lightWeightPopupEnabled=true,maximumRowCount=8,selectedItemReminder=FlexnetDB] java.lang.StackOverflowError I tried searching the lists and bug reports but could not find anything comparable to this problem. Larry Fritz Application Engineer | Sensus<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsensus.com%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939975608&sdata=3UM87W%2B2G2UGTPS0nyOZ1nx0xE7zRgc%2FvYw69jcXTt0%3D&reserved=0> | Xylem<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.xyleminc.com%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939975608&sdata=5%2BtvPxREbnurwd3%2BEAvIpvYFrgYXpKJNF7O%2BwkHMW3I%3D&reserved=0> M: 469-275-6042 Lar...@xy...<mailto:Lar...@xy...> LinkedIn<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fsensus&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939985610&sdata=6vT%2BG%2FHxJFwuSTW2jDwDy6OLxVzmA5%2BX1w3bKi0VdfI%3D&reserved=0> | Twitter<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FSensusGlobal&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939995610&sdata=fR7GmrKIR0OWEcqs9uEiT3zhqgL4Ey8n5d%2FKgcnSH9E%3D&reserved=0> | YouTube<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fc%2FSensusGlobal&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939995610&sdata=F8fUtgiSbYqHLzdgFGLzCf%2FhIWea4D1yFvv%2Ft2UdxG0%3D&reserved=0> | Facebook<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FSensusGlobal%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504940005604&sdata=8k3z5VbIrIbdq8r78bJ4cJ%2F7flAjy%2Bkq7GnRy%2FNDwHY%3D&reserved=0> | Instagram<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fsensusglobal%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504940005604&sdata=kTaJ6QKLvJAyWwwoM9S7ERtGBUR3EZraZ2b7apLP%2BZM%3D&reserved=0> | 3D Tour<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapps.kaonadn.net%2F5277329597136896%2Findex.html&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504940015603&sdata=zFPNS1Cs6Umex3NMtcNPEIEsV24PBsVr%2FB0fC21nyR4%3D&reserved=0> [cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55] The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. |
|
From: Ferreira, M. <Mat...@fi...> - 2020-08-04 15:30:34
|
Are you using the included shell script? My initial thought is that you might need to increase the max memory settings. The default is set to 256: -Xmx256m Depending on how big your query file is, it might be bumping up against that (especially if you've run other stuff and haven't done manual GC) - if you have the memory try going to 512 or 1024 Matthew Ferreira Principal Technology Engineer / Team Lead [cid:image002.png@01D66A50.6F9EE2E0] T: +1.978.275.5231 E: mat...@wo...<mailto:mat...@wo...> FIS | Advancing the way the world pays, banks and invests(tm) [cid:image003.png@01D66A50.6F9EE2E0]<https://www.facebook.com/FIStoday>[cid:image004.png@01D66A50.6F9EE2E0]<https://twitter.com/FISGlobal>[cid:image005.png@01D66A50.6F9EE2E0]<https://www.linkedin.com/company/fis> From: Fritz, Larry <Lar...@xy...> Sent: Tuesday, August 4, 2020 10:34 AM To: squ...@li... Subject: EXTERNAL: [Squirrel-sql-users] Query fails to execute Using Squirrel-SQL 4.0.0 on Linux Mint 19.3 running inside VirtualBox. Executing a long SQL file containing multiple queries sometimes fails to execute, and I do mean sometimes. It will work one day and not a few days later. And breaking the file into smaller queries, when that is possible, works fine, so it isn't the queries themselves which are problematic. Errors like the following appear in the squirrel-sql.log file whenever the problem occurs, varying only in the numbers. The only "mouse event" involved is clicking the "run all SQLs in editor" button. 2020-08-03 16:02:37,711 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(401,124),absolute(401,123),button=1,modifiers=Button1,clickCount=1] on frame0 java.lang.StackOverflowError 2020-08-03 16:03:38,117 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(402,121),absolute(402,120),button=1,modifiers=Button1,clickCount=1] on frame0 java.lang.StackOverflowError Each is followed by over 900 lines like " at java.base/java.util.regex.Pattern$<pattern>.match(Pattern.java:<digits>)", for example: at java.base/java.util.regex.Pattern$GroupTail.match(Pattern.java:4863) Using the keyboard shortcut, <shift><ctrl><Enter>, also results in an error: 2020-08-04 09:21:54,697 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.KeyEvent[KEY_PRESSED,keyCode=10,keyText=Enter,keyChar=Enter,modifiers=Alt+Shift,extModifiers=Alt+Shift,keyLocation=KEY_LOCATION_STANDARD,rawCode=36,primaryLevelUnicode=10,scancode=0,extendedKeyCode=0xa] on net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox[,69,0,167x24,layout=javax.swing.plaf.metal.MetalComboBoxUI$MetalComboBoxLayoutManager,alignmentX=0.0,alignmentY=0.0,border=,flags=328,maximumSize=java.awt.Dimension[width=167,height=24],minimumSize=,preferredSize=,isEditable=false,lightWeightPopupEnabled=true,maximumRowCount=8,selectedItemReminder=FlexnetDB] java.lang.StackOverflowError I tried searching the lists and bug reports but could not find anything comparable to this problem. Larry Fritz Application Engineer | Sensus<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsensus.com%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939975608&sdata=3UM87W%2B2G2UGTPS0nyOZ1nx0xE7zRgc%2FvYw69jcXTt0%3D&reserved=0> | Xylem<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.xyleminc.com%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939975608&sdata=5%2BtvPxREbnurwd3%2BEAvIpvYFrgYXpKJNF7O%2BwkHMW3I%3D&reserved=0> M: 469-275-6042 Lar...@xy...<mailto:Lar...@xy...> LinkedIn<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fsensus&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939985610&sdata=6vT%2BG%2FHxJFwuSTW2jDwDy6OLxVzmA5%2BX1w3bKi0VdfI%3D&reserved=0> | Twitter<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FSensusGlobal&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939995610&sdata=fR7GmrKIR0OWEcqs9uEiT3zhqgL4Ey8n5d%2FKgcnSH9E%3D&reserved=0> | YouTube<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fc%2FSensusGlobal&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939995610&sdata=F8fUtgiSbYqHLzdgFGLzCf%2FhIWea4D1yFvv%2Ft2UdxG0%3D&reserved=0> | Facebook<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FSensusGlobal%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504940005604&sdata=8k3z5VbIrIbdq8r78bJ4cJ%2F7flAjy%2Bkq7GnRy%2FNDwHY%3D&reserved=0> | Instagram<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fsensusglobal%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504940005604&sdata=kTaJ6QKLvJAyWwwoM9S7ERtGBUR3EZraZ2b7apLP%2BZM%3D&reserved=0> | 3D Tour<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapps.kaonadn.net%2F5277329597136896%2Findex.html&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504940015603&sdata=zFPNS1Cs6Umex3NMtcNPEIEsV24PBsVr%2FB0fC21nyR4%3D&reserved=0> [cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55] The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. |
|
From: Fritz, L. <Lar...@xy...> - 2020-08-04 15:06:40
|
Using Squirrel-SQL 4.0.0 on Linux Mint 19.3 running inside VirtualBox.
Executing a long SQL file containing multiple queries sometimes fails to execute, and I do mean sometimes. It will work one day and not a few days later. And breaking the file into smaller queries, when that is possible, works fine, so it isn't the queries themselves which are problematic. Errors like the following appear in the squirrel-sql.log file whenever the problem occurs, varying only in the numbers. The only "mouse event" involved is clicking the "run all SQLs in editor" button.
2020-08-03 16:02:37,711 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(401,124),absolute(401,123),button=1,modifiers=Button1,clickCount=1] on frame0
java.lang.StackOverflowError
2020-08-03 16:03:38,117 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(402,121),absolute(402,120),button=1,modifiers=Button1,clickCount=1] on frame0
java.lang.StackOverflowError
Each is followed by over 900 lines like " at java.base/java.util.regex.Pattern$<pattern>.match(Pattern.java:<digits>)", for example:
at java.base/java.util.regex.Pattern$GroupTail.match(Pattern.java:4863)
Using the keyboard shortcut, <shift><ctrl><Enter>, also results in an error:
2020-08-04 09:21:54,697 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.KeyEvent[KEY_PRESSED,keyCode=10,keyText=Enter,keyChar=Enter,modifiers=Alt+Shift,extModifiers=Alt+Shift,keyLocation=KEY_LOCATION_STANDARD,rawCode=36,primaryLevelUnicode=10,scancode=0,extendedKeyCode=0xa] on net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox[,69,0,167x24,layout=javax.swing.plaf.metal.MetalComboBoxUI$MetalComboBoxLayoutManager,alignmentX=0.0,alignmentY=0.0,border=,flags=328,maximumSize=java.awt.Dimension[width=167,height=24],minimumSize=,preferredSize=,isEditable=false,lightWeightPopupEnabled=true,maximumRowCount=8,selectedItemReminder=FlexnetDB]
java.lang.StackOverflowError
I tried searching the lists and bug reports but could not find anything comparable to this problem.
Larry Fritz
Application Engineer | Sensus<https://sensus.com/> | Xylem<http://www.xyleminc.com/>
M: 469-275-6042
Lar...@xy...<mailto:Lar...@xy...>
LinkedIn<https://www.linkedin.com/company/sensus> | Twitter<https://twitter.com/SensusGlobal> | YouTube<https://www.youtube.com/c/SensusGlobal> | Facebook<https://www.facebook.com/SensusGlobal/> | Instagram<https://www.instagram.com/sensusglobal/> | 3D Tour<https://apps.kaonadn.net/5277329597136896/index.html>
[cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55]
|
|
From: Alarcón V. <vla...@ya...> - 2020-07-23 01:03:51
|
In Oracle, by default column identifiers are in upper case. Nevertheless, if you want lower case identifiers, you can create them in lower case by enclosing them in double quotes ("). It would be a pain in the neck to type this way, but if you project demands it...
On Friday, July 17, 2020, 12:34:25 PM EDT, J Doe <jdo...@gm...> wrote:
Hi All,I have been using Squirrel for many years and it is great that such a free tool is available. Mostly I use it with Oracle and my requirement is as follows.
Right now when I get the column from alias using control space, I get the the column name in UPPER case and my requirement is to have the column name in lower case as this is project coding standard.
I will appreciate it if someone can help?
Thanks.
John_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
|
From: Gerd W. <ger...@t-...> - 2020-07-20 19:50:53
|
Is implemented and available in the latest snapshot: https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20200720_2132/ Excerpt from change log: Code completion Plugin: New options to choose if columns/tables and views/schemas/catalogs are to be completed uppercase or lowercase or unchanged. See menu File --> New Session Properties --> tab Code Completion --> bottom of panel. Gerd Am 17.07.20 um 18:32 schrieb J Doe: > Hi All, > I have been using Squirrel for many years and it is great that such a > free tool is available. Mostly I use it with Oracle and my requirement > is as follows. > > Right now when I get the column from alias using control space, I get > the the column name in UPPER case and my requirement is to have the > column name in lower case as this is project coding standard. > > I will appreciate it if someone can help? > > Thanks. > > John > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: J D. <jdo...@gm...> - 2020-07-17 16:33:15
|
Hi All, I have been using Squirrel for many years and it is great that such a free tool is available. Mostly I use it with Oracle and my requirement is as follows. Right now when I get the column from alias using control space, I get the the column name in UPPER case and my requirement is to have the column name in lower case as this is project coding standard. I will appreciate it if someone can help? Thanks. John |
|
From: Gerd W. <ger...@t-...> - 2020-06-19 13:18:47
|
Am 18.06.20 um 21:44 schrieb GWIN, IVORY: > Looking for examples on how to execute sql code from a window command > line or bat file. Please have look at squirrelcli/Readme.txt of your SQuirreL installation directory. Gerd > > thanks > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Gerd W. <ger...@t-...> - 2020-06-19 13:16:01
|
Am 19.06.20 um 04:11 schrieb Bryan Montgomery via Squirrel-sql-users: > Hello, > Running 4.1.0 on windows, I am connected to a mariadb using the MariaDb > driver. When I look at the session menu, MySql is disabled. Is this > still relevant? How do I enable the option? It will become enabled when you are connected to a MySQL DB. That the menu is there tells that you have to MySQL Plugin installed. Gerd > > Thanks - Bryan. > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Bryan M. <br...@tp...> - 2020-06-19 02:27:51
|
Hello, Running 4.1.0 on windows, I am connected to a mariadb using the MariaDb driver. When I look at the session menu, MySql is disabled. Is this still relevant? How do I enable the option? Thanks - Bryan. |
|
From: Roger H. <rh...@hi...> - 2020-06-19 00:05:28
|
Well, looking up the psql command and its parameters should give you what you need. Put the SQL in a text file, and something like psql < text.file Should do it. I work in Linux. Others can help you with windows. Roger Get BlueMail for Android On 18 Jun 2020, 19:54, at 19:54, "GWIN, IVORY" <ig...@at...> wrote: >I’m running against a Postgres database. >Ivory > >From: Roger Hill <rh...@hi...> >Sent: Thursday, June 18, 2020 4:59 PM >To: GWIN, IVORY <ig...@at...> >Cc: squ...@li... >Subject: Re: [Squirrel-sql-users] executing sql for command line > > >Hi. > >Against what database? Postgres, Mysql, Ingres etc etc? > >But this is nothing to do with Squirrel SQL directly. > >Roger >--- >*************************** >Roger Hill >*************************** > > > >On 2020-06-18 15:44, GWIN, IVORY wrote: >Looking for examples on how to execute sql code from a window command >line or bat file. > > >thanks > >_______________________________________________ >Squirrel-sql-users mailing list >Squ...@li...<mailto:Squ...@li...> >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.sourceforge.net_lists_listinfo_squirrel-2Dsql-2Dusers&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=mP5C9LLnb4KzPsxXvl5F6g&m=7AhZ4E3nmjbpq5yrr08zWhKKmQwC0nVytDXTE8Z7DuE&s=MBlcstUd10SOOXwQLyEWhdUGNi4xsTEVnkTrzDbfgE4&e=> > > >------------------------------------------------------------------------ > > > >------------------------------------------------------------------------ > >_______________________________________________ >Squirrel-sql-users mailing list >Squ...@li... >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: John H. <jh...@im...> - 2020-06-18 23:57:13
|
On Thu, 18 Jun 2020, GWIN, IVORY wrote: > Looking for examples on how to execute sql code from a window command line or bat file. Squirrel is primarily an interactive query tool, modulo some of the plugins (like import/export). Running queries from a batch file or command prompt is probably going to be better-suited to the native command-line query tool that comes with whatever database platform you're talking to (e.g. isql). -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- It is criminal to teach a man not to defend himself when he is the constant victim of brutal attacks. -- Malcolm X (1964) ----------------------------------------------------------------------- Today: SWMBO's Birthday |
|
From: GWIN, I. <ig...@at...> - 2020-06-18 23:53:53
|
I’m running against a Postgres database. Ivory From: Roger Hill <rh...@hi...> Sent: Thursday, June 18, 2020 4:59 PM To: GWIN, IVORY <ig...@at...> Cc: squ...@li... Subject: Re: [Squirrel-sql-users] executing sql for command line Hi. Against what database? Postgres, Mysql, Ingres etc etc? But this is nothing to do with Squirrel SQL directly. Roger --- *************************** Roger Hill *************************** On 2020-06-18 15:44, GWIN, IVORY wrote: Looking for examples on how to execute sql code from a window command line or bat file. thanks _______________________________________________ Squirrel-sql-users mailing list Squ...@li...<mailto:Squ...@li...> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.sourceforge.net_lists_listinfo_squirrel-2Dsql-2Dusers&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=mP5C9LLnb4KzPsxXvl5F6g&m=7AhZ4E3nmjbpq5yrr08zWhKKmQwC0nVytDXTE8Z7DuE&s=MBlcstUd10SOOXwQLyEWhdUGNi4xsTEVnkTrzDbfgE4&e=> |
|
From: Roger H. <rh...@hi...> - 2020-06-18 22:15:23
|
Hi. Against what database? Postgres, Mysql, Ingres etc etc? But this is nothing to do with Squirrel SQL directly. Roger --- *************************** Roger Hill *************************** On 2020-06-18 15:44, GWIN, IVORY wrote: > Looking for examples on how to execute sql code from a window command line or bat file. > > thanks > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: GWIN, I. <ig...@at...> - 2020-06-18 22:11:08
|
GWIN, IVORY would like to recall the message, "executing ". |
|
From: GWIN, I. <ig...@at...> - 2020-06-18 21:48:36
|
Looking for examples on how to execute sql code from a window command line or bat file. thanks |
|
From: GWIN, I. <ig...@at...> - 2020-06-18 21:33:59
|
Thanks Ivory Gwin Senior-System Engineer AEIS IT - OMS/SDP/IOMIP Phone: 773-628-8643 Cell: 847-217-0864 [cid:image001.jpg@01D64576.436F8D90] |
|
From: Gerd W. <ger...@t-...> - 2020-06-11 02:16:08
|
Am 25.05.20 um 13:50 schrieb Marek Lasota: > I would like to uninstall Squirrel-SQL kompletlly silent, ev. using an > script with an option to delete the program library. > > Is it possible? Not using the uninstaller. Here's a manual/scriptable way to do it: - Delete SQuirreL's installation and user directory. - In case shortcuts exist find out where the shortcut files are located and delete them, too. Gerd > > Marek Lasota > > mar...@gm... > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Gerd W. <ger...@t-...> - 2020-06-11 02:07:25
|
Am 25.05.20 um 13:45 schrieb Marek Lasota: > Halo, > > there is still an issue using generated script for silent installation. > Even if demanded so, n0 start icons for OTHER user as installer are > generated. Is there any possibility to manipulate the installer script > to get the link defined, as is the case using GUI. Not that I know of. But here are some hints if you'd like to figure it out: Here's short description on how to build SQuirrel: http://www.squirrelsql.org/index.php?page=programing If you manage to build SQuirreL, look at the files shortcutSpec.xml or Unix_shortcutSpec.xml. These xmls are part of SQuirreL's IzPack-Installer, see http://izpack.org/ A specification of the xmls can be found here: https://izpack.atlassian.net/wiki/spaces/IZPACK/pages/491733/Shortcut+Specification?showCommentArea=true&showComments=true If you don't want to build SQuirreL you may try to unpack and later repack the installer jar. The xmls are placed in subdirectory res/. If you manage to make it work please let me know and I'll see if I can integrate it into SQuirreL. Gerd > > Marek Lasota > mar...@gm... > > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Marek L. <mar...@gm...> - 2020-05-25 11:50:23
|
I would like to uninstall Squirrel-SQL kompletlly silent, ev. using an script with an option to delete the program library. Is it possible? Marek Lasota mar...@gm... |
|
From: Marek L. <mar...@gm...> - 2020-05-25 11:45:36
|
Halo, there is still an issue using generated script for silent installation. Even if demanded so, n0 start icons for OTHER user as installer are generated. Is there any possibility to manipulate the installer script to get the link defined, as is the case using GUI. Marek Lasota mar...@gm... |
