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
(Continue reading)

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
(Continue reading)

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
(Continue reading)

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
Michael Schmid | 18 Apr 09:30 2016

Double-Click on table in objects view

Hello,

a double-click on a table in the Objects view does nothing. I'd expect
it to display the first [X] rows in the table. When i try to drag the
table from the Objects view to the "Info" tab, a plus sign appears, but
on release nothing happens. So my question is: is it possible to display
the contents of a table directly from the Objects view? Right now I have
to resort to a manual "SELECT * FROM table" in the SQL view, which is a
bit cumbersome. Any help is appreciated.

Kind Regards, Michael
------------------------------------------------------------------------------
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
Don Barton | 13 Apr 05:39 2016
Picon

Data Types as displayed

Greetings,

I have just downloaded Squirrel SQL and am trying to read the Data_Type  as displayed.  For example, TYPE_NAME is BIT, the DATA_TYPE is -7[BIT], or for DATE, the DATA_TYPE is displayed as 91[DATE].  What is the the -7 or the 91 indicate?

 

Thanks,

Don

------------------------------------------------------------------------------
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
James Mullaney | 4 Apr 14:56 2016

'int4' to datatype 'uint2' failed

Hi Folks

I am getting a ….

 

      java.sql.SQLException: [J0014] Return code is -402. [A046] The conversion from datatype 'int4' to datatype 'uint2' failed..

      java.lang.NullPointerException

 

 

error.   I know that it is baecause data types are slightly different.  Trouble is it gives me no indication where issue is coming from.

My WHERE clause…

 

      WHERE (c.PAT_PERSON_NUM    = 428896 )

 

Runs just fine.  But when I change the = sign to > is when I get the above error.   I suspect that the error

Is in another line  where a timestamp is compared to a quasi-timestamp folumn I have that does not have the same

Precision in the mantissa portion of the timestamp  0.0 vs. 0.000000.

 

Any suggestions ?  

 

Can I activate more verbose info in the run/error log window ?

 

Thanks

 

 

James

 

 

The information contained in this transmission contains privileged and confidential information. It is intended only for the use of the person named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

CAUTION: Intended recipients should NOT use email communication for emergent or urgent health care matters.

------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Stephen Davies | 31 Mar 03:13 2016
Picon

Driver parameters

I am testing a new release of the OpenText LCS JDBC driver.
This driver depends on some extra parameters.
If I use the ?param=value&param=value syntax on the URL, I get a connection 
but if I try setting the parameters via the Driver Parameters page in my 
Alias, the values seem to be ignored (I have checked the Use Parameters box).

Is there some trick to using the Driver Parameters page?

(Previous versions of this driver did not require extra parameters and work 
perfectly with Squirrel.)

Cheers and thanks,
Stephen
--

-- 
=============================================================================
Stephen Davies Consulting P/L                             Phone: 08-8177 1595
Adelaide, South Australia.                                Mobile:040 304 0583

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
Peter Howe | 8 Mar 17:36 2016

Content tab failes for jtds because column names not escaped

The Content tab is empty for some of the tables I am exploring - it appears to be because those tables have columns named with a reserved word and therefore need to have SQL Server square brackets around them - e.g. if the column name is 'key' then it needs to referred to as [key]
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://makebettercode.com/inteldaal-eval
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Gmane