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

Re: [Squirrel-sql-users] sqlparam plugin asks for /* */ commented variables

[Federico B. <fe...@in...>]

Yes, it works as expected now.
Thanks for the quick fix!

Il giorno gio 22 dic 2016 alle 0:32, Gerd Wagner 
<ger...@t-...> ha scritto:
> Federico,
> 
> this bug is fixed. The fix is available here:
> 
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161222_0014
> 
> Please give it a try.
> 
> Thanks
> Gerd
> 
> Am 21.12.2016 um 15:14 schrieb Federico Bruni:
>> Hi all
>> 
>> I thought that I was still affected by a bug fixed in 2014:
>> https://sourceforge.net/p/squirrel-sql/bugs/618/
>> 
>> Example:
>> 
>> SELECT * FROM CARS
>> WHERE NAME LIKE 'TOY%' /*IN (:var1, :var2, :var3) */ ;
>> 
>> Instead of just executing the LIKE 'TOY%' statement, I'm prompted for
>> the variables which are in a commented block and should be therefore
>> ignored.
>> 
>> I've looked at commit e785904a6563f90d34bc1fc570fe472259c9903a in git
>> and found out that if I use '--' for commenting then sqlparam won't
>> prompt for variables:
>> 
>> SELECT * FROM CARS
>> WHERE NAME LIKE 'TOY%'; -- IN (:var1, :var2, :var3);
>> 
>> I don't know what's the recommended way to do this sort of things in
>> SQL, but I wanted to share this with you.
>> 
>> Thanks
>> Federico
>> 
>> 
>> 
>> 
>> 
>> 
>> ------------------------------------------------------------------------------
>> Developer Access Program for Intel Xeon Phi Processors
>> Access to Intel Xeon Phi processor-based developer platforms.
>> With one year of Intel Parallel Studio XE.
>> Training and support from Colfax.
>> Order your platform today.http://sdm.link/intel
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>> 

Re: [Squirrel-sql-users] sqlparam plugin asks for /* */ commented variables

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

Federico,

this bug is fixed. The fix is available here:

https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161222_0014

Please give it a try.

Thanks
Gerd

Am 21.12.2016 um 15:14 schrieb Federico Bruni:
> Hi all
>
> I thought that I was still affected by a bug fixed in 2014:
> https://sourceforge.net/p/squirrel-sql/bugs/618/
>
> Example:
>
> SELECT * FROM CARS
> WHERE NAME LIKE 'TOY%' /*IN (:var1, :var2, :var3) */ ;
>
> Instead of just executing the LIKE 'TOY%' statement, I'm prompted for
> the variables which are in a commented block and should be therefore
> ignored.
>
> I've looked at commit e785904a6563f90d34bc1fc570fe472259c9903a in git
> and found out that if I use '--' for commenting then sqlparam won't
> prompt for variables:
>
> SELECT * FROM CARS
> WHERE NAME LIKE 'TOY%'; -- IN (:var1, :var2, :var3);
>
> I don't know what's the recommended way to do this sort of things in
> SQL, but I wanted to share this with you.
>
> Thanks
> Federico
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today.http://sdm.link/intel
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] sqlparam plugin asks for /* */ commented variables

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

The standards are grand, but between DB2 UDB, SQL Server, MySQL, PostgreSQL and Oralce, their market share of almost 100% suggests that it would be wise to support the /**/ comments anyway.


From: Neville Rowe [mailto:row...@ho...]
Sent: Wednesday, December 21, 2016 9:30 AM
To: Federico Bruni
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] sqlparam plugin asks for /* */ commented variables

Hi Federico,

I think I wrote that code, but I cannot remember how I did it. Quickly checking the SQL 92 standard, — is the standard comment introducer


         <comment> ::=

              <comment introducer> [ <comment character>... ] <newline>



         <comment character> ::=

                <nonquote character>

              | <quote>



         <comment introducer> ::= <minus sign><minus sign>[<minus sign>...]

         6) There shall be no <space> nor <newline> separating the <minus

            sign>s of a <comment introducer>.



         7) SQL text containing one or more instances of <comment> is equiv-

            alent to the same SQL text with the <comment> replaced with

            <newline>.
So I suspect we are working to spec but that isn’t the same as being compatible
with different dialects for different databases.

Neville



On 21 Dec 2016, at 14:14, Federico Bruni <fe...@in...<mailto:fe...@in...>> wrote:

Hi all

I thought that I was still affected by a bug fixed in 2014:
https://sourceforge.net/p/squirrel-sql/bugs/618/

Example:

SELECT * FROM CARS
WHERE NAME LIKE 'TOY%' /*IN (:var1, :var2, :var3) */ ;

Instead of just executing the LIKE 'TOY%' statement, I'm prompted for
the variables which are in a commented block and should be therefore
ignored.

I've looked at commit e785904a6563f90d34bc1fc570fe472259c9903a in git
and found out that if I use '--' for commenting then sqlparam won't
prompt for variables:

SELECT * FROM CARS
WHERE NAME LIKE 'TOY%'; -- IN (:var1, :var2, :var3);

I don't know what's the recommended way to do this sort of things in
SQL, but I wanted to share this with you.

Thanks
Federico






------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/intel
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...<mailto:Squ...@li...>
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] sqlparam plugin asks for /* */ commented variables

[Neville R. <row...@ho...>]

Hi Federico,

I think I wrote that code, but I cannot remember how I did it. Quickly checking the SQL 92 standard, — is the standard comment introducer


         <comment> ::=
              <comment introducer> [ <comment character>... ] <newline>

         <comment character> ::=
                <nonquote character>
              | <quote>

         <comment introducer> ::= <minus sign><minus sign>[<minus sign>...]

         6) There shall be no <space> nor <newline> separating the <minus
            sign>s of a <comment introducer>.

         7) SQL text containing one or more instances of <comment> is equiv-
            alent to the same SQL text with the <comment> replaced with
            <newline>.


So I suspect we are working to spec but that isn’t the same as being compatible with different dialects for different databases.

Neville



On 21 Dec 2016, at 14:14, Federico Bruni <fe...@in...<mailto:fe...@in...>> wrote:

Hi all

I thought that I was still affected by a bug fixed in 2014:
https://sourceforge.net/p/squirrel-sql/bugs/618/

Example:

SELECT * FROM CARS
WHERE NAME LIKE 'TOY%' /*IN (:var1, :var2, :var3) */ ;

Instead of just executing the LIKE 'TOY%' statement, I'm prompted for
the variables which are in a commented block and should be therefore
ignored.

I've looked at commit e785904a6563f90d34bc1fc570fe472259c9903a in git
and found out that if I use '--' for commenting then sqlparam won't
prompt for variables:

SELECT * FROM CARS
WHERE NAME LIKE 'TOY%'; -- IN (:var1, :var2, :var3);

I don't know what's the recommended way to do this sort of things in
SQL, but I wanted to share this with you.

Thanks
Federico






------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/intel
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] sqlparam plugin asks for /* */ commented variables

[Federico B. <fe...@in...>]

Hi all

I thought that I was still affected by a bug fixed in 2014:
https://sourceforge.net/p/squirrel-sql/bugs/618/

Example:

SELECT * FROM CARS
WHERE NAME LIKE 'TOY%' /*IN (:var1, :var2, :var3) */ ;

Instead of just executing the LIKE 'TOY%' statement, I'm prompted for 
the variables which are in a commented block and should be therefore 
ignored.

I've looked at commit e785904a6563f90d34bc1fc570fe472259c9903a in git 
and found out that if I use '--' for commenting then sqlparam won't 
prompt for variables:

SELECT * FROM CARS
WHERE NAME LIKE 'TOY%'; -- IN (:var1, :var2, :var3);

I don't know what's the recommended way to do this sort of things in 
SQL, but I wanted to share this with you.

Thanks
Federico

Re: [Squirrel-sql-users] squirell sql on resolution 3200x1800

[Tomáš D. <tom...@gm...>]

Thank you, but already tried and did not help at all.

--

Tomáš D.

On Tue, Dec 20, 2016 at 2:47 AM, Wesley Newswanger <
We...@ke...> wrote:

> Sorry I couldn’t help you out. Hopefully someone finds it useful.
>
> Here is something I found but it didn't make any difference on my Win10
> machine.
>
> The solution for applications that do not display correct on 4K screens is
> to tell the jvm it must NOT run dpi aware. This is done by providing a jvm
> parameter in the startup script of the java application
>
> -Dsun.java2d.dpiaware=false
>
> Best Regards,
>
> Wesley S. Newswanger    IT & Database Administrator
>
> Keystone Collections™
> Office:  866.881.6680    ext. 1028
> Email:    we...@ke...
>
>
> From: Tomáš Debnár [mailto:tom...@gm...]
> Sent: Monday, December 19, 2016 7:20 PM
> To: Wesley Newswanger <We...@Ke...>
> Cc: squ...@li...
> Subject: Re: [Squirrel-sql-users] squirell sql on resolution 3200x1800
>
> Thanks, but I am having this problem on ubuntu 16.04 lts. I did also try
> to search trough sources and look up for dpi or dpiAware, but did not find
> anything useful.
>
> This is the only section, where dpi is mentioned, but I do not have any
> clue how to use it or if it can be used.
>
> case IColumnIndexes.IDX_REQUIRED:
>                         {
>                                 // Use valueof when min supported JDK is
> 1.4
>                                 //return Boolean.valueOf(_props[row].
> required);
>                                 DriverPropertyInfo dpi =
> sdp.getDriverPropertyInfo();
>                                 if (dpi != null)
>                                 {
>                                         return
> Boolean.valueOf(dpi.required);
>                                 }
>                                 return Boolean.FALSE;
>                         }
>
>                         case IColumnIndexes.IDX_DESCRIPTION:
>                         {
>                                 DriverPropertyInfo dpi =
> sdp.getDriverPropertyInfo();
>                                 if (dpi != null)
>                                 {
>                                         return dpi.description;
>                                 }
>                                 return s_stringMgr.getString("
> DriverPropertiesTableModel.unknown");
>                         }
>
>
> --
>
> Tomáš D.
>
> On Mon, Dec 19, 2016 at 1:38 PM, Wesley Newswanger <
> We...@ke...> wrote:
> Hello Tomas,
>
> I had the same frustrating experience when I first got my 4k monitor.
>
> Here is what you need to do. I did test and confirm that this works with
> Squirrel SQL.
>
> Download and install the free Resource Hacker program from here:
> http://www.angusj.com/resourcehacker/
>
> Start Resource Hacker and open the java.exe file. Mine was located at
> ‘C:\Program Files (x86)\Java\jre1.8.0_111\bin’
>
> In the left pane of Resource Hacker expand the Manifest node and select 1:0
>
> Find the section that looks like this:
>
>   <asmv3:application>
>     <asmv3:windowsSettings xmlns="http://schemas.microsoft.com/SMI/2005/
> WindowsSettings">
>        <dpiAware>true</dpiAware>
>     </asmv3:windowsSettings>
>   </asmv3:application>
>
> Change the line <dpiAware>true</dpiAware> to <dpiAware>false</dpiAware>
>
> Select Action > Modify or F5 to compile the changes.
>
> Save the java.exe file. If windows security does not allow you to save it
> in the programs folder, save it to your desktop and then move it to the
> original folder, overwriting the existing jave.exe file.
>
> Repeat the process on the javaw.exe file in the same folder.
>
> Open Squirrel SQL and it should now display correctly. If it doesn’t, go
> back and verify that the dpiAware setting was for sure changed to false. I
> had a couple times when the change was not applied.
>
> This process also works for other programs that display very small. For
> more information on this procedure see the link below.
>
> http://winaero.com/blog/how-to-fix-apps-that-look-small-
> on-high-dpi-and-high-resolution-displays/
>
> Hope this helps.
>
> Best Regards,
>
> Wesley S. Newswanger    IT & Database Administrator
>
> Keystone Collections™
> Office:  866.881.6680    ext. 1028
> Email:    we...@ke...
>
>
> From: Tomáš Debnár [mailto:tom...@gm...]
> Sent: Sunday, December 18, 2016 11:32 AM
> To: squ...@li...
> Subject: [Squirrel-sql-users] squirell sql on resolution 3200x1800
>
> Hello,
>
> I am having problem to run squirrel sql on my Dell XPS13 with 3200x1800
> resolution. Whole UI is small and I could not find any tool or option to
> double its size.
> Is it possible to run squirrel in this resolution size?
>
>
> --
>
> Tomas Debnar
>
>

Re: [Squirrel-sql-users] squirell sql on resolution 3200x1800

[Wesley N. <We...@Ke...>]

Sorry I couldn’t help you out. Hopefully someone finds it useful.

Here is something I found but it didn't make any difference on my Win10 machine.

The solution for applications that do not display correct on 4K screens is to tell the jvm it must NOT run dpi aware. This is done by providing a jvm parameter in the startup script of the java application 

-Dsun.java2d.dpiaware=false

Best Regards,

Wesley S. Newswanger    IT & Database Administrator 

Keystone Collections™
Office:  866.881.6680    ext. 1028
Email:    we...@ke... 


From: Tomáš Debnár [mailto:tom...@gm...] 
Sent: Monday, December 19, 2016 7:20 PM
To: Wesley Newswanger <We...@Ke...>
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] squirell sql on resolution 3200x1800

Thanks, but I am having this problem on ubuntu 16.04 lts. I did also try to search trough sources and look up for dpi or dpiAware, but did not find anything useful.

This is the only section, where dpi is mentioned, but I do not have any clue how to use it or if it can be used.

case IColumnIndexes.IDX_REQUIRED:
			{
				// Use valueof when min supported JDK is 1.4
				//return Boolean.valueOf(_props[row].required);
				DriverPropertyInfo dpi = sdp.getDriverPropertyInfo();
				if (dpi != null)
				{
					return Boolean.valueOf(dpi.required);
				}
				return Boolean.FALSE;
			}

			case IColumnIndexes.IDX_DESCRIPTION:
			{
				DriverPropertyInfo dpi = sdp.getDriverPropertyInfo();
				if (dpi != null)
				{
					return dpi.description;
				}
				return s_stringMgr.getString("DriverPropertiesTableModel.unknown");
			}


--

Tomáš D.

On Mon, Dec 19, 2016 at 1:38 PM, Wesley Newswanger <We...@ke...> wrote:
Hello Tomas,
 
I had the same frustrating experience when I first got my 4k monitor. 
 
Here is what you need to do. I did test and confirm that this works with Squirrel SQL.
 
Download and install the free Resource Hacker program from here: http://www.angusj.com/resourcehacker/
 
Start Resource Hacker and open the java.exe file. Mine was located at ‘C:\Program Files (x86)\Java\jre1.8.0_111\bin’
 
In the left pane of Resource Hacker expand the Manifest node and select 1:0
 
Find the section that looks like this:
 
  <asmv3:application>
    <asmv3:windowsSettings xmlns="http://schemas.microsoft.com/SMI/2005/WindowsSettings">
       <dpiAware>true</dpiAware>
    </asmv3:windowsSettings>
  </asmv3:application>
 
Change the line <dpiAware>true</dpiAware> to <dpiAware>false</dpiAware>
 
Select Action > Modify or F5 to compile the changes.
 
Save the java.exe file. If windows security does not allow you to save it in the programs folder, save it to your desktop and then move it to the original folder, overwriting the existing jave.exe file.
 
Repeat the process on the javaw.exe file in the same folder.
 
Open Squirrel SQL and it should now display correctly. If it doesn’t, go back and verify that the dpiAware setting was for sure changed to false. I had a couple times when the change was not applied.
 
This process also works for other programs that display very small. For more information on this procedure see the link below.
 
http://winaero.com/blog/how-to-fix-apps-that-look-small-on-high-dpi-and-high-resolution-displays/
 
Hope this helps.
 
Best Regards,

Wesley S. Newswanger    IT & Database Administrator 

Keystone Collections™
Office:  866.881.6680    ext. 1028
Email:    we...@ke... 


From: Tomáš Debnár [mailto:tom...@gm...] 
Sent: Sunday, December 18, 2016 11:32 AM
To: squ...@li...
Subject: [Squirrel-sql-users] squirell sql on resolution 3200x1800
 
Hello,
 
I am having problem to run squirrel sql on my Dell XPS13 with 3200x1800 resolution. Whole UI is small and I could not find any tool or option to double its size.
Is it possible to run squirrel in this resolution size?


--
 
Tomas Debnar

Re: [Squirrel-sql-users] squirell sql on resolution 3200x1800

[Tomáš D. <tom...@gm...>]

Thanks, but I am having this problem on ubuntu 16.04 lts. I did also try to
search trough sources and look up for dpi or dpiAware, but did not find
anything useful.

This is the only section, where dpi is mentioned, but I do not have any
clue how to use it or if it can be used.

case IColumnIndexes.IDX_REQUIRED:
{
// Use valueof when min supported JDK is 1.4
//return Boolean.valueOf(_props[row].required);
DriverPropertyInfo dpi = sdp.getDriverPropertyInfo();
if (dpi != null)
{
return Boolean.valueOf(dpi.required);
}
return Boolean.FALSE;
}

case IColumnIndexes.IDX_DESCRIPTION:
{
DriverPropertyInfo dpi = sdp.getDriverPropertyInfo();
if (dpi != null)
{
return dpi.description;
}
return s_stringMgr.getString("DriverPropertiesTableModel.unknown");
}

--

Tomáš D.

On Mon, Dec 19, 2016 at 1:38 PM, Wesley Newswanger <
We...@ke...> wrote:

> Hello Tomas,
>
>
>
> I had the same frustrating experience when I first got my 4k monitor.
>
>
>
> Here is what you need to do. I did test and confirm that this works with
> Squirrel SQL.
>
>
>
> Download and install the free Resource Hacker program from here:
> http://www.angusj.com/resourcehacker/
>
>
>
> Start Resource Hacker and open the java.exe file. Mine was located at
> ‘C:\Program Files (x86)\Java\jre1.8.0_111\bin’
>
>
>
> In the left pane of Resource Hacker expand the Manifest node and select 1:0
>
>
>
> Find the section that looks like this:
>
>
>
>   <asmv3:application>
>
>     <asmv3:windowsSettings xmlns="http://schemas.microsoft.com/SMI/2005/
> WindowsSettings">
>
>        <dpiAware>true</dpiAware>
>
>     </asmv3:windowsSettings>
>
>   </asmv3:application>
>
>
>
> Change the line <dpiAware>true</dpiAware> to <dpiAware>false</dpiAware>
>
>
>
> Select Action > Modify or F5 to compile the changes.
>
>
>
> Save the java.exe file. If windows security does not allow you to save it
> in the programs folder, save it to your desktop and then move it to the
> original folder, overwriting the existing jave.exe file.
>
>
>
> Repeat the process on the javaw.exe file in the same folder.
>
>
>
> Open Squirrel SQL and it should now display correctly. If it doesn’t, go
> back and verify that the dpiAware setting was for sure changed to false. I
> had a couple times when the change was not applied.
>
>
>
> This process also works for other programs that display very small. For
> more information on this procedure see the link below.
>
>
>
> http://winaero.com/blog/how-to-fix-apps-that-look-small-
> on-high-dpi-and-high-resolution-displays/
>
>
>
> Hope this helps.
>
>
>
> Best Regards,
>
> *Wesley S. Newswanger <http://w3w.cm/today.astounding.equals>*    IT &
> Database Administrator
>
> *Keystone Collections*™
> Office:  866.881.6680    ext. 1028
> Email:    we...@ke...
>
> <http://www.keystonecollections.com/>
>
> *From:* Tomáš Debnár [mailto:tom...@gm...]
> *Sent:* Sunday, December 18, 2016 11:32 AM
> *To:* squ...@li...
> *Subject:* [Squirrel-sql-users] squirell sql on resolution 3200x1800
>
>
>
> Hello,
>
>
>
> I am having problem to run squirrel sql on my Dell XPS13 with 3200x1800
> resolution. Whole UI is small and I could not find any tool or option to
> double its size.
>
> Is it possible to run squirrel in this resolution size?
>
>
> --
>
>
>
> Tomas Debnar
>

Re: [Squirrel-sql-users] squirell sql on resolution 3200x1800

[Wesley N. <We...@Ke...>]

Hello Tomas,

I had the same frustrating experience when I first got my 4k monitor.

Here is what you need to do. I did test and confirm that this works with Squirrel SQL.

Download and install the free Resource Hacker program from here: http://www.angusj.com/resourcehacker/

Start Resource Hacker and open the java.exe file. Mine was located at ‘C:\Program Files (x86)\Java\jre1.8.0_111\bin’

In the left pane of Resource Hacker expand the Manifest node and select 1:0

Find the section that looks like this:

  <asmv3:application>
    <asmv3:windowsSettings xmlns="http://schemas.microsoft.com/SMI/2005/WindowsSettings">
       <dpiAware>true</dpiAware>
    </asmv3:windowsSettings>
  </asmv3:application>

Change the line <dpiAware>true</dpiAware> to <dpiAware>false</dpiAware>

Select Action > Modify or F5 to compile the changes.

Save the java.exe file. If windows security does not allow you to save it in the programs folder, save it to your desktop and then move it to the original folder, overwriting the existing jave.exe file.

Repeat the process on the javaw.exe file in the same folder.

Open Squirrel SQL and it should now display correctly. If it doesn’t, go back and verify that the dpiAware setting was for sure changed to false. I had a couple times when the change was not applied.

This process also works for other programs that display very small. For more information on this procedure see the link below.

http://winaero.com/blog/how-to-fix-apps-that-look-small-on-high-dpi-and-high-resolution-displays/

Hope this helps.

Best Regards,

Wesley S. Newswanger<http://w3w.cm/today.astounding.equals>    IT & Database Administrator

Keystone Collections™
Office:  866.881.6680    ext. 1028
Email:    we...@ke... <mailto:we...@ke...>

[cid:image001.gif@01D259CA.4DE82110]<http://www.keystonecollections.com/>
From: Tomáš Debnár [mailto:tom...@gm...]
Sent: Sunday, December 18, 2016 11:32 AM
To: squ...@li...
Subject: [Squirrel-sql-users] squirell sql on resolution 3200x1800

Hello,

I am having problem to run squirrel sql on my Dell XPS13 with 3200x1800 resolution. Whole UI is small and I could not find any tool or option to double its size.
Is it possible to run squirrel in this resolution size?

--

Tomas Debnar

[Squirrel-sql-users] squirell sql on resolution 3200x1800

[Tomáš D. <tom...@gm...>]

Hello,

I am having problem to run squirrel sql on my Dell XPS13 with 3200x1800
resolution. Whole UI is small and I could not find any tool or option to
double its size.
Is it possible to run squirrel in this resolution size?

--

Tomas Debnar

Re: [Squirrel-sql-users] Bug in Squirrel version 3.7.1 when we look after the source of view

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

Could you please post the complete stacktrace of your error message. The 
stacktrace can be found at
main menu -> Windows -> View SQuirreL Logs

Thanks
Gerd

Am 13.12.2016 um 11:07 schrieb Cheick DIENG:
> Hi,
> How to get source SQL queries for the views in squirrel client in
> version 3.7.1
> <http://stackoverflow.com/questions/17530117/how-to-get-source-sql-queries-for-the-views-in-squirrel-client-3-4-0>
>
> We encoured a bug when we select the source tab in the object tab like
>  << ExampleExceptionFormatter: exception message was: Pas de valeur
> spécifiée pour le paramètre 2.>>
> Thanks for your help.
>
>
> *Cheikh DIENG - Externe*
> GIRC Agirc-Arrco
> Direction Technique /Architecture Technique, Industrialisation et
> Performance
> Socle Middleware & SGBD - *Ormes*
>
> Tél: 02 38 42 80 79
> cdi...@gi...
>
> ______________________________________________________________________________________
>
> L'intégrité de ce message et de toutes ses pièces jointes n'étant pas
> entièrement assurée sur internet,
> le GIRC Agirc-Arrco ne peut pas être tenu responsable de son contenu.
> Toute utilisation de ce message non conforme à sa destination est
> interdite sauf autorisation expresse.
> Si vous n'êtes pas destinataire de ce message, merci de le détruire et
> d'en avertir l'expéditeur.
> ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>

[Squirrel-sql-users] SSL with connection to MS sqlserver

[Lists <li...@se...>]

Recently 'turned on' SSL on a MS sqlserver database. I have selected 'SSL' via the alias properties but can not connect. I am able to connect via a command line tool. It takes a while, but fails to connect. What am I missing? Connects fine if SSL is turned off on the database. Thank you for any assistance 

Geoffrey Myers

[Squirrel-sql-users] Bug in Squirrel version 3.7.1 when we look after the source of view

[Cheick D. <cdi...@gi...>]

Hi,
How to get source SQL queries for the views in squirrel client in version 
3.7.1
We encoured a bug when we select the source tab in the object tab like  << 
ExampleExceptionFormatter: exception message was: Pas de valeur spécifiée 
pour le paramètre 2.>>
Thanks for your help.


Cheikh DIENG - Externe
GIRC Agirc-Arrco
Direction Technique /Architecture Technique, Industrialisation et 
Performance
Socle Middleware & SGBD - Ormes

Tél: 02 38 42 80 79
cdi...@gi...


______________________________________________________________________________________
L'intégrité de ce message et de toutes ses pièces jointes n'étant pas 
entièrement assurée sur internet,
le GIRC Agirc-Arrco ne peut pas être tenu responsable de son contenu.
Toute utilisation de ce message non conforme à sa destination est 
interdite sauf autorisation expresse. 
Si vous n'êtes pas destinataire de ce message, merci de le détruire et 
d'en avertir l'expéditeur. 
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

Re: [Squirrel-sql-users] Table not up-to-date

[<tri...@ya...>]

Hi Squirrel-sql-users,


 Well  I  just  made  a very interesting discovery after doing only my
 second sql query.

 I did a basic query on the Product table:

 SELECT *
 FROM PRODUCTS

 and guess what? All the records now displayed!


 So  my  question  is,  why  when  I  opened  squirrel  each time (and
 refreshed the database) and then selected the Products table,
 did I not see all the records (only the old records)?

 Why did I have to do a query to see all of them?


  Thanks!




---------------------------------------------
  I have a database that I am using with uniCenta software.
  When I loaded the database into Squirrel a few months ago
  everything seemed to be fine.

  I updated a bunch of products in uniCenta and it shows fine
  that program.

  Now when I fire up Squirrel, the Products table is not showing
  the new records.

  Any ideas why this could be happening?
  Any suggestions?

   Thanks!

    Mark

[Squirrel-sql-users] Table not up-to-date

[<tri...@ya...>]

Hi Squirrel-sql-users,


  I have a database that I am using with uniCenta software.
  When I loaded the database into Squirrel a few months ago
  everything seemed to be fine.

  I updated a bunch of products in uniCenta and it shows fine
  that program.

  Now when I fire up Squirrel, the Products table is not showing
  the new records.

  Any ideas why this could be happening?
  Any suggestions?

   Thanks!

    Mark

Re: [Squirrel-sql-users] (no subject)

[Al Le <al...@gm...>]

> I personally would not expect a generic SQL client like Squirrel to
> have support for 100% of each and every back end’s proprietory
> features

Fully agreed. But there are DB specific plugins which might have those 
features. To the OP: Look at the plugins.

[Squirrel-sql-users] Some data not updating

[<tri...@ya...>]

  Hi Squirrel-sql-users,


  I need to make a correction to my first post from a few days ago.

  I mentioned:

 "I had entered a lot of new data and Apache just did not see it.
 It was still reading the old data.

 How can I tell Squirrel to refresh the data?
 It looks like the directory is correct for the files."


 This is not correct.

 After looking more closely at the data all of it has been updated by
 Squirrel except for the most import part!
 My Product table.

 Any ideas  why this has happened and what I can try to get the table
 to update?

  Thanks very much!

    Mark

Re: [Squirrel-sql-users] (no subject)

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

If you are looking for those vendor specific details you would be better off using SQLDeveloper for Oracle and IBM Data Studio for UDB. Both are free d/l.
I personally would not expect a generic SQL client like Squirrel to have support for 100% of each and every back end’s proprietory features.

Regards,
Alex

From: Sathesh S [mailto:Sat...@ho...]
Sent: Tuesday, November 22, 2016 11:29 AM
To: squ...@li...
Subject: [Squirrel-sql-users] (no subject)


Hello,

I tried using SQuirreL SQL for Oracle & UDB databases, I see some functionality are missing for both Oracle & UDB. Have anyone faced/observed similar issues and any workaround/fixes for the same.

Below are the issues which I see:

Oracle using ojdbc7 driver:

1.    It is not differentiating IOT or Partitioned tables visually.

2.    for IOT table is incorrect. Column level stats of the table are missing.

3.    Constraints are missing in Object navigator.

4.    Partitions and subpartition details are missing in Objects Navigator.

5.    Referential constraints or triggers are missing under tables.

6.    Do not see an option to generate AWR/ASH/SQL reports.



UDB using db2jcc4 driver:

1.    Does not show trigger

2.    Does not show Sequence

3.    Does not show Constraint

4.    Does not show Procedure text

5.    Not able to create procedures

6.    No option to cancel the running query

7.    No option for query explain plan



Any input will be helpful, thanks in advance.

Regards,
Sathesh

[Squirrel-sql-users] SQuirreL SQL for Oracle & UDB databases

[Sathesh S <Sat...@ho...>]

From: Sathesh S<mailto:Sat...@ho...>
Sent: Tuesday, November 22, 2016 9:59 PM
To: squ...@li...<mailto:squ...@li...>
Subject:


Hello,

I tried using SQuirreL SQL for Oracle & UDB databases, I see some functionality are missing for both Oracle & UDB. Have anyone faced/observed similar issues and any workaround/fixes for the same.

Below are the issues which I see:

Oracle using ojdbc7 driver:

1.    It is not differentiating IOT or Partitioned tables visually.

2.    for IOT table is incorrect. Column level stats of the table are missing.

3.    Constraints are missing in Object navigator.

4.    Partitions and subpartition details are missing in Objects Navigator.

5.    Referential constraints or triggers are missing under tables.

6.    Do not see an option to generate AWR/ASH/SQL reports.



UDB using db2jcc4 driver:

1.    Does not show trigger

2.    Does not show Sequence

3.    Does not show Constraint

4.    Does not show Procedure text

5.    Not able to create procedures

6.    No option to cancel the running query

7.    No option for query explain plan



Any input will be helpful, thanks in advance.

Regards,
Sathesh

[Squirrel-sql-users] (no subject)

[Sathesh S <Sat...@ho...>]

Hello,

I tried using SQuirreL SQL for Oracle & UDB databases, I see some functionality are missing for both Oracle & UDB. Have anyone faced/observed similar issues and any workaround/fixes for the same.

Below are the issues which I see:

Oracle using ojdbc7 driver:

1.    It is not differentiating IOT or Partitioned tables visually.

2.    for IOT table is incorrect. Column level stats of the table are missing.

3.    Constraints are missing in Object navigator.

4.    Partitions and subpartition details are missing in Objects Navigator.

5.    Referential constraints or triggers are missing under tables.

6.    Do not see an option to generate AWR/ASH/SQL reports.



UDB using db2jcc4 driver:

1.    Does not show trigger

2.    Does not show Sequence

3.    Does not show Constraint

4.    Does not show Procedure text

5.    Not able to create procedures

6.    No option to cancel the running query

7.    No option for query explain plan



Any input will be helpful, thanks in advance.

Regards,
Sathesh

[Squirrel-sql-users] Alias connection not updating

[<tri...@ya...>]

Hi Squirrel-sql-users,


 I was able to make a successful Alias connection a while back and get
 in to edit tables etc. of my Apache Derby Embedded files.

 Just this evening I wanted to get back in to edit some tables and the
 first thing I discovered was that Apache did not notice that my database
 had changed, new data entered into it.

 I had entered a lot of new data and Apache just did not see it.
 It was still reading the old data.

 How can I tell Squirrel to refresh the data?
 It looks like the directory is correct for the files.

  Thanks!

    Mark


-- 
All the best,
 Trio59-computing                          mailto:tri...@ya...

Re: [Squirrel-sql-users] SQUIRREL and postgresql

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

On Sat, 12 Nov 2016, Philippe Couas wrote:

> I have resolved problem good ip is 192.168.99.100 and not 172.17.0.x

That'd do it too. :)

Replying to the list so others know you've solved the problem.

> Regards
> Philippe
>
> 2016-11-11 19:10 GMT+01:00 John Hardin <jh...@im...>:
>
>> On Fri, 11 Nov 2016, Philippe Couas wrote:
>>
>> Currently i have SQUIRREL on my Computer and Postgres8.4 on remote HOST, my
>>> connection is refused, but if i install Postgres on my computer , i could
>>> connect to remote HOST with same parameters ?
>>> Why ?
>>>
>>
>> Was there a specific error message that stated a reason for not being able
>> to connect? Or was "connection refused" the error message?
>>
>> "connection refused" suggests that Squirrel is attempting to connect on a
>> TCP port that PGSQL is not listening on. What TCP port is your PGSQL
>> listening on? What TCP port (if any) was specified in your connect string
>> in Squirrel? Does explicitly specifying the TCP port number in the Squirrel
>> connect string allow you to connect successfully?

-- 
  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
-----------------------------------------------------------------------
   USMC Rules of Gunfighting #6: If you can choose what to bring to a
   gunfight, bring a long gun and a friend with a long gun.
-----------------------------------------------------------------------
  327 days since the first successful real return to launch site (SpaceX)

Re: [Squirrel-sql-users] SQUIRREL and postgresql

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

On Fri, 11 Nov 2016, Philippe Couas wrote:

> Currently i have SQUIRREL on my Computer and Postgres8.4 on remote HOST, my
> connection is refused, but if i install Postgres on my computer , i could
> connect to remote HOST with same parameters ?
> Why ?

Was there a specific error message that stated a reason for not being able 
to connect? Or was "connection refused" the error message?

"connection refused" suggests that Squirrel is attempting to connect on a 
TCP port that PGSQL is not listening on. What TCP port is your PGSQL 
listening on? What TCP port (if any) was specified in your connect string 
in Squirrel? Does explicitly specifying the TCP port number in the 
Squirrel connect string allow you to connect successfully?

-- 
  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
-----------------------------------------------------------------------
   From the Liberty perspective, it doesn't matter if it's a
   jackboot or a Birkenstock smashing your face.         -- Robb Allen
-----------------------------------------------------------------------
  Today: Veterans Day

[Squirrel-sql-users] SQUIRREL and postgresql

[Philippe C. <pc...@gm...>]

Hi
Currently i have SQUIRREL on my Computer and Postgres8.4 on remote HOST, my
connection is refused, but if i install Postgres on my computer , i could
connect to remote HOST with same parameters ?
Why ?

Regards

[Squirrel-sql-users] SQuirrel 3.7.1 won't open

[Colin C. <col...@gm...>]

Good day,

I've been using SQuirrel 3.7.1 for quite a while without issue. This
afternoon I Installed Ruby 2.3.1p112 (added to path) and Gem 2.6.8 to work
on a Jekyll-based project; now SQuirrel won't open. When I click the
executable, I get a brief Command Prompt window that is extinguished
immediately; moreover, there is no logfile. I'm running Windows 7 on a 64
bit machine. Wanted to check and see if this group had any ideas before I
uninstalled anything.

Many thanks,

Colin