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
Alex Malmyguine | 3 Mar 17:17 2016
Picon

One of the reasons why I love Squirrel

If you tried to drag a SQL file attachment from Outlook into SSMS, you’d see a ‘do not enter’ cursor and the file would not open.

But if you dragged it into Squirrel, the file would open in the editor.

Kudos to Squirrel team and boo hoo to MS who with all their billions cannot offer consistency among their products.

 

Alex

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Joseph Dunleavy | 16 Feb 21:01 2016

squirrel-sql-3.7-standard.jar Redhat 7.2 install problem

I have Redhat 7.2 installed.

I downloaded jdk1.7.0_79 64 bit and squirrel-sql-3.7-standard.jar.

I add jdk1.7.0_79/bin to the PATH and try to run squirrel I receive an error about java.awt.Toolkit.

 

[root <at> ip-10-0-0-42 tmp]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 7.2 (Maipo)

 

[root <at> ip-10-0-0-42 tmp]# java -version

java version "1.7.0_79"

Java(TM) SE Runtime Environment (build 1.7.0_79-b15)

Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

 

[root <at> ip-10-0-0-42 tmp]# echo $PATH

/tmp/jdk1.7.0_79/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin

 

[root <at> ip-10-0-0-42 tmp]# ls -l

total 210912

drwxr-xr-x. 2 ec2-user ec2-user         6 Feb 16 14:47 hsperfdata_ec2-user

drwxr-xr-x. 2 root     root             6 Feb 16 14:58 hsperfdata_root

drwxrwxr-x. 2 ec2-user ec2-user      4096 Feb 16 14:36 jdbctest

drwxr-xr-x. 8       10      143      4096 Apr 10  2015 jdk1.7.0_79

-rwx------. 1 ec2-user ec2-user 153512879 Feb 16 14:05 jdk-7u79-linux-x64.tar.gz

drwxr-xr-x. 7 root     root          4096 Feb 16 13:44 jtds-1.3

-rwx------. 1 ec2-user ec2-user    551235 Feb 16 13:40 jtds-1.3.1-dist.zip

drwxr-xr-x. 4 root     root          4096 Dec  2 09:02 mysql-connector-java-5.1.38

-rwx------. 1 ec2-user ec2-user   4289879 Feb 16 13:41 mysql-connector-java-5.1.38.zip

-rwx------. 1 ec2-user ec2-user  57593968 Feb 16 14:48 squirrel-sql-3.7-standard.jar

 

[root <at> ip-10-0-0-42 tmp]# java -jar squirrel-sql-3.7-standard.jar

Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class java.awt.Toolkit

        at java.awt.Component.<clinit>(Component.java:595)

        at com.izforge.izpack.installer.GUIInstaller.showFatalError(Unknown Source)

        at com.izforge.izpack.installer.GUIInstaller.<init>(Unknown Source)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

        at java.lang.Class.newInstance(Class.java:379)

        at com.izforge.izpack.installer.Installer.main(Unknown Source)

 

 

My guess is I am missing required libraries or there is something wrong with the squirrel jar file for Linux.

Any help would be appreciated.

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Alex Malmyguine | 16 Feb 17:41 2016
Picon

LoadLibrary failed with error 87: The parameter is incorrect

Good morning:

 

Starting today (before a Java update 8.73 that I tried to install to fix the issue) whenever I start Squirrel the following dialogue pops up after 10-15 seconds:

 

 

When I hit OK Squirrel shuts down.

Any idea what is wrong?

 

Thank you!

Alex

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Gmane