Wesley Newswanger | 17 Jul 14:43 2014

Unexpected Error with snapshot-20140709_2314

I'm using Squirrel 3.53 to access a Pervasive database and it works great.

With snapshot-20140709_2314 I receive the following error:

Unexpected Error occurred attempting to open an SQL connection.

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NullPointerException
	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: java.lang.NullPointerException
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:175)
	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: java.lang.NullPointerException
	at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.<init>(SQLConnection.java:86)
	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:138)
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
	... 7 more

Best regards,
 
(Continue reading)

Rhonda Dupree | 26 Jun 15:47 2014

Progressive SQL Connection

Hi,

 

I am not familiar with Progressive PSQL database. We have installed new software package that uses Progressive. I would like to connect to it with my Squirrel SQL client. Do I need to create a new driver definition? Does anyone have an example to go by? I have tried searching with google and I am at a loss. The Progressive manual says I should use the pvjdbd2.jar driver. Thanks in advance for any insight.

 

R. Dupree

 

 

------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
jan_bar | 19 Jun 10:46 2014
Picon

Limiting result rows


Hi,

Squirrel SQL can limit rows in SQL result. My impression was that it 
automagically adds database related row limiting SQL commands such as 
LIMIT 10 for MSQ SQL and SELECT ... where ROWNUM <= 10 for Oracle. It is 
not the case, Squirrel uses Statement.setMaxRows() and javadoc says: 
Sets the limit for the maximum number of rows that any ResultSet object 
generated by this Statement object can contain to the given number. If 
the limit is exceeded, the excess rows are silently dropped.
So my question is - is there a plugin or something alike that can 
rewrite the selects with true limiting so average user will not kill db 
server with select *? Does the plugin architecture allow to write such 
plugin?

Kind regards, Jan

------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
Philippe Thibault | 9 May 15:55 2014
Picon

concat() in hex format

Hi,

How to prevent Squirrel SQL to show concat() of int data types as varbinary in hex format instead of plain text?

For example, SELECT CONCAT(1,2) shows the hex notation 3132 instead of "12" ...

Looking at the MetaData result tab shows that the resulting column type is VARBINARY. How can I force it to be plain text?

Someone pointed me to the CAST() function, which is working. But I find it a bit tedious to have to CAST() every concat() query I do, and wonder why hex format is preferred to plain text as default viewing option. As it is, the above query is showing in plain text in mysql-client shell command-line.

thanks!

Philippe
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
&#149; 3 signs your SCM is hindering your productivity
&#149; Requirements for releasing software faster
&#149; Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Max Squirrel | 8 May 10:24 2014
Picon

Connecting to Postgres database takes minutes

Hi,

When I am trying to connect to my Postgres database the first time after starting squirrel, it takes several minutes until it is done. Connecting to an AS2 database just takes 2 seconds or so.

When I am connecting to the Postgres via pgAdmin, the connection is also established within seconds.

Is there any way to tell why it takes the application so long to connect?

Max
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
&#149; 3 signs your SCM is hindering your productivity
&#149; Requirements for releasing software faster
&#149; Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
René A Valencourt | 25 Apr 21:30 2014

Re: Issues with DB2/AS400 v 7.1

Jim >> There are a whole host of jdbc properties which can effect the way the IBM system handles jdbc requests.

 

Jim >> http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzahh/javadoc/com/ibm/as400/micro/doc-files/JDBCProperties.html?resultof=%22%53%79%73%74%65%6d%22%20%22%73%79%73%74%65%6d%22%20%22%70%72%6f%70%65%72%74%69%65%73%3a%22%20%22%70%72%6f%70%65%72%74%69%22%20

 

Jim >> The one that changed is metadata source.  …change to 1 - Database metadata will be retrieved by calling system stored procedures in 7.1.

 

Jim >> Go into Alias properties, Driver Properties tab and specify the driver properties you want to use and the value you want to use, in this case 1.

 

Eric >> …I can now view the DB2/AS400  tables again using my Squirrel again.

 

Unfortunately, I changed the “metadata source” driver property to a value of ‘1’, and I still can’t view the table list.  I was using the Client Access driver from March 2012, but I just downloaded and registered with SQuirreL the March 2014 version 8.2 jt400.jar from the web site http://sourceforge.net/projects/jt400/ (the web page said it would be version 8.1), with the same result.

 

Now I just checked a Microsoft SQL Server connection, and see that I cannot expand any categories (such as “TABLE”) underneath a schema (such as “dbo”) within a SQL Server database, either.

 

So there must be some other setting that I have wrong?

 

René A Valencourt, CCP, MCTS
Senior Programmer/Analyst

IS Department

CTB, Inc.
A Berkshire Hathaway Company

 

From: Eric Gulatee [mailto:eric.gulatee <at> gmail.com]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: squirrel-sql-users <at> lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Jim,

 

Thank you for the pointer.  I can now view the DB2/AS400  tables again using my Squirrel again.  

Much appreciated.

 

Cheers,

Eric Gulatee

 

On Mon, Mar 3, 2014 at 3:44 PM, Jim It <jim_it <at> hotmail.com> wrote:

Eric,

 

There are a whole host of jdbc properties which can effect the way the IBM system handles jdbc requests.

 

 

The one that changed is metadata source.  The default setting was 0 - Database metadata will be retrieved through the Retrieve Object Information (ROI) data flow, but was change to 1 - Database metadata will be retrieved by calling system stored procedures in 7.1.

 

Go into Alias properties, Driver Properties tab and specify the driver properties you want to use and the value you want to use, in this case 1.

Jim


------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries.  Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

************************************************************ This message may contain privileged, confidential and/or trade secret information which is protected by law and is intended only for the addressee. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this message is strictly prohibited. If you have received this message in error, please immediately notify us, and permanently delete all copies of the message. Due to the nature of the Internet, e-mail messages are not secure and may be delayed or undelivered. Also, in accordance with CTB company policy, e-mail messages may be reviewed or retained by CTB employees in addition to or other than the intended recipient. This footnote also confirms that this email message has been swept by Postini for the presence of computer viruses. ************************************************************
------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
John Dempster | 18 Apr 14:08 2014

sql Charts and Dashboards

Hi,

I develop software that allows creating live charts and dashboards for sql databases:

A command line version and basic parts are all free, one thing we are considering doing is integrating with squirrel, ie. some kind of plugin that allows transferring a chart query across into a live dashboard. You can see similar functionality for a different IDE here if you click on the video link here: http://www.timestored.com/qstudio

I'm a big squirrel fan and am the one pushing in work for the plugin to be created. My boss has said to find out if any other squirrel users would be interested. Please contact me back direct if you are. It will really help make the case.

Thanks for a great pice of software.
John
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Pradeesh | 16 Apr 13:44 2014
Picon

Regarding ECCN for squirrel

All,

       To install the squirrel , my organization requires ECCN - Export Control Classification Number.  can someone help me to get this.

     Thanks in advance.

thanks
pradeesh

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Diego Naranjo | 4 Apr 18:56 2014

SQLAliases23.xml file

Hi!

I can’t seem to find the XML aliases file in the most recent version of SQuirreL. Are the aliases now stored in a different file? Are they finally encrypted or something?

 

Thanks in advance J

 

-------

Diego Naranjo Castillo

Programmer Analyst

CR Phone: (506) 22010184 / USA Phone: (207) 552-6677 Ext: 40084

Email: dnaranjo <at> llbean.com

 

------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Raffaele Sgarro | 1 Apr 09:53 2014
Picon

Starting SQuirreL connecting to dinamically generated alias

My application creates databases dinamically at runtime. To use Squirrel with those databases, I clone and modify a template alias, but this is quite annoying and error prone.

I wonder if there's a way for my program to start Squirrel and immediately make it connecting to an alias generated on the fly.

What I tried
I put my alias configuration in a file named SQLAliases23.xml in a newly created directory, and launched Squirrel with -settingsdir pointed to that directory. Unfortunately the program doesn't even start, and I'm not able to see any error message
------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Sunderlin, Mark | 31 Mar 14:42 2014

Having issues with Mac Install: Solution!

In  Squirrel-sql-users Digest, Vol 93, Issue 7, mark.sunderlin <at> teamaol.com (I) wrote:
----------------------------------------------------------------------
>In Squirrel-sql-users Digest, Vol 93, Issue 6, Brenda Bell <bb31l <at> theotherbell.com> wrote:
>>I previously installed 3.5.0 and it was working. I downloaded the 3.5.2 installer, installed it and it
won?t launch ? double-click the app, the icon pops up and the app immediately shuts down.
>>I'm installing on Mac OS X 10.8.5. There are messages in my console that say this:
>No ideas, but I am having the exact same issue.  I ran squirrel.sh directly from the terminal and here is the
java exception I got:

I had installed JRE 1,7, as squirrel calls for, but it seems the JRE 1.7 install doesn't properly update the
link, /usr/bin/java, to the new 1.7 java binary.  It is now in a different directory from where the 1.6
binary is installed, but even after installing JRE 1.7, /usr/bin/java still points to 1.6.  A 'java
--version' returns 1.6, even though the java console shows 1.7 installed.  This link has a more detailed
explanation of the how JRE 1.7 got it wrong and has several ideas on how to hack a fix:
http://stackoverflow.com/questions/12757558/installed-java-7-on-mac-os-x-but-terminal-is-still-using-version-6 .

However, my simpler fix was to update from JRE 1.7 to JDK 1.8 and all is well. (That is, JDK 1.8 properly
updated the link at /usr/bin/java to point to the 1.8 java binary).  Squirrel runs just fine now!

p.s. No, I don't know if just installing the 1.8 JRE will also fix.  I lave that as an exercise for the reader. :-)
--
Mark E. Sunderlin
Data Architect // AOL Platforms
P: 703-265-6935 // C: 540-327-6222 // 22000 AOL Way,  Dulles, VA  20166
AIM: MESunderlin

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

Gmane