John Hardin | 22 Jan 19:57 2016
Gravatar

Re: Autoreply: Re: {etc}

On Fri, 22 Jan 2016, amado.gonzalez <at> gft.com wrote:

> *** IMPORTANT INFORMATION ***
>
> Rule Financial is now part of the GFT Group.
> Our email addresses are in the form of firstname.surname <at> gft.com<mailto:firstname.surname <at> gft.com>
> Please update your address book, and use the new GFT address from now on.

Not sure if anyone on the list actually has administrative access, but can 
we get this guy unsubscribed, or get his subscription address updated?

--

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jhardin <at> impsec.org    FALaholic #11174     pgpk -a jhardin <at> impsec.org
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Where We Want You To Go Today 07/05/07: Microsoft patents in-OS
   adware architecture incorporating spyware, profiling, competitor
   suppression and delivery confirmation (U.S. Patent #20070157227)
-----------------------------------------------------------------------
  Tomorrow: John Moses Browning's 161st Birthday

------------------------------------------------------------------------------
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=267308311&iu=/4140

Copy PostgreSQL table to MySQL using the ONLY clause

I need to copy tables from PostgreSQL to MySQL, but I need Squirrel to add the ONLY clause to every SELECT statement that it performs against the PostgreSQL database.

Example: SELECT * FROM ONLY MY_TABLE

This is needed because I have descendant tables whose data I can't import into the destination database.

It is also necessary because if the SELECTs are performed without the ONLY clause, it will read data from descendant tables and some unique keys will be violated in the destination database.

Does anybody know how I can achieve this?
------------------------------------------------------------------------------
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=267308311&iu=/4140
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
William Nettmann | 25 Nov 14:58 2015
Picon

New Installation - SQuirreL not starting

​Hi,


I have just downloaded and installed the latest version of SQuirreL on my Fedora 22 workstation. When I run "squirrel-sql.sh" I get nothing - just a new line on the terminal. 


Anyone have any ideas how I can proceed? I need to do a project with SQL Server, and am hoping this will make my life a little easier.


Cheers,

Will

William Nettmann | Website Developer | Chevrah Kadisha 
Revenue Department, 85 George Avenue, Sandringham
t: +27114837474 m: +27823094007

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&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 | 17 Nov 21:35 2015
Picon

SOLVED??? RE: Scripting MS SQL 2012 stored procedure

If it helps anyone, here’s how I was able to debug the MS SQL plugin:

 

Built with ant,

Copied the plugin


\SquirrelSQL\squirrel-sql-git\sql12\output\dist\plugins\mssql.jar

 

to

 

\SquirrelSQL\plugins\mssql.jar

 

And now I can no longer reproduce the issue with either JTDS or MS JDBC drivers – both script the procedures just fine, both under debugger and in the installed SquirrelSQL instances.

The only thing I can blame would be memory pressure. For quite some time I was running very low on free RAM and guess that could cause the plugin to fail obtaining the SP source from the server.

If the line 70 of ScriptProcedureCommand.execute() would fail to obtain source, than and all the user would see would be GO as in my case.

The following few extra lines might hint the user at the problem:

 

                    int l = buf.length();

                    buf.append(MssqlIntrospector.getHelpTextForObject(MssqlIntrospector.getFixedVersionedObjectName(ti.getSimpleName()),conn));

                    if (buf.length() == l) {

                        buf.append("--Failed to obtain object source code from JDBC driver");

                    }

                    else {

                        buf.append("\n");

                        buf.append(sqlSep);

                        buf.append("\n\n");

                    }

 

Thank you

Alex

 

From: Alex Malmyguine
Sent: Friday, November 13, 2015 3:50 PM
To: Alex Malmyguine; Neville Rowe
Cc: squirrel-sql-users <at> lists.sourceforge.net
Subject: RE: [Squirrel-sql-users] Scripting MS SQL 2012 stored procedure

 

But now I have another question!

Even though the MSSql plugin sources were included into the project, the plugin does not seem to be built.

When Squirrel starts, the plugin list pointing at \SquirrelSQL\plugins where \SquirrelSQL is the main project folder, is empty.

I created the folder \SquirrelSQL\plugins, but how can I configure the project to output the plugin JAR in there?

 

Thank you

Alex

 

From: Alex Malmyguine
Sent: Friday, November 13, 2015 1:49 PM
To: Neville Rowe
Cc: squirrel-sql-users <at> lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] Scripting MS SQL 2012 stored procedure

 

Neville,

 

After comparing yours and mine it became apparent that your project included the individual JARs, whereas mine included the /lib/ folder (as instructed by the document linked earlier).

So it sounds like Netbeans 8 pretends it supports adding a folder as a library by pressing “Add JAR/folder” button, but in fact ignores so imported JARs.

I started adding the jars one by one instead and it worked! Ended up adding all JARs from the /lib/ folder and all errors became resolved.

 

Thank you

Alex

 

From: Neville Rowe [mailto:rowe_neville <at> hotmail.com]
Sent: Thursday, November 05, 2015 6:48 AM
To: Alex Malmyguine
Cc: squirrel-sql-users <at> lists.sourceforge.net
Subject: RE: [Squirrel-sql-users] Scripting MS SQL 2012 stored procedure

 

Hi Alex,

 

I also use netbeans for Squirrel and it works for me so I guess there is a difference in our setups. I'm on latest Netbeans and Squirrel.

 

I find the trick is to setup Netbeans to know about sql12/core/src and then just the one plugin I happen to be working on at the time.

 

I've enclosed my build.xml and my nbproject/project.xml - note my git checkout is to p:\NetBeansProjects\SquirrelSQL\git and my project root is p:\NetBeansProjects\SquirrelSQL.

 

It could be that for a free-form project in NetBeans, the classpath within NetBeans doesn't pick up from the build.xml - in which case the below error would be from the IDE (cannot find the libraries) rather than the ANT build? The project.xml I've attached sets up an appropriate java sources classpath, though you can set one yourself by going into Project Properties in the IDE.

 

Hope this helps.

 

Neville

From: alex.malmyguine <at> bluesun.ca
To:
squirrel-sql-users <at> lists.sourceforge.net
Date: Tue, 3 Nov 2015 23:03:54 +0000
Subject: Re: [Squirrel-sql-users] Scripting MS SQL 2012 stored procedure

I wanted to troubleshoot the issue below and checked out the source code from git, built with Ant successfully and created a project in Netbeans from the sources.

After I followed this http://squirrel-sql.sourceforge.net/index.php?page=programing and opened the directory core/src in Netbeans, I cannot compile due to an error stating the org.apache etc packages are not found.

But I can see the commons* packages in the project tree.

What am I doing wrong?

 

Thank you

Alex

 

From: Alex Malmyguine [mailto:alex.malmyguine <at> bluesun.ca]
Sent: Wednesday, October 28, 2015 10:51 AM
To:
squirrel-sql-users <at> lists.sourceforge.net
Subject: [Squirrel-sql-users] Scripting MS SQL 2012 stored procedure

 

Good morning,

 

Using version 3.6 with either MS JDBC 4.1 driver or JTDS 1.3.1 driver, I can list the stored procedures in a schema, then use popup menu/SQL server/Script procedure.

But it opens SQL tab with only a GO statement on the 2nd line in the editor. What am I doing wrong?

 

Thank you!

Alex


------------------------------------------------------------------------------
_______________________________________________ Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Trudy Moghaddm | 13 Nov 20:10 2015
Picon

Remove me

Please remove me from this group. We do not use Squirrel anymore so I do not want to receive these emails anymore

Thanks,

Trudy Moghaddam
------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
T K | 9 Nov 20:13 2015
Picon

Squirrel + Phoenix with Kerberos

Hello,

We are working on connecting to a secured hbase cluster using Phoenix driver and are having issues.

We've confirmed that a connectivity to a non kerberized cluster works fine. There is a dependency for kerberized connectivity on two config files

1) hbase-site.xml
2) core-site.xml

We've made sure that these two config files are co located under /usr/local/squirrel-sql-3.5.3/lib directory. However, connectivity is not established because squirrel is not able to read configs from these two external files.

Any suggestions on what we can do next here?

Squirrel Logs:

2015-11-07 04:37:23,156 [pool-1-thread-1] INFO  org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation  - getMaster attempt 1 of 35 failed; retrying after sleep of 100, exception=com.google.protobuf.ServiceException: java.io.IOException: Call to hdp213-1/10.22.10.153:60000 failed on local exception: java.io.IOException: Call id=35, waitTime=4
2015-11-07 04:37:23,261 [pool-1-thread-1] INFO  org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation  - getMaster attempt 2 of 35 failed; retrying after sleep of 200, exception=com.google.protobuf.ServiceException: java.io.IOException: Call to hdp213-1/10.22.10.153:60000 failed on local exception: java.io.IOException: Call id=36, waitTime=3
2015-1


Hbase Master Logs:

2015-11-05 23:57:25,292 DEBUG [RpcServer.listener,port=60000] ipc.RpcServer: RpcServer.listener,port=60000: connection from 10.22.8.67:34565; # active connections: 2
2015-11-05 23:57:25,293 DEBUG [RpcServer.reader=5,port=60000] ipc.RpcServer: RpcServer.listener,port=60000: Caught exception while reading:Authentication is required
2015-11-05 23:57:25,293 DEBUG [RpcServer.reader=5,port=60000] ipc.RpcServer: RpcServer.listener,port=60000: DISCONNECTING client 10.22.8.67:34565 because read count=-1. Number of active connections: 2

Thanks
-Tanvir
------------------------------------------------------------------------------
Presto, an open source distributed SQL query engine for big data, initially
developed by Facebook, enables you to easily query your data on Hadoop in a 
more interactive manner. Teradata is also now providing full enterprise
support for Presto. Download a free open source copy now.
http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
John Hardin | 28 Oct 17:45 2015
Gravatar

Squirrel with Focus Follows Mouse under Windows?

Folks:

I've enabled Focus Follows Mouse on my Windows desktop and it works...

...everywhere except Squirrel.

Does anybody know how to get Squirrel (or perhaps any Java app on Windows, 
I don't know whether the problem is in Squirrel or Java) to do FFM on 
Windows?

Thanks!

--

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jhardin <at> impsec.org    FALaholic #11174     pgpk -a jhardin <at> impsec.org
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   ...the Fates notice those who buy chainsaws...
                                               -- www.darwinawards.com
-----------------------------------------------------------------------
  3 days until Halloween

------------------------------------------------------------------------------
Alex Malmyguine | 28 Oct 15:50 2015
Picon

Scripting MS SQL 2012 stored procedure

Good morning,

 

Using version 3.6 with either MS JDBC 4.1 driver or JTDS 1.3.1 driver, I can list the stored procedures in a schema, then use popup menu/SQL server/Script procedure.

But it opens SQL tab with only a GO statement on the 2nd line in the editor. What am I doing wrong?

 

Thank you!

Alex

------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Blair Miller | 20 Oct 18:00 2015
Picon

Upgraded Mac OSX get Java error

Hi:

Think this happened before but cannot remember fix. I upgraded my Mac 
OSX to El Capitain (10.11) and now Squirrel gives the error:

"To use the "java" command-line tool you need to install a JDK"

The "More Info" button takes me to the Java SDK for Mac site, which I 
install (version 8 update 60) but no joy. Tried rebooting Mac. Tried 
upgrading Squirrel to 3.7.

What is the magic fix here?

Thanks,

------------------------------------------------------------------------------
Tom Verweij | 1 Oct 13:14 2015
Picon

Fwd: Fwd: In 3.7 Ctrl-/ (shortcut to line uncomment) is broken


---------- Forwarded message ----------
From: Tom Verweij <tomverweij <at> gmail.com>
Date: Thu, Oct 1, 2015 at 1:14 PM
Subject: Re: [Squirrel-sql-users] Fwd: In 3.7 Ctrl-/ (shortcut to line uncomment) is broken
To: Gerd Wagner <gerdhwagner <at> t-online.de>


Tx Gerd,

Too bad. I'll keep 3.6 and 3.7 both on my system until further notice.

If somebody out here can tell me how to bind the "Single Line Comment" to Ctrl-Slash, much appreciated! 

Cheers
Tom


On Sat, Sep 26, 2015 at 11:17 PM, Gerd Wagner <gerdhwagner <at> t-online.de> wrote:
Sorry Tom,

I have to admit that after some time of trying I couldn't get ctrl slash to work either. It would probably require a closer look at RSyntax.

Since I can't find any trace in our Git repository that CTRL SLASH has ever been the short cut for comment but ever was CTRL SUBSTRACT I don't consider it a bug.


Gerd




Am 25.09.2015 um 13:27 schrieb Tom Verweij:
Hi Gerd!

Thx for your reply and many thx for your work on Squirrel.
I've tried some of the things you wrote but still no luck getting my
favourite shortcut CTRL SLASH going again.
Obviously it's not the biggest thing but it something seems odd and I
want to learn more about Java anyway.

So here's my symptom and what I've tried sofar. I would really
appreciate it if you gave it a closer look.

Symptom:
(this is seen on a Lenovo T440P Thinkpad but also on other laptops)
When running the 3.7 squirrel-sql.jar and plugin jars simulaneously with
the 3.6 ones against exactly the same .squirrel home (so all prefs /
drivers / aliases are identical) the following behaviour can be seen:
- when editing in the 3.7   one CANNOT toggle commenting a single line
using CTRL SLASH (not from numpad, but the one below "QUESTIONMARK")
- in 3.6 one CAN

What I tried:
Changing the SyntaxPluginResources.properties in the syntax.jar to
menuitem.net.sourceforge.squirrel_sql.plugins.syntax.CommentAction.accelerator=control
SLASH    (also tried control /)
#menuitem.net.sourceforge.squirrel_sql.plugins.syntax.CommentAction.accelerator=control
SUBTRACT

I'm wondering if this CommentAction isn't a different one because it
comments a complete block instead of a single line, to my understanding.

What puzzles me is that I can't find the ONE LINE comment/uncomment
functionality in the menu, nor the Ctrl-T popuplist. But I somehow found
it and got very used to it (as you may imagine).

Could I help myself to it again? E.g. I noticed below sentence in the
above mentioned properties file:
# Ugly but true: the accelerators are duplicated in
SQLSettingsInitializer.squirrelKeyBindings

Could you give me a clear straightforward tip on this?

Thanks a bundle!

Tom

On Mon, Sep 21, 2015 at 9:19 PM, Gerd Wagner <gerdhwagner <at> t-online.de
<mailto:gerdhwagner <at> t-online.de>> wrote:



    Am 21.09.2015 um 00:47 schrieb Tom Verweij:

        Hi there,

        Ctrl-Slash - toggle comment on a line    --- is no more!


    I'm pretty sure the short key for comment has not changed. It is
    ctrl - Num-block substract.

    And ctrl- shift - Num-block substract to uncomment.


        Am I the only one experiencing this shortcut I'm very fond off,
        to be
        broken?
        Just checked, works fine until 3.6 but in 3.7 it's not anymore.
        And the sad part is, I can't seem to find a decent complete list
        of all
        shortcuts, including this one, online! As a long time user I
        must have
        picked this one up somehow?
        I'm confused ;-)


    Many of the short cuts can be found in the tools popup and right
    mouse menu of the SQL editor. Other can be picked from the menus.




    On a lower level you can look at the properties files that are
    included in your installation and can be found in our Git
    repository. For SQuirreL's core the URL is
    http://sourceforge.net/p/squirrel-sql/git/ci/master/tree/sql12/core/src/net/sourceforge/squirrel_sql/client/resources/squirrel.properties

    E.g. for the Syntax plugin the properties file is
    http://sourceforge.net/p/squirrel-sql/git/ci/master/tree/sql12/plugins/syntax/src/net/sourceforge/squirrel_sql/plugins/syntax/SyntaxPluginResources.properties

    It is technically possible to even change shortcuts by extracting
    properties files from Jars editing and repacking them. Care should
    be taken doing this. It is error prone and may lead to conflicting
    shortcuts.


    Hope this helps

    Gerd





------------------------------------------------------------------------------



_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users



------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
John Hardin | 29 Sep 19:35 2015
Gravatar

Current updates repository?

Squirrel just popped up an "update is available" dialog, but it can't 
download files from sourceforge.net/projects/squirrel-sql/files/updates 
for the SNAPSHOT channel.

has the location for the updates repository changed? Or is the update not 
available at SF (yet)?

--

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jhardin <at> impsec.org    FALaholic #11174     pgpk -a jhardin <at> impsec.org
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Homeland Security: Specializing in Tactical Band-aids for Strategic
   Problems.                       -- Eric K. in Bruce Schneier's blog
-----------------------------------------------------------------------

------------------------------------------------------------------------------

Gmane