ke.ma | 10 Jun 10:03 2016

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>

        </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

 

------------------------------------------------------------------------------
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
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Wesley Newswanger | 8 Jun 14:57 2016

Query Builder

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:    wesleyn <at> keystonecollections.com 
  
 www.keystonecollections.com

------------------------------------------------------------------------------
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
sathesh.sundaram | 8 Jun 12:26 2016
Picon

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

------------------------------------------------------------------------------
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
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Rehder, Patrick | 7 Jun 09:11 2016
Picon

autocompletion with table named "ORDER"

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
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Al Le | 3 Jun 10:00 2016
Picon
Picon

How do you set different session properties for different aliases?

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

------------------------------------------------------------------------------
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
Matthew Hebley | 20 May 02:58 2016

Installation SQuirreLSQL.sh on Mac El Capitan

I have just installed SQuirreL 3.7.1 on Mac after upgrading to El 
Capitan. (I don't think the OS version is relevant, only that Java was 
removed.)

I had version snapshot-20150221_2246 before the upgrade and seem to 
remember I had to install Apple JRE 1.6 to get it to go.

This time I wanted to get it to go using the standard Oracle install of 
Java 1.8

It would appear that SQuirreLSQL.sh needs double quotes around 
"$JAVACMD" because java is installed into a directory with a space in it.

line 25: # IZPACK_JAVA_HOME is filtered in by the IzPack installer when 
this script is installed
line 26: IZPACK_JAVA_HOME="/Library/Internet 
Plug-Ins/JavaAppletPlugin.plugin/Contents/Home"

line 75: "$JAVACMD" -cp "$UNIX_STYLE_HOME/lib/versioncheck.jar" 
JavaVersionChecker 1.6 1.7 1.8

line 111: "$JAVACMD" -Xmx256m -cp "$CP" $MACOSX_SQUIRREL_PROPS 
-splash:"$SQUIRREL_SQL_HOME/icons/splash.jpg" 
net.sourceforge.squirrel_sql.client.Main --log-config-file 
"$UNIX_STYLE_HOME"/log4j.properties --squirrel-home "$UNIX_STYLE_HOME" 
$NATIVE_LAF_PROP $SCRIPT_ARGS

Cheers

Matt

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
Don Barton | 12 May 04:40 2016
Picon

Cannot connect MSSQL

Well, it is solved!
Thank you for all your suggestions.  The actual answer was quite convoluted.
There is a dll that needed to be loaded in the Java bin directory that
allows for Windows Single Sign on (SSO).
The file is ntlmauth.dll.  This file comes with the jtds-1.3.1-dist from
SourceForge.

Regardless if  your OS is 64 bit or not, you need to use the version of
ntlmauth.dll that corresponds to your Java (32 or 64 bit) version.
So if you're running a 64 bit Windows, but Java is 32 bit, then you need
copy the ntlmauth.dll in the x86 folder to the Java bin under
C:\Program(x86)\Java\jreXX.XX\bin

Then remember not to use a username and password when logging on.  This
worked for a networked server at work, as well as a local server on my
computer at home.

Solved. It was well worth it for the query building capabilities in the
Squirrel if for nothing else!

It is interesting that two other clients; HeidiSQL, and DBeaver, didn't have
this problem at all and allowed me to connect immediately (hint, hinit??)

Don
------------------------------

Message: 3
Date: Tue, 10 May 2016 12:12:11 +0100
From: Neville Rowe <rowe_neville <at> hotmail.com>
Subject: Re: [Squirrel-sql-users] Cannot connect MSSQL
To: Don Barton <donaldb627 <at> gmail.com>
Cc: squirrel-sql-users <at> lists.sourceforge.net
Message-ID: <DUB404-EAS39264BF6FFF2AFF7E6B8E40EE710 <at> phx.gbl>
Content-Type: text/plain; charset="us-ascii"

Hi Don,
A quick check - have you got the driver loaded? I don't use the JTDS driver
but I just up that URL into Squirrel here and got that error.
Neville

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
Don Barton | 10 May 04:19 2016
Picon

Cannot connect MSSQL

I am trying to connect to a MSSQL server at work (testing environment), but
not able to connect to my server with the Squirrel.
I have downloaded DBeaver, and HeidiSQL, both of which have no problem
connecting to the MSSQL server.

With the DBeaver, I am using:
jdbc:jtds:sqlserver://xx.xx.xx.xxx.:1433/TESTDB.  HeidiSQL works as well
after just supplying the IP address.  

But when I use this connection string with the Squirrel, I get:

java.util.concurrent.ExecutionException: java.lang.RuntimeException:
java.sql.SQLException: Unable to create connection. Check your URL.

So I am not sure why it would work with 2 other clients, but not with the
Squirrel.  I really like this client, especially because of its SQL building
capabilities.
I've googled several times, each trying something a little different, but
not hitting on what I need to do to get Squirrel to work.  I tried many
variant of the connection string as well, all to no avail.

Don

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
Bram Gadeyne | 26 Apr 09:39 2016
Picon

using anonymous procedures


Hi,

Is there an option in Squirrel so that it would ignore the statement separator ; for code that is between “begin” and “end” statements?

I’d like to execute something like this code below against a Teiid JDBC connection but it fails.

begin
create local temporary table tmp_curresult(
res integer
);
LOOP ON (SELECT 1 as col1 union select 2) AS cur1
BEGIN
insert into tmp_curresult(res)
values(cur1.col1);
END
select * from tmp_curresult;
end;

I can see that squirrel only sends this part at first:

  begin
create local temporary table tmp_curresult(
res integer
)

With kind regards

--
Bram Gadeyne
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Markus Metz | 21 Apr 21:19 2016
Picon

SQuirrel connection problem to Postgres database

Dear all:

I am in the trouble shooting mode and need to start somewhere.So I am turning to you for some advice.
I searched the web and all what I tried did not work. So please bear with me:

I trying to access a database on a linux machine from a windows computer using SQuirrel:
postgres version 9.4.5
Squirrell version 3.7

However, I am getting the error message on SQuirrel:
This is the error message I am getting:

Java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: Connection to 10.2.44.27:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
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)

This is what I have done on the postgres front:
a) Changed postgresql.conf: listen_addresses = '*'
b) edited pg_hba.conf: host all all 127.0.0.1/32 trust
    host all all 0.0.0.0/0 trust
c) The server is running and listening at the correct port (5432) on the linux site:
   ps -efl | grep postgres
    netstat -nlp | grep postgres

In SQirrell I installed the postgres driver and created an alias defining
jdbc:postgresql://hostname/db

Do you happen to know what is going on?

Any input is highly appreciated,

Markus


------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
F21 | 20 Apr 05:05 2016
Picon

Possible to customize statement used for inserting rows?

Hi!

I've got Squirrel setup to use the Phoenix (phoenix.apache.org) driver 
and it works perfectly. However, I want to use the GUI to insert some data.

In phoenix, instead of INSERT into my_table VALUES(?), it uses UPSERT 
into my_table VALUES(?).

Is it possible to customize the insert statement so that it uses UPSERT 
instead of INSERT?

Thanks!
Francis

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z

Gmane