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: Vaughan W. <vw...@ze...> - 2018-08-23 02:24:44
|
Hello, I'm new to Squirrel. I'm trying to configure Squirrel to access a local Firebird database on a Windows computer. I have the Squirrel Client 3.8.1 installed The Firebird plugin (0.0.2) is loaded I understand that I also need to load the Firebird driver, I'm not clear on how to do this I have downloaded the driver: Jaybird-3.0.4-JDK_1.8 Extracted the ZIP, I'm unclear on where the files need to be placed I have tried coping the files as follows: 05/05/2018 13:10 2,466,664 jaybird-3.0.4-javadoc.jar 05/05/2018 13:10 925,780 jaybird-3.0.4-sources.jar 05/05/2018 13:10 1,139,445 jaybird-3.0.4.jar 05/05/2018 13:10 1,037,129 jaybird-3.0.4.rar 05/05/2018 13:10 1,167,642 jaybird-full-3.0.4.jar To: C:\Program Files\squirrel-sql-3.8.1 And the contents of the lib folder: Jaybird-3.0.4-JDK_1.8\lib To: C:\Program Files\squirrel-sql-3.8.1\lib After restarting the Squirrel Client, the Firebird driver still has an 'X' Thanks Regards, Vaughan |
|
From: Julian F. <j.f...@pr...> - 2018-08-13 14:13:25
|
Hi devs, First, a short disclaimer, I am cross-posting this question on the calcite and on the SQuirrelSQL mailing list as I’m not really sure where the problem comes from. I am using Apache Calcite [1] as custom driver in SQuirrelSQL. Internally, Calcite uses Code generation and the Janino Compiler [2] to generate dynamic classes. Sadly, the Calcite Queries fail at this stage with the following Stacktrace: 2018-08-13 13:06:15,471 [Thread-3] DEBUG net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter - Error 593 java.sql.SQLException: Error while executing SQL "SELECT * FROM metadata.TABLES": Unable to instantiate java compiler 594 at org.apache.calcite.avatica.Helper.createException(Helper.java:56) 595 at org.apache.calcite.avatica.Helper.createException(Helper.java:41) 596 at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156) 597 at org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:209) 598 at net.sourceforge.squirrel_sql.client.session.StatementWrapper.execute(StatementWrapper.java:165) 599 at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:369) 600 at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:212) 601 at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) 602 at java.lang.Thread.run(Thread.java:745) 603 Caused by: java.lang.IllegalStateException: Unable to instantiate java compiler 604 at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.compile(JaninoRelMetadataProvider.java:433) 605 at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.load3(JaninoRelMetadataProvider.java:374) 606 at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.access$000(JaninoRelMetadataProvider.java:94) 607 at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider$1.load(JaninoRelMetadataProvider.java:113) 608 at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider$1.load(JaninoRelMetadataProvider.java:110) 609 at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3542) 610 at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2323) 611 at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2286) 612 at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2201) 613 at com.google.common.cache.LocalCache.get(LocalCache.java:3953) 614 at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3957) 615 at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4875) 616 at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.create(JaninoRelMetadataProvider.java:464) 617 at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.revise(JaninoRelMetadataProvider.java:477) 618 at org.apache.calcite.rel.metadata.RelMetadataQuery.revise(RelMetadataQuery.java:203) 619 at org.apache.calcite.rel.metadata.RelMetadataQuery.collations(RelMetadataQuery.java:565) 620 at org.apache.calcite.rel.metadata.RelMdCollation.project(RelMdCollation.java:207) 621 at org.apache.calcite.rel.logical.LogicalProject$1.get(LogicalProject.java:117) 622 at org.apache.calcite.rel.logical.LogicalProject$1.get(LogicalProject.java:115) 623 at org.apache.calcite.plan.RelTraitSet.replaceIfs(RelTraitSet.java:238) 624 at org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:113) 625 at org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:103) 626 at org.apache.calcite.rel.core.RelFactories$ProjectFactoryImpl.createProject(RelFactories.java:127) 627 at org.apache.calcite.tools.RelBuilder.project(RelBuilder.java:956) 628 at org.apache.calcite.plan.RelOptUtil.createProject(RelOptUtil.java:2952) 629 at org.apache.calcite.plan.RelOptUtil.createProject(RelOptUtil.java:2910) 630 at org.apache.calcite.plan.RelOptUtil.createProject(RelOptUtil.java:2854) 631 at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectList(SqlToRelConverter.java:3734) 632 at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:662) 633 at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:619) 634 at org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3028) 635 at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:555) 636 at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:266) 637 at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:230) 638 at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:786) 639 at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:640) 640 at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:610) 641 at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:221) 642 at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:603) 643 at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:638) 644 at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:149) 645 ... 6 more 646 Caused by: java.lang.ClassNotFoundException: No implementation of org.codehaus.commons.compiler is on the class path. Typically, you'd have 'janino.jar', or 'commons-compiler-jdk.jar', or both on the classpath. 647 at org.codehaus.commons.compiler.CompilerFactoryFactory.getDefaultCompilerFactory(CompilerFactoryFactory.java:59) 648 at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.compile(JaninoRelMetadataProvider.java:431) 649 ... 46 more I also added janino-2.76.jar as well as commons-compiler-2.7.6.jar to the classpath but the Exception does not go away. Is there any usage of these packages in SQuirrelSQL or a possibility that these are shaded or a version incompatibility exists? Thanks! Julian [1] https://calcite.apache.org/ [2] https://janino-compiler.github.io/janino/ |
|
From: Alexandre P. <Ale...@ei...> - 2018-08-07 22:49:28
|
You need to download Oracle JDBC driver (ojdbc7.jar and/or ojdbc6.jar) and add it to the SQuirreL list of drivers. If you were able to connect to Oracle in the previous version, you already have the driver - just enable it. -- Alexandre Peshansky, MS Lead Bioinformatics Analyst, Research Informatics Core (RIC) Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore Albert Einstein College of Medicine 1300 Morris Park Ave, Block Bldg., Rm 534 Bronx, NY 10461 (914) 294-6916 (office) (201) 970-3530 (cell) [cid:image001.png@01D42E74.02145D00] From: Pete Storer [mailto:Pet...@sa...] Sent: Tuesday, August 07, 2018 1:40 PM To: squ...@li... Subject: [Squirrel-sql-users] Oracle driver change for SQuireL 3.8.1 I just upgraded our Squirrel client from 3.7.1 to 3.8.1 using the downloaded jar file. The installation seemed to go okay, but now the only valid driver that I am showing in my list is a Postgres driver. Most critically, the Oracle driver that I use for a LOT of connections is broken - I see the following errors: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver Could not find class oracle.jdbc.driver.OracleDriver in neither the Java class path nor the Extra class path of the Oracle Thin Driver driver definition: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver Could not find class oracle.jdbc.driver.OracleDriver in neither the Java class path nor the Extra class path of the Oracle Thin Driver driver definition: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver I am nobody's Java expert, so I haven't a clue what the problem is or how to resolve it. I do know that Java 1.8.071 is running on this server, which should be sufficient. Any guidance would be most appreciated. Thanks. Pete Storer |
|
From: Welch, B. <wil...@me...> - 2018-08-07 21:48:17
|
To the best of my memory, a new install of squirrel doesn't pick up the configuration of the previous install, so you have to reconnect all the drivers and redefine the servers. To add a JDBC driver, see http://www.squirrelsql.org/index.php?page=screenshots, Step 1. There are two parts - pointing to the archive containing the required class files and then selecting the class file that provides the JDBC interface. From: Pete Storer <Pet...@sa...> Date: Tuesday, 7 August,2018 at 17:15 To: "squ...@li..." <squ...@li...> Subject: [Squirrel-sql-users] Oracle driver change for SQuireL 3.8.1 EXTERNAL EMAIL – Use caution with any links or file attachments. I just upgraded our Squirrel client from 3.7.1 to 3.8.1 using the downloaded jar file. The installation seemed to go okay, but now the only valid driver that I am showing in my list is a Postgres driver. Most critically, the Oracle driver that I use for a LOT of connections is broken – I see the following errors: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver Could not find class oracle.jdbc.driver.OracleDriver in neither the Java class path nor the Extra class path of the Oracle Thin Driver driver definition: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver Could not find class oracle.jdbc.driver.OracleDriver in neither the Java class path nor the Extra class path of the Oracle Thin Driver driver definition: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver I am nobody’s Java expert, so I haven’t a clue what the problem is or how to resolve it. I do know that Java 1.8.071 is running on this server, which should be sufficient. Any guidance would be most appreciated. Thanks. Pete Storer Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (2000 Galloping Hill Road, Kenilworth, New Jersey, USA 07033), and/or its affiliates Direct contact information for affiliates is available at http://www.merck.com/contact/contacts.html) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. |
|
From: Jim A. <jim...@gm...> - 2018-08-07 21:28:25
|
Possibly check your driver setup? On Tue, Aug 7, 2018 at 10:40 AM, Pete Storer <Pet...@sa...> wrote: > I just upgraded our Squirrel client from 3.7.1 to 3.8.1 using the > downloaded jar file. The installation seemed to go okay, but now the only > valid driver that I am showing in my list is a Postgres driver. Most > critically, the Oracle driver that I use for a LOT of connections is broken > – I see the following errors: > > > > java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver > > Could not find class oracle.jdbc.driver.OracleDriver in neither the Java > class path nor the Extra class path of the Oracle Thin Driver driver > definition: > > java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver > > Could not find class oracle.jdbc.driver.OracleDriver in neither the Java > class path nor the Extra class path of the Oracle Thin Driver driver > definition: > > java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver > > > > I am nobody’s Java expert, so I haven’t a clue what the problem is or how > to resolve it. I do know that Java 1.8.071 is running on this server, which > should be sufficient. Any guidance would be most appreciated. > > > > Thanks. > > > > Pete Storer > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
|
From: Pete S. <Pet...@sa...> - 2018-08-07 21:14:34
|
I just upgraded our Squirrel client from 3.7.1 to 3.8.1 using the downloaded jar file. The installation seemed to go okay, but now the only valid driver that I am showing in my list is a Postgres driver. Most critically, the Oracle driver that I use for a LOT of connections is broken - I see the following errors: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver Could not find class oracle.jdbc.driver.OracleDriver in neither the Java class path nor the Extra class path of the Oracle Thin Driver driver definition: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver Could not find class oracle.jdbc.driver.OracleDriver in neither the Java class path nor the Extra class path of the Oracle Thin Driver driver definition: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver I am nobody's Java expert, so I haven't a clue what the problem is or how to resolve it. I do know that Java 1.8.071 is running on this server, which should be sufficient. Any guidance would be most appreciated. Thanks. Pete Storer |
|
From: Gerd W. <ger...@t-...> - 2018-07-28 19:01:19
|
Am 20.07.2018 um 11:23 schrieb ADAN M. M. via Squirrel-sql-users: > Hello > > > I tried to run squirrel-sql.bat from squirrelsql-3.8.1-optional and i > cannot, then i tried deleting -Xquickstart option from > > line > > start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Xmn256m -Xmx256m > -XX:+AggressiveOpts -XX:MaxGCPauseMillis=10 -XX:MaxHeapFreeRatio=70 > -Xss2m -Xverify:none -*Xquickstart* -Dsun.awt.nopixfmt=true > -Dsun.java2d.noddraw=true -cp %SQUIRREL_CP% > -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" > net.sourceforge.squirrel_sql.client.Main %TMP_PARMS% Sorry, I can't remember that we ever had -Xquickstart in our starter scripts. Same with -XX:+AggressiveOpts -XX:MaxGCPauseMillis=10 -XX:MaxHeapFreeRatio=70 -Xss2m -Xverify:none At least we don't have them in our scripts now. I recommend to remove all of these from your script. Gerd |
|
From: Gerd W. <ger...@t-...> - 2018-07-27 17:48:01
|
Am 11.07.2018 um 16:12 schrieb Dharmin Shah via Squirrel-sql-users: > Hi, > > I was reading the documentation, and the Session Properties section > (http://squirrel-sql.sourceforge.net/user-manual/quick_start.html#session_props > ) shows a screen shot that has “Show String Data for Columns of these > Data Types” under the SQL tab. However, I do not see that in the v3.8.1 > for Mac. I have a column that is displaying VARBINARY, but all it shows > me is the byte array, not the string version of it. > This documentation is much out of date. I didn't even know that it existed and I don't know how to change it. All data type configurations SQuirreL has are at menu File -> 'Global Preferences' -> tab 'Data Type Controls' Sorry for the inconvenience Gerd |
|
From: Alexandre P. <Ale...@ei...> - 2018-07-24 21:42:16
|
You can’t allocate more memory that you physically have, or that can be addressed in the corresponding addressing model (i.e., no more than 4 GB in 32 bit JVM).
--
Alexandre Peshansky, MS
Lead Bioinformatics Analyst, Research Informatics Core (RIC)
Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore
Albert Einstein College of Medicine
1300 Morris Park Ave, Block Bldg., Rm 534 Bronx, NY 10461
(914) 294-6916 (office) (201) 970-3530 (cell)
[cid:image001.png@01D42360.1ED44F50]
From: Jonas BUNSEN [mailto:bu...@gr...]
Sent: Tuesday, July 24, 2018 10:04 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Allocate 20GB memory to SQuirreL
I am using SQuirreL 3.8.1 on Windows 10. If I open large tables I receive the following error.
“Error occurred during task execution: Java heap space”
Apparently, this has something to do with the memory that is allocated to my SQuirreL installation. Therefore, I changed `-Xmx256M` in the `squirrel-sql.bat` file to `-Xmx1024M`.
start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Xmx1024M -Dsun.awt.nopixfmt=true -Dsun.java2d.noddraw=true -cp %CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%
However, I still receive the same error and if I increase the allocated memory even more (e.g. `-Xmx26624M`) SquirreL will not start anymore.
> Error: Could not create the Java Virtual Machine.
> Error: A fatal exception has occured. Program will exit.
How can I allocate 26624 MB memory to my SQuirreL installation. I guess it has something to do with Java 32/64 bit!?
Thanks
|
|
From: Jonas B. <bu...@gr...> - 2018-07-24 18:49:39
|
I am using SQuirreL 3.8.1 on Windows 10. If I open large tables I receive the following error.
“Error occurred during task execution: Java heap space”
Apparently, this has something to do with the memory that is allocated to my SQuirreL installation. Therefore, I changed `-Xmx256M` in the `squirrel-sql.bat` file to `-Xmx1024M`.
start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Xmx1024M -Dsun.awt.nopixfmt=true -Dsun.java2d.noddraw=true -cp %CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%
However, I still receive the same error and if I increase the allocated memory even more (e.g. `-Xmx26624M`) SquirreL will not start anymore.
> Error: Could not create the Java Virtual Machine.
> Error: A fatal exception has occured. Program will exit.
How can I allocate 26624 MB memory to my SQuirreL installation. I guess it has something to do with Java 32/64 bit!?
Thanks
|
|
From: ADAN M. M. <kra...@ya...> - 2018-07-20 09:23:11
|
Hello I tried to run squirrel-sql.bat from squirrelsql-3.8.1-optional and i cannot, then i tried deleting -Xquickstart option from line start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Xmn256m -Xmx256m -XX:+AggressiveOpts -XX:MaxGCPauseMillis=10 -XX:MaxHeapFreeRatio=70 -Xss2m -Xverify:none -Xquickstart -Dsun.awt.nopixfmt=true -Dsun.java2d.noddraw=true -cp %SQUIRREL_CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS% And it works RegardsADAN M. M. |
|
From: Dharmin S. <ds...@pr...> - 2018-07-11 14:32:30
|
Hi, I was reading the documentation, and the Session Properties section (http://squirrel-sql.sourceforge.net/user-manual/quick_start.html#session_props ) shows a screen shot that has “Show String Data for Columns of these Data Types” under the SQL tab. However, I do not see that in the v3.8.1 for Mac. I have a column that is displaying VARBINARY, but all it shows me is the byte array, not the string version of it. Thank you. |
|
From: Alex M. <ale...@bl...> - 2018-06-18 13:57:17
|
First, I downloaded the IE11-Windows7 image from Microsoft and imported the appliance. Then I downloaded DB2 10.5 x86 from IBM and installed it in this VM. It worked fine. Also downloaded JDBC driver v.4 from IBM and the latest Squirrel, installed the driver and connected to the DB2 instance SAMPLE DB as db2admin user. All that was done under VirtualBox 5.0.8 run by Fedora 26 host. It does work, maybe the VM settings got mixed up in your case. MS sets the VM networking to NAT, and I had to switch it to bridged in my case. Other than that, no issues. -----Original Message----- From: Gerd Wagner <ger...@t-...> Sent: Thursday, June 14, 2018 3:32 PM To: Alex Malmyguine <Ale...@bl...>; squ...@li... Subject: Re: [Squirrel-sql-users] Db2 TABLE Alias And AutoComplete Am 11.06.2018 um 18:27 schrieb Alex Malmyguine: > Here: https://developer.microsoft.com/en-us/microsoft-edge/tools/vms/ > Keep in mind they auto-expire after like 90 days, read what MS suggests to work around that somewhere on those pages. This didn't work for me either. I could start the Virtual Box VM but neither DB2 nor even Firefox would install in the VM. Sorry for now. Perhaps somebody with some Java experience and access to a DB2 database could look after the problem. I'd appreciate a patch or merge request or simply changed code files mailed to me. Gerd > > Thank you! > Alex > > -----Original Message----- > From: Gerd Wagner <ger...@t-...> > Sent: Friday, June 08, 2018 5:05 PM > To: Alex Malmyguine <Ale...@bl...>; squ...@li... > Subject: Re: [Squirrel-sql-users] Db2 TABLE Alias And AutoComplete > > > Am 07.06.2018 um 23:19 schrieb Alex Malmyguine: >> The easiest way to get a running DB2 box is to use a free Microsoft VM in VirtualBox with the free IBM DB2 installation. >> Both are literally a one-click install. Takes about 30 min to set up all of that. >> The free DB2 from IBM needs a license file downloaded and imported. > Do you know a link to download such a VM? > > Gerd > >> >> Thank you >> Alex >> >> -----Original Message----- >> From: Gerd Wagner <ger...@t-...> >> Sent: Thursday, June 07, 2018 4:35 PM >> To: Matt F <de...@ya...>; squ...@li... >> Subject: Re: [Squirrel-sql-users] Db2 TABLE Alias And AutoComplete >> >> Sorry, I don't have access to a DB2 DB at the moment. >> >> I spend some time searching for a Docker image that would run on my >> openSuSE box but couldn't find one that was well enough described or >> accessible so that I could get it to work. >> >> If someone knows of such an image or can describe the necessary steps >> please let me know. >> >> Gerd >> >> >> Am 30.05.2018 um 18:54 schrieb Matt F via Squirrel-sql-users: >>> I've searched the mailing list and I didn't see anyone else have this >>> issue. I've never seen this work , so I'm not sure if this is a >>> config/user error issue or if it is indeed a feature Request. >>> >>> Setup: I have a DB2LUW database , I'm using Squirrel 3.8.1 (official) >>> with java 1.8.0_171 (32 Bit)/ Windows 7 x64 >>> >>> DB: QA (Also in prod, but for testing purposes let's use my QA Setup) >>> SCHEMA: FOO >>> TABLE: BAR_1 >>> TABLE: BAR_2 >>> ALIAS: BAR >>> >>> in order to keep a limited data set I drop and recreate the alias every >>> so often, so that BAR points to either BAR_1 or BAR_2 at any given time. >>> >>> When I use autocomplete I only get options for BAR_1 and BAR_2, not BAR. >>> >>> I'm using db2jcc4.jar (provided by IBM) with the class Name >>> com.ibm.db2.jcc.DB2Driver to connect >>> >>> Looking in Alias properties (the properties that define the connection >>> to QA) , i do not have "Cache Schema independent Meta Data" turned on, >>> but I don't think that would solve my issue >>> >>> Thanks >>> >>> ============================================== >>> Matt Ferreira >>> de...@ya... >>> >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >>> >>> >>> >>> _______________________________________________ >>> Squirrel-sql-users mailing list >>> Squ...@li... >>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> |
|
From: Gerd W. <ger...@t-...> - 2018-06-14 19:31:52
|
Am 11.06.2018 um 18:27 schrieb Alex Malmyguine: > Here: https://developer.microsoft.com/en-us/microsoft-edge/tools/vms/ > Keep in mind they auto-expire after like 90 days, read what MS suggests to work around that somewhere on those pages. This didn't work for me either. I could start the Virtual Box VM but neither DB2 nor even Firefox would install in the VM. Sorry for now. Perhaps somebody with some Java experience and access to a DB2 database could look after the problem. I'd appreciate a patch or merge request or simply changed code files mailed to me. Gerd > > Thank you! > Alex > > -----Original Message----- > From: Gerd Wagner <ger...@t-...> > Sent: Friday, June 08, 2018 5:05 PM > To: Alex Malmyguine <Ale...@bl...>; squ...@li... > Subject: Re: [Squirrel-sql-users] Db2 TABLE Alias And AutoComplete > > > Am 07.06.2018 um 23:19 schrieb Alex Malmyguine: >> The easiest way to get a running DB2 box is to use a free Microsoft VM in VirtualBox with the free IBM DB2 installation. >> Both are literally a one-click install. Takes about 30 min to set up all of that. >> The free DB2 from IBM needs a license file downloaded and imported. > Do you know a link to download such a VM? > > Gerd > >> >> Thank you >> Alex >> >> -----Original Message----- >> From: Gerd Wagner <ger...@t-...> >> Sent: Thursday, June 07, 2018 4:35 PM >> To: Matt F <de...@ya...>; squ...@li... >> Subject: Re: [Squirrel-sql-users] Db2 TABLE Alias And AutoComplete >> >> Sorry, I don't have access to a DB2 DB at the moment. >> >> I spend some time searching for a Docker image that would run on my >> openSuSE box but couldn't find one that was well enough described or >> accessible so that I could get it to work. >> >> If someone knows of such an image or can describe the necessary steps >> please let me know. >> >> Gerd >> >> >> Am 30.05.2018 um 18:54 schrieb Matt F via Squirrel-sql-users: >>> I've searched the mailing list and I didn't see anyone else have this >>> issue. I've never seen this work , so I'm not sure if this is a >>> config/user error issue or if it is indeed a feature Request. >>> >>> Setup: I have a DB2LUW database , I'm using Squirrel 3.8.1 (official) >>> with java 1.8.0_171 (32 Bit)/ Windows 7 x64 >>> >>> DB: QA (Also in prod, but for testing purposes let's use my QA Setup) >>> SCHEMA: FOO >>> TABLE: BAR_1 >>> TABLE: BAR_2 >>> ALIAS: BAR >>> >>> in order to keep a limited data set I drop and recreate the alias every >>> so often, so that BAR points to either BAR_1 or BAR_2 at any given time. >>> >>> When I use autocomplete I only get options for BAR_1 and BAR_2, not BAR. >>> >>> I'm using db2jcc4.jar (provided by IBM) with the class Name >>> com.ibm.db2.jcc.DB2Driver to connect >>> >>> Looking in Alias properties (the properties that define the connection >>> to QA) , i do not have "Cache Schema independent Meta Data" turned on, >>> but I don't think that would solve my issue >>> >>> Thanks >>> >>> ============================================== >>> Matt Ferreira >>> de...@ya... >>> >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >>> >>> >>> >>> _______________________________________________ >>> Squirrel-sql-users mailing list >>> Squ...@li... >>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> |
|
From: Alex M. <ale...@bl...> - 2018-06-11 16:43:27
|
Here: https://developer.microsoft.com/en-us/microsoft-edge/tools/vms/ Keep in mind they auto-expire after like 90 days, read what MS suggests to work around that somewhere on those pages. Thank you! Alex -----Original Message----- From: Gerd Wagner <ger...@t-...> Sent: Friday, June 08, 2018 5:05 PM To: Alex Malmyguine <Ale...@bl...>; squ...@li... Subject: Re: [Squirrel-sql-users] Db2 TABLE Alias And AutoComplete Am 07.06.2018 um 23:19 schrieb Alex Malmyguine: > The easiest way to get a running DB2 box is to use a free Microsoft VM in VirtualBox with the free IBM DB2 installation. > Both are literally a one-click install. Takes about 30 min to set up all of that. > The free DB2 from IBM needs a license file downloaded and imported. Do you know a link to download such a VM? Gerd > > Thank you > Alex > > -----Original Message----- > From: Gerd Wagner <ger...@t-...> > Sent: Thursday, June 07, 2018 4:35 PM > To: Matt F <de...@ya...>; squ...@li... > Subject: Re: [Squirrel-sql-users] Db2 TABLE Alias And AutoComplete > > Sorry, I don't have access to a DB2 DB at the moment. > > I spend some time searching for a Docker image that would run on my > openSuSE box but couldn't find one that was well enough described or > accessible so that I could get it to work. > > If someone knows of such an image or can describe the necessary steps > please let me know. > > Gerd > > > Am 30.05.2018 um 18:54 schrieb Matt F via Squirrel-sql-users: >> I've searched the mailing list and I didn't see anyone else have this >> issue. I've never seen this work , so I'm not sure if this is a >> config/user error issue or if it is indeed a feature Request. >> >> Setup: I have a DB2LUW database , I'm using Squirrel 3.8.1 (official) >> with java 1.8.0_171 (32 Bit)/ Windows 7 x64 >> >> DB: QA (Also in prod, but for testing purposes let's use my QA Setup) >> SCHEMA: FOO >> TABLE: BAR_1 >> TABLE: BAR_2 >> ALIAS: BAR >> >> in order to keep a limited data set I drop and recreate the alias every >> so often, so that BAR points to either BAR_1 or BAR_2 at any given time. >> >> When I use autocomplete I only get options for BAR_1 and BAR_2, not BAR. >> >> I'm using db2jcc4.jar (provided by IBM) with the class Name >> com.ibm.db2.jcc.DB2Driver to connect >> >> Looking in Alias properties (the properties that define the connection >> to QA) , i do not have "Cache Schema independent Meta Data" turned on, >> but I don't think that would solve my issue >> >> Thanks >> >> ============================================== >> Matt Ferreira >> de...@ya... >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> >> >> >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Gerd W. <ger...@t-...> - 2018-06-08 21:10:39
|
Am 07.06.2018 um 22:53 schrieb Matt F: > If it’s of any help I could set up a webex session, although I’m sure > you’d want your own workspace and IDE etc , which I can’t offer on my > machine :( Thanks for the offer. But let's wait a bit for ALex's answer. Or perhaps somebody comes up with another idea. If this doesn't work I'll come back to you. It would sure be easier for me to use my development environment to test. Gerd > > > Sent from Yahoo Mail for iPhone <https://overview.mail.yahoo.com/?.src=iOS> > > On Thursday, June 7, 2018, 4:34 PM, Gerd Wagner > <ger...@t-...> wrote: > > Sorry, I don't have access to a DB2 DB at the moment. > > I spend some time searching for a Docker image that would run on my > openSuSE box but couldn't find one that was well enough described or > accessible so that I could get it to work. > > If someone knows of such an image or can describe the necessary steps > please let me know. > > Gerd > > > Am 30.05.2018 um 18:54 schrieb Matt F via Squirrel-sql-users: > > I've searched the mailing list and I didn't see anyone else have > this > > issue. I've never seen this work , so I'm not sure if this is a > > config/user error issue or if it is indeed a feature Request. > > > > Setup: I have a DB2LUW database , I'm using Squirrel 3.8.1 > (official) > > with java 1.8.0_171 (32 Bit)/ Windows 7 x64 > > > > DB: QA (Also in prod, but for testing purposes let's use my QA Setup) > > SCHEMA: FOO > > TABLE: BAR_1 > > TABLE: BAR_2 > > ALIAS: BAR > > > > in order to keep a limited data set I drop and recreate the alias > every > > so often, so that BAR points to either BAR_1 or BAR_2 at any > given time. > > > > When I use autocomplete I only get options for BAR_1 and BAR_2, > not BAR. > > > > I'm using db2jcc4.jar (provided by IBM) with the class Name > > com.ibm.db2.jcc.DB2Driver to connect > > > > Looking in Alias properties (the properties that define the > connection > > to QA) , i do not have "Cache Schema independent Meta Data" > turned on, > > but I don't think that would solve my issue > > > > Thanks > > > > ============================================== > > Matt Ferreira > > de...@ya... <mailto:de...@ya...> > > > > > > > > ------------------------------------------------------------------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > > > > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squ...@li... > <mailto:Squ...@li...> > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > > |
|
From: Gerd W. <ger...@t-...> - 2018-06-08 21:04:44
|
Am 07.06.2018 um 23:19 schrieb Alex Malmyguine: > The easiest way to get a running DB2 box is to use a free Microsoft VM in VirtualBox with the free IBM DB2 installation. > Both are literally a one-click install. Takes about 30 min to set up all of that. > The free DB2 from IBM needs a license file downloaded and imported. Do you know a link to download such a VM? Gerd > > Thank you > Alex > > -----Original Message----- > From: Gerd Wagner <ger...@t-...> > Sent: Thursday, June 07, 2018 4:35 PM > To: Matt F <de...@ya...>; squ...@li... > Subject: Re: [Squirrel-sql-users] Db2 TABLE Alias And AutoComplete > > Sorry, I don't have access to a DB2 DB at the moment. > > I spend some time searching for a Docker image that would run on my > openSuSE box but couldn't find one that was well enough described or > accessible so that I could get it to work. > > If someone knows of such an image or can describe the necessary steps > please let me know. > > Gerd > > > Am 30.05.2018 um 18:54 schrieb Matt F via Squirrel-sql-users: >> I've searched the mailing list and I didn't see anyone else have this >> issue. I've never seen this work , so I'm not sure if this is a >> config/user error issue or if it is indeed a feature Request. >> >> Setup: I have a DB2LUW database , I'm using Squirrel 3.8.1 (official) >> with java 1.8.0_171 (32 Bit)/ Windows 7 x64 >> >> DB: QA (Also in prod, but for testing purposes let's use my QA Setup) >> SCHEMA: FOO >> TABLE: BAR_1 >> TABLE: BAR_2 >> ALIAS: BAR >> >> in order to keep a limited data set I drop and recreate the alias every >> so often, so that BAR points to either BAR_1 or BAR_2 at any given time. >> >> When I use autocomplete I only get options for BAR_1 and BAR_2, not BAR. >> >> I'm using db2jcc4.jar (provided by IBM) with the class Name >> com.ibm.db2.jcc.DB2Driver to connect >> >> Looking in Alias properties (the properties that define the connection >> to QA) , i do not have "Cache Schema independent Meta Data" turned on, >> but I don't think that would solve my issue >> >> Thanks >> >> ============================================== >> Matt Ferreira >> de...@ya... >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> >> >> >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Alex M. <ale...@bl...> - 2018-06-07 21:19:13
|
The easiest way to get a running DB2 box is to use a free Microsoft VM in VirtualBox with the free IBM DB2 installation. Both are literally a one-click install. Takes about 30 min to set up all of that. The free DB2 from IBM needs a license file downloaded and imported. Thank you Alex -----Original Message----- From: Gerd Wagner <ger...@t-...> Sent: Thursday, June 07, 2018 4:35 PM To: Matt F <de...@ya...>; squ...@li... Subject: Re: [Squirrel-sql-users] Db2 TABLE Alias And AutoComplete Sorry, I don't have access to a DB2 DB at the moment. I spend some time searching for a Docker image that would run on my openSuSE box but couldn't find one that was well enough described or accessible so that I could get it to work. If someone knows of such an image or can describe the necessary steps please let me know. Gerd Am 30.05.2018 um 18:54 schrieb Matt F via Squirrel-sql-users: > I've searched the mailing list and I didn't see anyone else have this > issue. I've never seen this work , so I'm not sure if this is a > config/user error issue or if it is indeed a feature Request. > > Setup: I have a DB2LUW database , I'm using Squirrel 3.8.1 (official) > with java 1.8.0_171 (32 Bit)/ Windows 7 x64 > > DB: QA (Also in prod, but for testing purposes let's use my QA Setup) > SCHEMA: FOO > TABLE: BAR_1 > TABLE: BAR_2 > ALIAS: BAR > > in order to keep a limited data set I drop and recreate the alias every > so often, so that BAR points to either BAR_1 or BAR_2 at any given time. > > When I use autocomplete I only get options for BAR_1 and BAR_2, not BAR. > > I'm using db2jcc4.jar (provided by IBM) with the class Name > com.ibm.db2.jcc.DB2Driver to connect > > Looking in Alias properties (the properties that define the connection > to QA) , i do not have "Cache Schema independent Meta Data" turned on, > but I don't think that would solve my issue > > Thanks > > ============================================== > Matt Ferreira > de...@ya... > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Matt F <de...@ya...> - 2018-06-07 20:53:57
|
If it’s of any help I could set up a webex session, although I’m sure you’d want your own workspace and IDE etc , which I can’t offer on my machine :( Sent from Yahoo Mail for iPhone On Thursday, June 7, 2018, 4:34 PM, Gerd Wagner <ger...@t-...> wrote: Sorry, I don't have access to a DB2 DB at the moment. I spend some time searching for a Docker image that would run on my openSuSE box but couldn't find one that was well enough described or accessible so that I could get it to work. If someone knows of such an image or can describe the necessary steps please let me know. Gerd Am 30.05.2018 um 18:54 schrieb Matt F via Squirrel-sql-users: > I've searched the mailing list and I didn't see anyone else have this > issue. I've never seen this work , so I'm not sure if this is a > config/user error issue or if it is indeed a feature Request. > > Setup: I have a DB2LUW database , I'm using Squirrel 3.8.1 (official) > with java 1.8.0_171 (32 Bit)/ Windows 7 x64 > > DB: QA (Also in prod, but for testing purposes let's use my QA Setup) > SCHEMA: FOO > TABLE: BAR_1 > TABLE: BAR_2 > ALIAS: BAR > > in order to keep a limited data set I drop and recreate the alias every > so often, so that BAR points to either BAR_1 or BAR_2 at any given time. > > When I use autocomplete I only get options for BAR_1 and BAR_2, not BAR. > > I'm using db2jcc4.jar (provided by IBM) with the class Name > com.ibm.db2.jcc.DB2Driver to connect > > Looking in Alias properties (the properties that define the connection > to QA) , i do not have "Cache Schema independent Meta Data" turned on, > but I don't think that would solve my issue > > Thanks > > ============================================== > Matt Ferreira > de...@ya... > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Gerd W. <ger...@t-...> - 2018-06-07 20:34:47
|
Sorry, I don't have access to a DB2 DB at the moment. I spend some time searching for a Docker image that would run on my openSuSE box but couldn't find one that was well enough described or accessible so that I could get it to work. If someone knows of such an image or can describe the necessary steps please let me know. Gerd Am 30.05.2018 um 18:54 schrieb Matt F via Squirrel-sql-users: > I've searched the mailing list and I didn't see anyone else have this > issue. I've never seen this work , so I'm not sure if this is a > config/user error issue or if it is indeed a feature Request. > > Setup: I have a DB2LUW database , I'm using Squirrel 3.8.1 (official) > with java 1.8.0_171 (32 Bit)/ Windows 7 x64 > > DB: QA (Also in prod, but for testing purposes let's use my QA Setup) > SCHEMA: FOO > TABLE: BAR_1 > TABLE: BAR_2 > ALIAS: BAR > > in order to keep a limited data set I drop and recreate the alias every > so often, so that BAR points to either BAR_1 or BAR_2 at any given time. > > When I use autocomplete I only get options for BAR_1 and BAR_2, not BAR. > > I'm using db2jcc4.jar (provided by IBM) with the class Name > com.ibm.db2.jcc.DB2Driver to connect > > Looking in Alias properties (the properties that define the connection > to QA) , i do not have "Cache Schema independent Meta Data" turned on, > but I don't think that would solve my issue > > Thanks > > ============================================== > Matt Ferreira > de...@ya... > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Matt F <de...@ya...> - 2018-05-30 16:54:50
|
I've searched the mailing list and I didn't see anyone else have this issue. I've never seen this work , so I'm not sure if this is a config/user error issue or if it is indeed a feature Request. Setup: I have a DB2LUW database , I'm using Squirrel 3.8.1 (official) with java 1.8.0_171 (32 Bit)/ Windows 7 x64 DB: QA (Also in prod, but for testing purposes let's use my QA Setup) SCHEMA: FOOTABLE: BAR_1TABLE: BAR_2ALIAS: BAR in order to keep a limited data set I drop and recreate the alias every so often, so that BAR points to either BAR_1 or BAR_2 at any given time. When I use autocomplete I only get options for BAR_1 and BAR_2, not BAR. I'm using db2jcc4.jar (provided by IBM) with the class Name com.ibm.db2.jcc.DB2Driver to connect Looking in Alias properties (the properties that define the connection to QA) , i do not have "Cache Schema independent Meta Data" turned on, but I don't think that would solve my issue Thanks ==============================================Matt Ferreira de...@ya... |
|
From: luca <luc...@gm...> - 2018-05-24 20:02:14
|
@Alex, I think this is not a nightmare, /for some specific databases/. For example, Oracle allows updating on a view via SQL command, just like on a table (under some restrictions I don't remember exactly). see e.g. https://stackoverflow.com/questions/1652995 Luca Il 24/05/2018 21:35, Alex Malmyguine ha scritto: > I'll be very surprised if this is at all possible. Definitely not something I'd expect from an SQL client. > Implementing that would require tracking of which column comes from which table. And then there is duplication of records... A nightmare for developers with very little to gain for users. > > > -----Original Message----- > From: Federico Bruni <fe...@in...> > Sent: Monday, May 21, 2018 12:38 PM > To: squ...@li... > Subject: [Squirrel-sql-users] cannot edit sql results of a JOIN statement > > Hi all > > I see that Squirrel SQL does not allow to edit the content of a JOIN > result. > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Alex M. <ale...@bl...> - 2018-05-24 19:51:11
|
I'll be very surprised if this is at all possible. Definitely not something I'd expect from an SQL client. Implementing that would require tracking of which column comes from which table. And then there is duplication of records... A nightmare for developers with very little to gain for users. -----Original Message----- From: Federico Bruni <fe...@in...> Sent: Monday, May 21, 2018 12:38 PM To: squ...@li... Subject: [Squirrel-sql-users] cannot edit sql results of a JOIN statement Hi all I see that Squirrel SQL does not allow to edit the content of a JOIN result. |
|
From: Federico B. <fe...@in...> - 2018-05-21 16:41:29
|
Hi all
I see that Squirrel SQL does not allow to edit the content of a JOIN
result.
Only simple queries.
There's any workaround?
Perhaps this limitation could be explicitly mentioned in the
documentation.
This is what I read in the help pages. (there's no online
documentation, right?)
Editing Data in the SQL Results Tables
The data displayed within the SQL Results may be edited in the same
manner as the data within the Contents Tab. You should read that
section to understand the capabilities and limitations of data editing,
including the use of the Popup window to import and export data. In
addition, there are two things that you need to know about editing in
the SQL Results:
To enable editing in the SQL Results tables, you must set the "SQL
Results" entry in the Session Properties to "Editable Table".
Editing is only allowed when the SQL that was executed consists of:
"SELECT <column list> FROM <single_table_name>"
or
"SELECT <column list> FROM <single_table_name> WHERE ..."
In addition, the name of the table must be unique within the entire DB.
This means that if you have multiple catalogs or schemas which have
that same table name defined in them, Squirrel cannot determine which
to use and thus will not allow data to be updated in the DB. (Squirrel
is just a bit stupid on this point: it will let you edit the data, and
then tell you that it cannot update the DB when you exit the cell being
changed.)
The Contents Tab and Editing Data
SQuirreL allows you to easily view and change the data in a single
table. Data may be changed just by typing the new values when you are
viewing the table in the Contents tab under the Objects view. The data
may also be viewed and edited in a larger popup window, which has more
capabilities, by double-clicking on the cell. There are some small
differences between the in-cell editing and editing in the Popup, so be
sure to read the Using the Popup Window information.
|
|
From: Luca V. <luc...@gm...> - 2018-05-04 06:59:17
|
Thank you both. @Federico, grazie, that's a good suggestion and I will keep it in mind when I'll migrate. As I told, this is my first installation so at the moment I have no SQLDrivers.xml to copy. @Alex, I currently work on projects with 5 different DB's, and I sometimes need connections to 5 more. Il 03/05/2018 18:17, Federico Bruni ha scritto: > Ciao Luca > > I've not tested it, but perhaps you can simply copy the file > ~/.squirrel-sql/SQLDrivers.xml from your working installation to a new > installation. > For example, in that file I found the driver I manually installed: > > > <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> > <driverClassName>com.ibm.db2.jcc.DB2Driver</driverClassName> > <identifier > Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> > <string>-ac8177c:159219c8c71:-7f81</string> > </identifier> > <jarFileName/> > <jarFileNames Indexed="true"> > <Bean > Class="net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper"> > <string>/home/fede/Documenti/query/jdbc-driver/db2jcc.jar</string> > </Bean> > <Bean > Class="net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper"> > <string>/home/fede/Documenti/query/jdbc-driver/db2jcc_license_cu.jar</string> > </Bean> > </jarFileNames> > <name>DB2 Driver</name> > <url>jdbc:db2://10.0.20.1:50000/DB_020</url> > <websiteUrl/> > </Bean> > > > > Il giorno gio 3 mag 2018 alle 9:33, Luca Vercelli > <"luca.vercelli.to"@gmail.com> ha scritto: >> Maybe, there is some function in the program that allows importing >> all drivers for some given folder? >> >> >> >> Il 02/05/2018 09:27, Luca Vercelli ha scritto: >>> Hello everybody, >>> >>> this is the first time I try to use SQuirreL SQL Client. >>> >>> My first issue is: what is the intended way to download and install >>> all JDBC drivers? Do I really need to download them manually one by >>> one? >>> >>> The suggested link >>> http://industry.java.sun.com/products/jdbc/drivers does not work. >>> >>> If so, this is really a great limitation, as compared to other free >>> products as DbVisualizer. >>> >>> I imagine it shouldn't be difficult to develop a plugin that >>> downloads the drivers. >>> >>> >>> Thank you >>> >>> Luca >>> >>> >>> >> >> >> ------------------------------------------------------------------------------ >> >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
