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

Re: [Squirrel-sql-users] Error trying to connect to PostgreSQL server

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

On Fri, 29 Jul 2016, pm...@wi... wrote:

> I forgot to mention that I'm on Windows 10.
>
> The Postgresql box is a VENDOR box and I cannot make any changes there.
>
> I got this same error in pgAdmin III but there was another setting under 
> the ADVANCED tab called Host Address where I entered the IP address and 
> then I was able to access the server without issue.

...does it work if you use the IP address (vs. the hostname) in the JDBC 
connect string?

-- 
  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
-----------------------------------------------------------------------
   You are in a maze of twisty little protocols,
   all written by Microsoft.
----------------------------------------------------------------------
  7 days until the 281st anniversary of John Peter Zenger's acquittal

Re: [Squirrel-sql-users] Error trying to connect to PostgreSQL server

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

On Fri, 29 Jul 2016, pm...@wi... wrote:

> I was hoping that now that I'm working with PostgreSQL that it would 
> work as well however I'm getting an error when trying to connect.
>
> java.util.concurrent.ExecutionException: java.lang.RuntimeException: 
> org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host 
> "75.141.184.2", user "fwisd_ro", database "fwisd_appdev", SSL off

This doesn't look like an error specific to Squirrel. I'd suggest looking 
for that file (pg_hba.conf) on your system, and doing some googling to see 
how it is supposed to be used.

-- 
  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
-----------------------------------------------------------------------
   If guns kill people, then...
     -- pencils miss spel words.
     -- cars make people drive drunk.
     -- spoons make people fat.
-----------------------------------------------------------------------
  7 days until the 281st anniversary of John Peter Zenger's acquittal

Re: [Squirrel-sql-users] Error trying to connect to PostgreSQL server

[<pm...@wi...>]

I forgot to mention that I'm on Windows 10.

The Postgresql box is a VENDOR box and I cannot make any changes there.

I got this same error in pgAdmin III but there was another setting under the ADVANCED tab called Host Address where I entered the IP address and then I was able to access the server without issue.

Thanks.

On Friday, July 29, 2016 2:50 PM, pm...@wi... wrote: 

=============
I just downloaded the Squirrel client and setup a driver for PostgreSQL using 
the driver I downloaded from the PostgreSQL website.  It was successfully 
registered for driver definition PostgreSQL. 
 
I downloaded pgAdminIII yesterday but it was not a very good client at all.  I 
worked with Squirrel back in 2004 - 2011 with another JDBC driver and it worked 
great.  I was hoping that now that I'm working with PostgreSQL that it would 
work as well however I'm getting an error when trying to connect.  Any 
help/direction would be greatly appreciated.  Thanks. 
 
Here is the error: 
 
java.util.concurrent.ExecutionException: java.lang.RuntimeException: 
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host 
"75.141.184.2", user "fwisd_ro", database "fwisd_appdev", SSL off 
    at java.util.concurrent.FutureTask.report(Unknown Source) 
    at java.util.concurrent.FutureTask.get(Unknown Source) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d.awaitConnection(OpenConnectionCommand.java:132) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d.access$100(OpenConnectionCommand.java:45) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d$2.run(OpenConnectionCommand.java:115) 
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) 
    at java.util.concurrent.FutureTask.run(Unknown Source) 
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) 
    at java.lang.Thread.run(Unknown Source) 
Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: FATAL: 
no pg_hba.conf entry for host "75.141.184.2", user "fwisd_ro", database 
"fwisd_appdev", SSL off 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d.executeConnect(OpenConnectionCommand.java:171) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d.access$000(OpenConnectionCommand.java:45) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d$1.run(OpenConnectionCommand.java:104) 
    ... 5 more 
Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for 
host "75.141.184.2", user "fwisd_ro", database "fwisd_appdev", SSL off 
    at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionF
actoryImpl.java:451) 
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Connectio
nFactoryImpl.java:223) 
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.ja
va:67) 
    at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:212) 
    at org.postgresql.Driver.makeConnection(Driver.java:407) 
    at org.postgresql.Driver.connect(Driver.java:275) 
    at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDri
verManager.java:133) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d.executeConnect(OpenConnectionCommand.java:167) 
    ... 7 more 
 
 
 
------------------------------------------------------------------------------ 
_______________________________________________ 
Squirrel-sql-users mailing list 
Squ...@li... 
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users 

[Squirrel-sql-users] Error trying to connect to PostgreSQL server

[<pm...@wi...>]

I just downloaded the Squirrel client and setup a driver for PostgreSQL using the driver I downloaded from the PostgreSQL website.  It was successfully registered for driver definition PostgreSQL. 

I downloaded pgAdminIII yesterday but it was not a very good client at all.  I worked with Squirrel back in 2004 - 2011 with another JDBC driver and it worked great.  I was hoping that now that I'm working with PostgreSQL that it would work as well however I'm getting an error when trying to connect.  Any help/direction would be greatly appreciated.  Thanks.

Here is the error:

java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "75.141.184.2", user "fwisd_ro", database "fwisd_appdev", SSL off
    at java.util.concurrent.FutureTask.report(Unknown Source)
    at java.util.concurrent.FutureTask.get(Unknown Source)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "75.141.184.2", user "fwisd_ro", database "fwisd_appdev", SSL off
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
    ... 5 more
Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "75.141.184.2", user "fwisd_ro", database "fwisd_appdev", SSL off
    at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:451)
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:223)
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:67)
    at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:212)
    at org.postgresql.Driver.makeConnection(Driver.java:407)
    at org.postgresql.Driver.connect(Driver.java:275)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
    ... 7 more

 

[Squirrel-sql-users] VARBINARY fields visualization

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

Would the development team consider adding visualization for the fields that may contain images, like SSMS Boost does?

Thank you!
Alex

[Squirrel-sql-users] Squirrel disappears when docking / undocking and unexpectedly quits, windows 10

[Lenny V. <len...@do...>]

Hi Guys

I have an issue with Squirrel while running a query if I undock my Lenovo
t450 laptop with windows 10, squirrel disappears as if it were never
opened. No quit message, no errors, just completely gone. I have tried
uninstalling and reinstalling squirrel but the problem persists. Any idea?

[Squirrel-sql-users] (no subject)

[Lenny V. <len...@do...>]

-- 
*Lenny Vaknine*
Corporate IT / HelpDeskDoubleVerify
575 8th Avenue, New York, NY 10018
718-840-9102 (C)
lenny.vaknine@*doubleverify.com* <len...@do...>

<http://www.doubleverify.com/>
<https://twitter.com/doubleverify>
<https://www.facebook.com/DoubleVerify-129650610434547/>
<https://www.linkedin.com/company/doubleverify-inc>
Join us! *DV is hiring <http://www.doubleverify.com/careers/>*

[Squirrel-sql-users] How can I do a left join with SQurreL in a different schema than public?

[Kristian M. <kri...@gm...>]

Hi!

If I first run the command
SET search_path TO my_schema;
Then i can use the query builder to create my left join query (its pretty
big so the query builder makes it much easier). That work.
But if I copy the query from the query builder to the SQL command window it
fail despite the use of search path??

I need to copy the query from the query builder to the SQL command so I can
modify it, I need to use GROUP BY that the query builder don't seem to
support.

Is there a way I can make the output SQL in the query builder to include
schema names, or is there a way I can use set search path to work when I
run join tables? (I can select rows from individual tables after using
search_path but when i use them in a join query, it fails. Im logged on as
admin user).

Best regards

Re: [Squirrel-sql-users] [Squirrel-sql-develop] Reg Calling Procedures Squirrel

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

On Fri, 8 Jul 2016, Narendra Reddy wrote:

> I have been using DB Squirrel for connecting to Oracle and now that I want
> to create a procedure with a parameter and call that , i have no problem
> with the compilation but getting error while calling the same procedure
> with the parameter. Please help me in using that, or is that not possible
> to call a procedure suing db squirrel.
>
> Thanks & Regards
> Narendra Reddy

Replying on the Users list as that's where this should have been posted. 
Your question is not related to developing Squirrel itself...

What error are you getting?


-- 
  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
-----------------------------------------------------------------------
   People who are unable to figure out how to make change without the
   help of a cash register are demanding a $15/hr minimum wage?
-----------------------------------------------------------------------
  12 days until the 47th anniversary of Apollo 11 landing on the Moon

Re: [Squirrel-sql-users] Query Builder

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

Thanks!

Best Regards,

 Wesley S. Newswanger    IT & Database Administrator 

 Keystone CollectionsT
 Office:  866.881.6680    ext. 1028
 Email:    we...@ke... 

 www.keystonecollections.com 
-----Original Message-----
From: Gerd Wagner [mailto:ger...@t-...] 
Sent: Sunday, June 12, 2016 3:37 PM
To: Wesley Newswanger <We...@Ke...>; squ...@li...
Subject: Re: [Squirrel-sql-users] Query Builder


Am 08.06.2016 um 14:57 schrieb Wesley Newswanger:
>   add a 'Not Like' operator to the Query Builder filter
Is committed to SQuirreL's  Git repository and will be available in 
future versions and snapshots.

Re: [Squirrel-sql-users] Query Builder

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

Am 08.06.2016 um 14:57 schrieb Wesley Newswanger:
>   add a 'Not Like' operator to the Query Builder filter
Is committed to SQuirreL's  Git repository and will be available in 
future versions and snapshots.

Re: [Squirrel-sql-users] squirrel sql client installation

[Alexandre P. <Ale...@ei...>]

You do know that Linux is case-sensitive, right?
Your .xml shows path as
                /kelvin/hbase
but your SQuirreL URL shows it as
                /Kelvin/hbase
--
Alexandre Peshansky, MS
Senior 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
(718) 430-2440, (914) 457-6792 (office) (347) 886-2380 (cell)
[cid:image001.png@01D1C31C.4BC5A640]

From: ke...@th... [mailto:ke...@th...]
Sent: Friday, June 10, 2016 4:04 AM
To: squ...@li...
Subject: [Squirrel-sql-users] squirrel sql client installation

Hi Expert,

I'm trying to build connection between my standalone hbase and squirrel sql client.
The standalone hbase is build on a Linux machine without hadoop.
The hbase-site.xml contains only one property as below:
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
        <property>
                <name>hbase.rootdir</name>
                <value>file:///kelvin/hbase</value<file:///\\kelvin\hbase%3c\value>>
        </property>
</configuration>
<!--

The setting on squirrel sql client is set up as follows:
Name: Hbase
Driver: Phoenix
URL: jdbc:phoenix:ip_addr:/Kelvin/hbase
User Name: root (I don't know how to create a hbase user so I put the linux os login user here)

I believe the Phoenix driver has been set up correctly since a check sign can be seen beside the driver name.
When I connect to hbase using alias Hbase, I got the following errors:
java.util.concurrent.TimeoutException
              at java.util.concurrent.FutureTask.get(Unknown Source)
              at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
              at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
              at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
              at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
              at java.util.concurrent.FutureTask.run(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
              at java.lang.Thread.run(Unknown Source)

Please advise.

Thanks and Regards
Ma Ke

[Squirrel-sql-users] squirrel sql client installation

[<ke...@th...>]

Hi Expert,

I'm trying to build connection between my standalone hbase and squirrel sql client.
The standalone hbase is build on a Linux machine without hadoop.
The hbase-site.xml contains only one property as below:
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
        <property>
                <name>hbase.rootdir</name>
                <value>file:///kelvin/hbase</value>
        </property>
</configuration>
<!--

The setting on squirrel sql client is set up as follows:
Name: Hbase
Driver: Phoenix
URL: jdbc:phoenix:ip_addr:/Kelvin/hbase
User Name: root (I don't know how to create a hbase user so I put the linux os login user here)

I believe the Phoenix driver has been set up correctly since a check sign can be seen beside the driver name.
When I connect to hbase using alias Hbase, I got the following errors:
java.util.concurrent.TimeoutException
              at java.util.concurrent.FutureTask.get(Unknown Source)
              at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
              at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
              at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
              at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
              at java.util.concurrent.FutureTask.run(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
              at java.lang.Thread.run(Unknown Source)

Please advise.

Thanks and Regards
Ma Ke

Re: [Squirrel-sql-users] Drivers installation

[<sat...@ho...>]

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e

Re: [Squirrel-sql-users] Drivers installation

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

When I installed Squirrel it did not come with any JDBC drivers and I had to d/l JTDS for MS SQL, IBM’s driver for DB2 and MySQL driver from Oracle.
I do not know much about PostgreSQL but their web site is probably a good starting point.

Thank you!
Alex

From: Sathesh S [mailto:sat...@ho...]
Sent: Thursday, June 09, 2016 2:21 AM
To: Alex Malmyguine; squ...@li...
Subject: RE: [Squirrel-sql-users] Drivers installation

Thanks for response Alex, can you please tell if I need to download the jar file from https://jdbc.postgresql.org/   or the required JAR files will be provided along with Squirrel SQL download.

Thanks,
Sathesh


From: Alex Malmyguine<mailto:ale...@bl...>
Sent: Wednesday, June 8, 2016 7:11 PM
To: squ...@li...<mailto:squ...@li...>
Subject: Re: [Squirrel-sql-users] Drivers installation


You need to set up the driver in the Drivers section.

Choose PostgreSQL and provide a path to the JAR, etc.



Alex



From: sat...@ho...<mailto:sat...@ho...> [mailto:sat...@ho...]
Sent: Wednesday, June 08, 2016 6:26 AM
To: squ...@li...<mailto:squ...@li...>
Subject: [Squirrel-sql-users] Drivers installation



Hello,

I'm a new user of SQuirreL SQL,  I have installed it my laptop and I have chosen plugins for Oracle, PostgreSQL etc..,

But when I try to connect to PostgreSQL, the connection kept failing. Then I downloaded the JDBC driver from PostgreSQL website and placed it under the lib folder in SQuirreL SQL installation, which helped the connection.

I have a very basic question, does the drivers for the plugins which I choose during installation get installed automatically or I need to download the JDBC drivers for different databases and place it under lib folder.

Please suggest.

Thanks,
Sathesh

Re: [Squirrel-sql-users] Drivers installation

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

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e

Re: [Squirrel-sql-users] Drivers installation

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

You need to set up the driver in the Drivers section.
Choose PostgreSQL and provide a path to the JAR, etc.

Alex

From: sat...@ho... [mailto:sat...@ho...]
Sent: Wednesday, June 08, 2016 6:26 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Drivers installation


Hello,

I'm a new user of SQuirreL SQL,  I have installed it my laptop and I have chosen plugins for Oracle, PostgreSQL etc..,

But when I try to connect to PostgreSQL, the connection kept failing. Then I downloaded the JDBC driver from PostgreSQL website and placed it under the lib folder in SQuirreL SQL installation, which helped the connection.

I have a very basic question, does the drivers for the plugins which I choose during installation get installed automatically or I need to download the JDBC drivers for different databases and place it under lib folder.

Please suggest.

Thanks,
Sathesh

[Squirrel-sql-users] Query Builder

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

Is it possible to add a 'Not Like' operator to the Query Builder filter?

Best Regards,
 
 Wesley S. Newswanger    IT & Database Administrator 
 
 Keystone CollectionsT
        by Martin's Wood Products, LLC
 
 Office:  866.881.6680    ext. 1028
 Email:    we...@ke... 
  
 www.keystonecollections.com

[Squirrel-sql-users] Drivers installation

[<sat...@ho...>]

Hello,


I'm a new user of SQuirreL SQL,  I have installed it my laptop and I have chosen plugins for Oracle, PostgreSQL etc..,


But when I try to connect to PostgreSQL, the connection kept failing. Then I downloaded the JDBC driver from PostgreSQL website and placed it under the lib folder in SQuirreL SQL installation, which helped the connection.


I have a very basic question, does the drivers for the plugins which I choose during installation get installed automatically or I need to download the JDBC drivers for different databases and place it under lib folder.


Please suggest.


Thanks,

Sathesh

Re: [Squirrel-sql-users] autocompletion with table named "ORDER"

[Matt F <de...@ya...>]

Didn't even think of that....in that case the full name might work (although I don't have access to my database system at the moment to test) so schema.order 
if you have admin access you could make a view "patrick" that is just select * from order so then autocomplete could work with select * from patrick where blah blah
That's all i got, sorry :(  ==============================================Matt Ferreira
de...@ya...


      From: "Rehder, Patrick" <Pat...@bl...>
 To: "squ...@li..." <squ...@li...> 
 Sent: Tuesday, June 7, 2016 4:10 AM
 Subject: Re: [Squirrel-sql-users] autocompletion with table named "ORDER"
   
Thanks for your detailed ideas Matt, but unfortunetaly it does not work.
And I totally forgot to mention that autocompletation works fine for all other tables.
Seems to be a problem with the word ORDER which is obvious a reserved SQL keyword.
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


  

Re: [Squirrel-sql-users] autocompletion with table named "ORDER"

[Rehder, P. <Pat...@bl...>]

Thanks for your detailed ideas Matt, but unfortunetaly it does not work.
And I totally forgot to mention that autocompletation works fine for all other tables.
Seems to be a problem with the word ORDER which is obvious a reserved SQL keyword.

Re: [Squirrel-sql-users] autocompletion with table named "ORDER"

[Matt F <de...@ya...>]

I'm not familiar with AS/400 databases so the information below may not be accurate for your use. I'm most familiar with DB2, so my information is geared towards that. However some information is universal in Squirrel land :) 
 The red text indicates the table name is not recognized. 
When I had this problem in DB2 , I had to set my session to use the schema that the tables existed in. If you are using DB2 on AS/400 ten I'd look at the object tree to see what schema your table is in and then issue the following command:
set schema <SCHEMANAMEHERE>;
Then autocompletes should work. 
An alternative would be select * from SCHEMANAMEHERE.order where orderk and then autocomplete should work (as the table name would be green - some times this takes a few seconds depending on the size of your schema) 
If you're not using DB2 on AS/400 then this may not be the exact information you need, but should get you down the right path


Good LuckMatt ==============================================Matt Ferreira
de...@ya...


      From: "Rehder, Patrick" <Pat...@bl...>
 To: "squ...@li..." <squ...@li...> 
 Sent: Tuesday, June 7, 2016 3:11 AM
 Subject: [Squirrel-sql-users] autocompletion with table named "ORDER"
   
 <!--#yiv7738845131 _filtered #yiv7738845131 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv7738845131 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv7738845131 #yiv7738845131 p.yiv7738845131MsoNormal, #yiv7738845131 li.yiv7738845131MsoNormal, #yiv7738845131 div.yiv7738845131MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}#yiv7738845131 a:link, #yiv7738845131 span.yiv7738845131MsoHyperlink {color:blue;text-decoration:underline;}#yiv7738845131 a:visited, #yiv7738845131 span.yiv7738845131MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv7738845131 span.yiv7738845131E-MailFormatvorlage17 {font-family:"Calibri", "sans-serif";color:windowtext;}#yiv7738845131 .yiv7738845131MsoChpDefault {} _filtered #yiv7738845131 {margin:70.85pt 70.85pt 2.0cm 70.85pt;}#yiv7738845131 div.yiv7738845131WordSection1 {}-->Good morning, I’ve got a problem with autocompletion, when I write a statement like this:    select * from order where orderkind = 1;    When I wrote this and type STRG+SPACE nothing happend:    select * from order where orderk    The problem seems to be the tablename because it is marked red and not green like all other table names. Quoting the tablename („ORDER“) does not help.    The connection is done over JTOpen Driver to an AS/400. And I have installed latest version. (3.7)    Hopefully somebody has an idea how to solve that problem – and renaming the table is not an option. ;)       Best regards, Patrick 
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


  

[Squirrel-sql-users] autocompletion with table named "ORDER"

[Rehder, P. <Pat...@bl...>]

Good morning,
I've got a problem with autocompletion, when I write a statement like this:

select * from order where orderkind = 1;

When I wrote this and type STRG+SPACE nothing happend:

select * from order where orderk

The problem seems to be the tablename because it is marked red and not green like all other table names.
Quoting the tablename ("ORDER") does not help.

The connection is done over JTOpen Driver to an AS/400.
And I have installed latest version. (3.7)

Hopefully somebody has an idea how to solve that problem - and renaming the table is not an option. ;)


Best regards,
Patrick

Re: [Squirrel-sql-users] How do you set different session properties for different aliases?

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

Am 03.06.2016 um 10:00 schrieb Al Le:
> Hello,
>
> in my Squirrel SQL setup, I have configured aliases for different DBs (among them are MS SQL and DB2). These DBs contain different schemas, but in each alias I want to see only objects from a particular schema.
>
> Squirrel SQL can do object filtering (via session properties), but (in my case) the filters should be different for different aliases.
>
> An ideal solution would be, if the correct filter is set/activated after the DB connection is established. But, to my knowledge, it's not possible to define filters on alias basis, it's a global option.
>
> I've created the feature request #496 (Per Alias session properties), but it has drawn no attention so far.
>
> Do you face the same problem? How do you handle it?

Right mouse click an Alias and select 'Alias properties' from the right 
mouse menu.

Hope this helps.

Gerd

[Squirrel-sql-users] How do you set different session properties for different aliases?

[Al L. <Al...@gm...>]

Hello,

in my Squirrel SQL setup, I have configured aliases for different DBs (among them are MS SQL and DB2). These DBs contain different schemas, but in each alias I want to see only objects from a particular schema.

Squirrel SQL can do object filtering (via session properties), but (in my case) the filters should be different for different aliases.

An ideal solution would be, if the correct filter is set/activated after the DB connection is established. But, to my knowledge, it's not possible to define filters on alias basis, it's a global option.

I've created the feature request #496 (Per Alias session properties), but it has drawn no attention so far.

Do you face the same problem? How do you handle it?

Thanks!
AL