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

Re: [Squirrel-sql-users] Bad SQL results ??? Explanation

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

Please try to use UNION ALL instead of UNION.

Gerd


Am 10.10.19 um 20:19 schrieb Jack Brosch via Squirrel-sql-users:
> SQL command is  (ONLY difference is the % in front of RPT on 2^nd select :
> 
> SELECT * FROM "VISION"."PUB"."PM_Program"
> 
> WHERE  "PM_Program"."ProgCode" like 'RPT%' and "PM_Program"."ProgCode" 
> like '%Label%'
> 
> UNION
> 
> SELECT * FROM "VISION"."PUB"."PM_Program"
> 
> WHERE  "PM_Program"."ProgCode" like '*/_%_/*RPT%' and 
> "PM_Program"."ProgCode" like '%Label%'
> 
> Results are 1 record??
> 
> 	
> 
> 	
> 
> *Jack Brosch*
> IT Report Developer
> Jac...@es...
> T:
> M:704-622-6995
> 
> www.essentra.com
> 
> 	
> 
> 	
> 
> *Essentra*
> 
> ,
> United States of America
> 
> This e-mail may contain proprietary information and/or copyright 
> material. This e-mail is intended for the use of the addressee only. Any 
> unauthorised use may be unlawful.
> If you are not the intended recipient, you must not copy, distribute or 
> take any action in reliance on it. If you have received this email in 
> error, please delete it and notify us immediately by return email.
> 
> Be aware that Essentra may monitor incoming and outgoing e-mails to 
> ensure compliance with the Essentra IT Usage policy.
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] Bad SQL results ??? Explanation

[Jack B. <Jac...@es...>]

SQL command is  (ONLY difference is the % in front of RPT on 2nd select :

SELECT * FROM "VISION"."PUB"."PM_Program"
WHERE  "PM_Program"."ProgCode" like 'RPT%' and "PM_Program"."ProgCode" like '%Label%'
UNION
SELECT * FROM "VISION"."PUB"."PM_Program"
WHERE  "PM_Program"."ProgCode" like '%RPT%' and "PM_Program"."ProgCode" like '%Label%'

Results are 1 record??

[cid:image001.png@01D57F75.AA616B30]
            
  
 Jack Brosch
IT Report Developer
Jac...@es...
T: 
M:704-622-6995

www.essentra.com
       
 Essentra

,  
United States of America
 
 
This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.
Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra IT Usage policy.

Re: [Squirrel-sql-users] Error on export

[Christopher D. (Chris) <Chr...@mp...>]

Ps I am running 3.8.1

From: Christopher Dick (Chris)
Sent: Tuesday, 1 October 2019 10:46 a.m.
To: 'Gerd Wagner' <ger...@t-...>; 'squ...@li...' <squ...@li...>
Subject: Error on export

Hi,

All of a sudden getting the below error when using export csv/ MS excel/ XML…option:

[cid:image001.png@01D57845.FD50B8A0]

Has anyone come across this issue before?

Regards,
Chris
Christopher Dick | Senior Data Analyst
Fisheries Science and Information | Fisheries New Zealand
Ministry for Primary Industries - Manatū Ahu Matua | Charles Fergusson Tower 34-38 Bowen Street | PO Box 2526 | Wellington 6011 | New Zealand
Telephone: 64-4-894 3490 | Facsimile: 64-4-894 0228 | Mobile: 027-383 8935 | Web: www.mpi.govt.nz<http://www.mpi.govt.nz>
Follow MPI
[Twitter icon]<https://twitter.com/MPI_NZ>[cid:image003.png@01D57845.FD50B8A0]<http://www.facebook.com/MPIgovtnz>[LI icon]<https://www.linkedin.com/company/new-zealand-ministry-for-primary-industries>[YouTube icon]<https://www.youtube.com/user/MinPrimaryIndustries>



_____________________________________________________________________________________

This email message and any attachment(s) is intended solely for the addressee(s)
named above. The information it contains may be classified and may be legally
privileged. Unauthorised use of the message, or the information it contains,
may be unlawful. If you have received this message by mistake please call the
sender immediately on 64 4 8940100 or notify us by return email and erase the
original message and attachments. Thank you. 

The Ministry for Primary Industries accepts no responsibility for changes
made to this email or to any attachments after transmission from the office.

_____________________________________________________________________________________

Re: [Squirrel-sql-users] Error on export

[Christopher D. (Chris) <Chr...@mp...>]

Disregard I have solved this issue now!

From: Christopher Dick (Chris) [mailto:Chr...@mp...]
Sent: Tuesday, 1 October 2019 10:46 a.m.
To: Gerd Wagner <ger...@t-...>; squ...@li...
Subject: [Squirrel-sql-users] Error on export

Hi,

All of a sudden getting the below error when using export csv/ MS excel/ XML…option:

[cid:image001.png@01D57847.C45D5600]

Has anyone come across this issue before?

Regards,
Chris
Christopher Dick | Senior Data Analyst
Fisheries Science and Information | Fisheries New Zealand
Ministry for Primary Industries - Manatū Ahu Matua | Charles Fergusson Tower 34-38 Bowen Street | PO Box 2526 | Wellington 6011 | New Zealand
Telephone: 64-4-894 3490 | Facsimile: 64-4-894 0228 | Mobile: 027-383 8935 | Web: www.mpi.govt.nz<http://www.mpi.govt.nz>
Follow MPI
[Twitter icon]<https://twitter.com/MPI_NZ>[cid:image003.png@01D57847.C45D5600]<http://www.facebook.com/MPIgovtnz>[LI icon]<https://www.linkedin.com/company/new-zealand-ministry-for-primary-industries>[YouTube icon]<https://www.youtube.com/user/MinPrimaryIndustries>



__________________________________________________________________________________________________________________

This email message and any attachment(s) is intended solely for the addressee(s)
named above. The information it contains may be classified and may be legally
privileged. Unauthorised use of the message, or the information it contains,
may be unlawful. If you have received this message by mistake please call the
sender immediately on 64 4 8940100 or notify us by return email and erase the
original message and attachments. Thank you.

The Ministry for Primary Industries accepts no responsibility for changes
made to this email or to any attachments after transmission from the office.

__________________________________________________________________________________________________________________

_____________________________________________________________________________________

This email message and any attachment(s) is intended solely for the addressee(s)
named above. The information it contains may be classified and may be legally
privileged. Unauthorised use of the message, or the information it contains,
may be unlawful. If you have received this message by mistake please call the
sender immediately on 64 4 8940100 or notify us by return email and erase the
original message and attachments. Thank you. 

The Ministry for Primary Industries accepts no responsibility for changes
made to this email or to any attachments after transmission from the office.

_____________________________________________________________________________________

[Squirrel-sql-users] Error on export

[Christopher D. (Chris) <Chr...@mp...>]

Hi,

All of a sudden getting the below error when using export csv/ MS excel/ XML…option:

[cid:image001.png@01D57845.724AA9F0]

Has anyone come across this issue before?

Regards,
Chris
Christopher Dick | Senior Data Analyst
Fisheries Science and Information | Fisheries New Zealand
Ministry for Primary Industries - Manatū Ahu Matua | Charles Fergusson Tower 34-38 Bowen Street | PO Box 2526 | Wellington 6011 | New Zealand
Telephone: 64-4-894 3490 | Facsimile: 64-4-894 0228 | Mobile: 027-383 8935 | Web: www.mpi.govt.nz
Follow MPI
[Twitter icon]<https://twitter.com/MPI_NZ>[cid:image003.png@01D57845.724AA9F0]<http://www.facebook.com/MPIgovtnz>[LI icon]<https://www.linkedin.com/company/new-zealand-ministry-for-primary-industries>[YouTube icon]<https://www.youtube.com/user/MinPrimaryIndustries>



_____________________________________________________________________________________

This email message and any attachment(s) is intended solely for the addressee(s)
named above. The information it contains may be classified and may be legally
privileged. Unauthorised use of the message, or the information it contains,
may be unlawful. If you have received this message by mistake please call the
sender immediately on 64 4 8940100 or notify us by return email and erase the
original message and attachments. Thank you. 

The Ministry for Primary Industries accepts no responsibility for changes
made to this email or to any attachments after transmission from the office.

_____________________________________________________________________________________

Re: [Squirrel-sql-users] [EXTERNAL] SquirrelSQL won't launch

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

I usually modify the squirrel-sql.bat file and point it to the Java.  (In this example snippet Java 8u181 32bit.)

@echo off

@rem IZPACK_JAVA is filtered in by the IzPack installer when this script is installed
set We detect the java executable to use according to the following algorithm:
@rem
@rem 1. If the one used by the IzPack installer is available then use that; otherwise
@rem 2. Use the java that is in the command path.
@rem

if exist "C:\Program Files (x86)\Java\jre1.8.0_181\bin\javaw.exe" (
  set "LOCAL_JAVA=C:\Program Files (x86)\Java\jre1.8.0_181\bin\javaw.exe"
) else (
  set LOCAL_JAVA=javaw.exe
)

echo Using java: %LOCAL_JAVA%



From: Michael via Squirrel-sql-users [mailto:squ...@li...]
Sent: Thursday, August 8, 2019 7:08 PM
To: squ...@li...
Subject: Re: [Squirrel-sql-users] [EXTERNAL] SquirrelSQL won't launch

Caution: This email originated outside of the Physicians Mutual organization. Do not click on links or open attachments unless you recognize the sender and know the content is safe. If the email appears suspicious, please contact the ETG Help Desk.


I had a similar problem on some linux distros I use, but don't have the problem anymore.? I am using version 3.9.1 on gentoo and have used it on debian 10 and void.? The java is 1.8.0_212.? Mike
On 8/8/19 3:27 PM, Ferreira, Matthew wrote:
Which version of squirrel is this? There was an issue about a year ago where squirrel-sql.bat needed to be updated to enumerate the newer sql versions.?

I?m using 3.9.0 on win 7 with the same Java version without issue.

This is being sent from my mobile. Please excuse typos and brevity

From: Jim Mulgrew <jim...@gm...<mailto:jim...@gm...>>
Date: Thursday, Aug 08, 2019, 6:16 PM
To: squ...@li...<mailto:squ...@li...> <squ...@li...<mailto:squ...@li...>>
Subject: [EXTERNAL] [Squirrel-sql-users] SquirrelSQL won't launch

First of all, my apologies if this was the wrong way to post a question to the group/support. I'm new to this as of today.?

I'm a Citrix Admin at our company and the business has asked us to install SquirellSQL onto our servers so the offshore teams would have access to use it. We have it installed but when we try to launch it we get a pop up window stating that "the JVM must be at least 1.6 to run Squirrel 3.x and above". The version we have installed on the server is 1.8.0_202 which is a bit confusing. (attached). What are we doing wrong? Thanks.

- Jim
**NOTICE: This e-mail message, including any attachments hereto, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. If you are not the intended recipient(s), any unauthorized review, use, copying, disclosure or distribution is prohibited. If you are not the intended recipient(s), please contact the sender by reply e-mail immediately and destroy the original and all copies (including electronic versions) of this message and any of its attachments.




_______________________________________________

Squirrel-sql-users mailing list

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

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


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

Re: [Squirrel-sql-users] [EXTERNAL] SquirrelSQL won't launch

[Michael <mjc...@ao...>]

I had a similar problem on some linux distros I use, but don't have the 
problem anymore.? I am using version 3.9.1 on gentoo and have used it on 
debian 10 and void.? The java is 1.8.0_212.? Mike

On 8/8/19 3:27 PM, Ferreira, Matthew wrote:
> Which version of squirrel is this? There was an issue about a year ago 
> where squirrel-sql.bat needed to be updated to enumerate the newer sql 
> versions.
>
> I?m using 3.9.0 on win 7 with the same Java version without issue.
>
>
> This is being sent from my mobile. Please excuse typos and brevity
>
>
> *From: *Jim Mulgrew <jim...@gm... <mailto:jim...@gm...>>
> *Date: *Thursday, Aug 08, 2019, 6:16 PM
> *To: *squ...@li... 
> <squ...@li... 
> <mailto:squ...@li...>>
> *Subject: *[EXTERNAL] [Squirrel-sql-users] SquirrelSQL won't launch
>
> First of all, my apologies if this was the wrong way to post a 
> question to the group/support. I'm new to this as of today.
>
> I'm a Citrix Admin at our company and the business has asked us to 
> install SquirellSQL onto our servers so the offshore teams would have 
> access to use it. We have it installed but when we try to launch it we 
> get a pop up window stating that "the JVM must be at least 1.6 to run 
> Squirrel 3.x and above". The version we have installed on the server 
> is 1.8.0_202 which is a bit confusing. (attached). What are we doing 
> wrong? Thanks.
>
> - Jim
> **NOTICE: This e-mail message, including any attachments hereto, is 
> for the sole use of the intended recipient(s) and may contain 
> confidential and/or privileged information. If you are not the 
> intended recipient(s), any unauthorized review, use, copying, 
> disclosure or distribution is prohibited. If you are not the intended 
> recipient(s), please contact the sender by reply e-mail immediately 
> and destroy the original and all copies (including electronic 
> versions) of this message and any of its attachments.
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] [EXTERNAL] SquirrelSQL won't launch

[Ferreira, M. <Mat...@wo...>]

Which version of squirrel is this? There was an issue about a year ago where squirrel-sql.bat needed to be updated to enumerate the newer sql versions.

I’m using 3.9.0 on win 7 with the same Java version without issue.


This is being sent from my mobile. Please excuse typos and brevity


From: Jim Mulgrew <jim...@gm...<mailto:jim...@gm...>>
Date: Thursday, Aug 08, 2019, 6:16 PM
To: squ...@li... <squ...@li...<mailto:squ...@li...>>
Subject: [EXTERNAL] [Squirrel-sql-users] SquirrelSQL won't launch

First of all, my apologies if this was the wrong way to post a question to the group/support. I'm new to this as of today.

I'm a Citrix Admin at our company and the business has asked us to install SquirellSQL onto our servers so the offshore teams would have access to use it. We have it installed but when we try to launch it we get a pop up window stating that "the JVM must be at least 1.6 to run Squirrel 3.x and above". The version we have installed on the server is 1.8.0_202 which is a bit confusing. (attached). What are we doing wrong? Thanks.

- Jim

**NOTICE: This e-mail message, including any attachments hereto, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. If you are not the intended recipient(s), any unauthorized review, use, copying, disclosure or distribution is prohibited. If you are not the intended recipient(s), please contact the sender by reply e-mail immediately and destroy the original and all copies (including electronic versions) of this message and any of its attachments.

[Squirrel-sql-users] SquirrelSQL won't launch

[Jim M. <jim...@gm...>]

First of all, my apologies if this was the wrong way to post a question to
the group/support. I'm new to this as of today.

I'm a Citrix Admin at our company and the business has asked us to install
SquirellSQL onto our servers so the offshore teams would have access to use
it. We have it installed but when we try to launch it we get a pop up
window stating that "the JVM must be at least 1.6 to run Squirrel 3.x and
above". The version we have installed on the server is 1.8.0_202 which is a
bit confusing. (attached). What are we doing wrong? Thanks.

- Jim

Re: [Squirrel-sql-users] MS SQL select from a function with an option (recompile) hint

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

Sorry I can't reproduce your problem.
If  you send an example script I'll give it another try.

Anyway I' don't believe I could do much about it. It sounds pretty much 
like RDBMS / JDBC driver specific problem.

Gerd


Am 23.05.19 um 17:31 schrieb Alex Malmyguine:
> If I run a select statement against a table valued function and include OPTION(RECOMPILE) and leave "Limit rows" checked off, the query fails with the following error:
> 
> Error: Invalid state, the Connection object is closed.
> SQLState:  HY010
> ErrorCode: 0
> 
> It runs fine w/o row limiting.
> The select statements which do not query from a function work fine with the option with or w/o row limiting.
> 
> Thanks,
> Alex
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] MS SQL select from a function with an option (recompile) hint

[Alex M. <ale...@bl...>]

If I run a select statement against a table valued function and include OPTION(RECOMPILE) and leave "Limit rows" checked off, the query fails with the following error:

Error: Invalid state, the Connection object is closed.
SQLState:  HY010
ErrorCode: 0

It runs fine w/o row limiting.
The select statements which do not query from a function work fine with the option with or w/o row limiting.

Thanks,
Alex

Re: [Squirrel-sql-users] port out of range - SquirreL 3.8.1

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

I guess the message comes out of class
java.net.InetSocketAddress

You can check that by looking at SQuirreL's logs.

If I'm right the problem is in Java's network layer and cannot be fixed 
in SQuirreL.

Gerd

Am 23.04.19 um 22:34 schrieb EDUARDO LUGO via Squirrel-sql-users:
> Hello guys,
> 
> could you please advice on how can I increase the range for the port 
> numbers ?
> 
> I am getting the following error when connecting through TCP/IP using 
> port = 88888, there is not option to change it because many servers 
> point to it since many years ago. So the only problem is with SQuirreL.
> 
> Unexpected Error occurred attempting to open an SQL connection.
> class java.lang.IllegalArgumentException: port out of range:88888
> 
> Regards
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] trouble with plugins on macOS

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

Please try out the installer of the 3.9.1 version:

https://sourceforge.net/projects/squirrel-sql/files/1-stable/3.9.1/squirrel-sql-3.9.1-MACOSX-install.jar/download

The Data Import Plugin was made a standard Plugin in this version.

Gerd

Am 14.04.19 um 23:24 schrieb Jason Li:
> Hello, (hope I'm using this list thing correctly... let me know if I'm not)
> 
> I have SquirrelSQL 3.9.0 installed on macOS and I'm having an issue with 
> plugins.
> 
> I'm trying to install the Data Import plugin, and found through the 
> install jar the "packs" folder with what looks like plugin files but I 
> don't know what to do with them. MacOS claims they are Unix Executables 
> but then says it cannot be executed. I thought they would be jar files 
> that can be placed in the app plugins folder.
> 
> Anyone able to help? What exactly do I need to do to install the plugin?
> 
> Thanks,
> -Jason
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] port out of range - SquirreL 3.8.1

[John H. <jh...@im...>]

On Tue, 23 Apr 2019, EDUARDO LUGO via Squirrel-sql-users wrote:

> could you please advice on how can I increase the range for the port 
> numbers ?
>
> I am getting the following error when connecting through TCP/IP using 
> port = 88888, there is not option to change it because many servers 
> point to it since many years ago. So the only problem is with SQuirreL.

That's not going to happen because TCP port numbers are (and always have 
been) UINT16, and the maximum possible value is 65535.

Are you sure it's not listening on port 8888?

>
> Unexpected Error occurred attempting to open an SQL connection.
> class java.lang.IllegalArgumentException: port out of range:88888
>
> Regards
>

-- 
  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
-----------------------------------------------------------------------
   *Your* lack of self-control does not give you
   the authority to dictate limitations on *my* freedom.
-----------------------------------------------------------------------
  755 days since the first commercial re-flight of an orbital booster (SpaceX)

[Squirrel-sql-users] port out of range - SquirreL 3.8.1

[EDUARDO L. <lum...@ya...>]

Hello guys,
could you please advice on how can I increase the range for the port numbers ?
I am getting the following error when connecting through TCP/IP using port = 88888, there is not option to change it because many servers point to it since many years ago. So the only problem is with SQuirreL.

Unexpected Error occurred attempting to open an SQL connection.
class java.lang.IllegalArgumentException: port out of range:88888 

Regards

[Squirrel-sql-users] trouble with plugins on macOS

[Jason Li <jas...@gm...>]

Hello, (hope I'm using this list thing correctly... let me know if I'm not)

I have SquirrelSQL 3.9.0 installed on macOS and I'm having an issue with
plugins.

I'm trying to install the Data Import plugin, and found through the install
jar the "packs" folder with what looks like plugin files but I don't know
what to do with them. MacOS claims they are Unix Executables but then says
it cannot be executed. I thought they would be jar files that can be placed
in the app plugins folder.

Anyone able to help? What exactly do I need to do to install the plugin?

Thanks,
-Jason

Re: [Squirrel-sql-users] adjusting memory in .bat file

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

Sorry, I can't reproduce your problem.

My first guess is you are using a 32 bit JRE/JDK.

Gerd

Am 13.03.19 um 22:00 schrieb Christopher Dick (Chris):
> Hi,
> 
> I have an issue where users are unable to adjust to .bat file for memory 
> over 1gb without the program collapsing ie cannot set this parameter 
> -Xmx1024m to 2, 4 or 8gb.
> 
> We deal with large and growing datasets i.e. over 1 million rows for a 
> lot of tables and it is annoying to split up the query into parts then 
> concatenate the result if we do not do this then we get the below error msg:
> 
> Is this a known issue that can be resolved, we connect to a Postgres 
> database and hence driver to run the queries and currently running 
> version 3.8.1.
> 
> Please let me know if you require any further information to progress 
> things.
> 
> Cheers,
> 
> Chris
> 
> *Christopher Dick* | Senior Data Analyst
> Fisheries Science and Information | Fisheries New Zealand
> Ministry for Primary Industries - Manatū Ahu Matua | Charles Fergusson 
> Tower 34-38 Bowen Street | PO Box 2526 | Wellington 6011 | New Zealand
> Telephone: 64-4-894 3490 | Facsimile: 64-4-894 0228 | Mobile: 
> 027-383 8935 | Web: www.mpi.govt.nz
> 
> Follow MPI
> Twitter icon 
> <https://twitter.com/MPI_NZ><http://www.facebook.com/MPIgovtnz>LI icon 
> <https://www.linkedin.com/company/new-zealand-ministry-for-primary-industries>YouTube 
> icon <https://www.youtube.com/user/MinPrimaryIndustries>
> 
> __________________________________________________________________________________________________________________
> 
> This email message and any attachment(s) is intended solely for the 
> addressee(s)
> named above. The information it contains may be classified and may be 
> legally
> privileged. Unauthorised use of the message, or the information it contains,
> may be unlawful. If you have received this message by mistake please 
> call the
> sender immediately on 64 4 8940100 or notify us by return email and 
> erase the
> original message and attachments. Thank you.
> 
> The Ministry for Primary Industries accepts no responsibility for changes
> made to this email or to any attachments after transmission from the office.
> 
> __________________________________________________________________________________________________________________
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] adjusting memory in .bat file

[Alex M. <ale...@bl...>]

Chris,

Is your JVM 64bit on a 64bit OS? Can you try some of the previous versions (of Squirrel), as I vaguely recall this working at some point in the past?

Regards,
Alex

From: Christopher Dick (Chris) <Chr...@mp...>
Sent: Wednesday, March 13, 2019 5:00 PM
To: 'squ...@li...' <squ...@li...>
Subject: [Squirrel-sql-users] adjusting memory in .bat file

Hi,

I have an issue where users are unable to adjust to .bat file for memory over 1gb without the program collapsing ie cannot set this parameter -Xmx1024m to 2, 4 or 8gb.

We deal with large and growing datasets i.e. over 1 million rows for a lot of tables and it is annoying to split up the query into parts then concatenate the result if we do not do this then we get the below error msg:

[cid:image005.png@01D4DA4B.E25AC970]

Is this a known issue that can be resolved, we connect to a Postgres database and hence driver to run the queries and currently running version 3.8.1.

Please let me know if you require any further information to progress things.

Cheers,
Chris
Christopher Dick | Senior Data Analyst
Fisheries Science and Information | Fisheries New Zealand
Ministry for Primary Industries - Manatū Ahu Matua | Charles Fergusson Tower 34-38 Bowen Street | PO Box 2526 | Wellington 6011 | New Zealand
Telephone: 64-4-894 3490 | Facsimile: 64-4-894 0228 | Mobile: 027-383 8935 | Web: www.mpi.govt.nz<http://www.mpi.govt.nz>
Follow MPI
[Twitter icon]<https://twitter.com/MPI_NZ>[cid:image007.png@01D4DA4B.E25AC970]<http://www.facebook.com/MPIgovtnz>[LI icon]<https://www.linkedin.com/company/new-zealand-ministry-for-primary-industries>[YouTube icon]<https://www.youtube.com/user/MinPrimaryIndustries>


__________________________________________________________________________________________________________________

This email message and any attachment(s) is intended solely for the addressee(s)
named above. The information it contains may be classified and may be legally
privileged. Unauthorised use of the message, or the information it contains,
may be unlawful. If you have received this message by mistake please call the
sender immediately on 64 4 8940100 or notify us by return email and erase the
original message and attachments. Thank you.

The Ministry for Primary Industries accepts no responsibility for changes
made to this email or to any attachments after transmission from the office.

__________________________________________________________________________________________________________________

[Squirrel-sql-users] adjusting memory in .bat file

[Christopher D. (Chris) <Chr...@mp...>]

Hi,

I have an issue where users are unable to adjust to .bat file for memory over 1gb without the program collapsing ie cannot set this parameter -Xmx1024m to 2, 4 or 8gb.

We deal with large and growing datasets i.e. over 1 million rows for a lot of tables and it is annoying to split up the query into parts then concatenate the result if we do not do this then we get the below error msg:

[cid:image005.png@01D4DA4C.B4361580]

Is this a known issue that can be resolved, we connect to a Postgres database and hence driver to run the queries and currently running version 3.8.1.

Please let me know if you require any further information to progress things.

Cheers,
Chris
Christopher Dick | Senior Data Analyst
Fisheries Science and Information | Fisheries New Zealand
Ministry for Primary Industries - Manatū Ahu Matua | Charles Fergusson Tower 34-38 Bowen Street | PO Box 2526 | Wellington 6011 | New Zealand
Telephone: 64-4-894 3490 | Facsimile: 64-4-894 0228 | Mobile: 027-383 8935 | Web: www.mpi.govt.nz
Follow MPI
[Twitter icon]<https://twitter.com/MPI_NZ>[cid:ima...@01...BE9300]<http://www.facebook.com/MPIgovtnz>[LI icon]<https://www.linkedin.com/company/new-zealand-ministry-for-primary-industries>[YouTube icon]<https://www.youtube.com/user/MinPrimaryIndustries>


_____________________________________________________________________________________

This email message and any attachment(s) is intended solely for the addressee(s)
named above. The information it contains may be classified and may be legally
privileged. Unauthorised use of the message, or the information it contains,
may be unlawful. If you have received this message by mistake please call the
sender immediately on 64 4 8940100 or notify us by return email and erase the
original message and attachments. Thank you. 

The Ministry for Primary Industries accepts no responsibility for changes
made to this email or to any attachments after transmission from the office.

_____________________________________________________________________________________

Re: [Squirrel-sql-users] When is "make editable" not available?

[John H. <jh...@im...>]

On Fri, 22 Feb 2019, Alex Malmyguine wrote:

> Going out on a limb, but could this have anything to do with TOP 100 default for the output row count?

The problematic table in question has 2 rows.

I have that limit changed to 1000 locally.

Other tables with more rows, where the TOP comes into play, can be made 
editable without problems.


ARGH. I just tried it again and now that same query CAN be changed to 
editable!

I *hate* POM bugs.



> Alex
>
> -----Original Message-----
> From: John Hardin <jh...@im...>
> Sent: Wednesday, February 20, 2019 7:31 PM
> To: Squirrel SQL users list <squ...@li...>
> Subject: [Squirrel-sql-users] When is "make editable" not available?
>
> Folks:
>
> I just ran a simple SELECT * FROM query on a simple MSSQL table, but the "Make Editable" option is not available.
>
> My session default is set to normal table, other similarly simple queries in the same database are editable, and I'm logging in as a system admin with all privileges.
>
> Can anyone explain (or point to documentation of) under what circumstances "Make Editable" is not available in the query results tab context menu?

-- 
  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
-----------------------------------------------------------------------
  Today: George Washington's 287th Birthday

Re: [Squirrel-sql-users] When is "make editable" not available?

[Alex M. <ale...@bl...>]

Going out on a limb, but could this have anything to do with TOP 100 default for the output row count?

Alex

-----Original Message-----
From: John Hardin <jh...@im...> 
Sent: Wednesday, February 20, 2019 7:31 PM
To: Squirrel SQL users list <squ...@li...>
Subject: [Squirrel-sql-users] When is "make editable" not available?

Folks:

I just ran a simple SELECT * FROM query on a simple MSSQL table, but the "Make Editable" option is not available.

My session default is set to normal table, other similarly simple queries in the same database are editable, and I'm logging in as a system admin with all privileges.

Can anyone explain (or point to documentation of) under what circumstances "Make Editable" is not available in the query results tab context menu?

Thanks!

-- 
  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
-----------------------------------------------------------------------
  2 days until George Washington's 287th Birthday


_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] When is "make editable" not available?

[John H. <jh...@im...>]

Folks:

I just ran a simple SELECT * FROM query on a simple MSSQL table, but the 
"Make Editable" option is not available.

My session default is set to normal table, other similarly simple queries 
in the same database are editable, and I'm logging in as a system admin 
with all privileges.

Can anyone explain (or point to documentation of) under what circumstances 
"Make Editable" is not available in the query results tab context menu?

Thanks!

-- 
  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
-----------------------------------------------------------------------
  2 days until George Washington's 287th Birthday

Re: [Squirrel-sql-users] configuration using JT400 driver to AS400

[Alex M. <ale...@bl...>]

I do not recall having any problems with Squirrel when working with iSeries.
Should you not fully qualify the tables using a period? I.e. IESPROOF.custmast?
Also, it could help if you set the default schema in the Squirrel alias to the library your table belongs to, but I am not 100% sure of this.

Thanks
Alex

From: John Tremper <Joh...@na...>
Sent: Wednesday, February 13, 2019 10:22 AM
To: squ...@li...
Subject: [Squirrel-sql-users] configuration using JT400 driver to AS400

Hello,

I have used squirrel in the past and am trying to get it configured correctly at a new job.  I am attempting to connect to an AS400(iSeries, series I, etc).  I downloaded the JT400 jar and placed it in the same directory squirrel is installed.  I created the alias and connected successfully when I hit the test button.  On the schemas tab, I have the 'Specify Schema Loading and Caching' radio button selected.  I have all schema, tables, views, procedures, and UDTs set to 'Don't Load'.  On the 'Driver Properties' tab everything is greyed out (???).  When I try to run a simple query like:  select * from custmast I get the following error:
Error: [SQL0204] CUSTMAST in TREJ type *FILE not found.
SQLState:  42704
ErrorCode: -204
TREJ is my user id.
If I fully qualify the sql statement:  select * from IESPROOF/custmast, I get the following error:
Error: [SQL5016] Qualified object name CUSTMAST not valid.
SQLState:  42833
ErrorCode: -5016

I am hoping this is just a simple configuration issue.  Any help is appreciated.  I really like squirrel and would be lost without it.

Thanks,

John Tremper
joh...@na...<mailto:joh...@na...>
816.713.8716

Re: [Squirrel-sql-users] configuration using JT400 driver to AS400

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

Try  library.table not library/table. SQL notation not CL. 

Roger 

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

On 2019-02-13 15:21, John Tremper wrote:

> Hello, 
> 
> I have used squirrel in the past and am trying to get it configured correctly at a new job.  I am attempting to connect to an AS400(iSeries, series I, etc).  I downloaded the JT400 jar and placed it in the same directory squirrel is installed.  I created the alias and connected successfully when I hit the test button.  On the schemas tab, I have the 'Specify Schema Loading and Caching' radio button selected.  I have all schema, tables, views, procedures, and UDTs set to 'Don't Load'.  On the 'Driver Properties' tab everything is greyed out (???).  When I try to run a simple query like:  select * from custmast I get the following error: 
> 
> Error: [SQL0204] CUSTMAST in TREJ type *FILE not found. 
> 
> SQLState:  42704 
> 
> ErrorCode: -204 
> 
> TREJ is my user id.  
> 
> If I fully qualify the sql statement:  select * from IESPROOF/custmast, I get the following error: 
> 
> Error: [SQL5016] Qualified object name CUSTMAST not valid. 
> 
> SQLState:  42833 
> 
> ErrorCode: -5016 
> 
> I am hoping this is just a simple configuration issue.  Any help is appreciated.  I really like squirrel and would be lost without it. 
> 
> Thanks, 
> 
> John Tremper 
> 
> joh...@na... 
> 
> 816.713.8716 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] configuration using JT400 driver to AS400

[John T. <Joh...@na...>]

Hello,

I have used squirrel in the past and am trying to get it configured correctly at a new job.  I am attempting to connect to an AS400(iSeries, series I, etc).  I downloaded the JT400 jar and placed it in the same directory squirrel is installed.  I created the alias and connected successfully when I hit the test button.  On the schemas tab, I have the 'Specify Schema Loading and Caching' radio button selected.  I have all schema, tables, views, procedures, and UDTs set to 'Don't Load'.  On the 'Driver Properties' tab everything is greyed out (???).  When I try to run a simple query like:  select * from custmast I get the following error:
Error: [SQL0204] CUSTMAST in TREJ type *FILE not found.
SQLState:  42704
ErrorCode: -204
TREJ is my user id.
If I fully qualify the sql statement:  select * from IESPROOF/custmast, I get the following error:
Error: [SQL5016] Qualified object name CUSTMAST not valid.
SQLState:  42833
ErrorCode: -5016

I am hoping this is just a simple configuration issue.  Any help is appreciated.  I really like squirrel and would be lost without it.

Thanks,

John Tremper
joh...@na...
816.713.8716