hany bardissi | 2 Aug 04:56 2014
Picon

hany bardissi

http://turkstationery.com/uzufitrq/ucouylvhhihsa.cynhlefsdhtdh















hany bardissi





8/2/2014 2:56:15 AM
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
David G | 31 Jul 21:12 2014
Picon

How to Run Whole Script at Once?

To Run a whole script/page of several queries...
Currently I'm doing a Select All, then a Ctrl - Enter.

Surely there's a single command/shortcut I could use?

Tried looking in Help and online, but no luck.

thanks!
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&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
David Gardner | 31 Jul 21:08 2014

How to Run Whole Script at Once?

To Run a whole script/page of several queries...
Currently I'm doing a Select All, then a Ctrl - Enter.

Surely there's a single command/shortcut I could use?

Tried looking in Help and online, but no luck.

thanks!
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&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
Federico Bruni | 28 Jul 10:59 2014
Picon

load only one schema in a DB2 database

Hi all

I've started using Squirrel to learn a bit of SQL.
I have a simple question that I can't figure out by myself. I'm connecting to a DB2 database which has several schemas, but I'm interested in querying only one. Currently I must specify the schema or I get an error. For example:

SELECT column FROM schema.table

works, while:

SELECT column FROM table

doesn't.

I'd like to set a certain schema to be the default to reduce the length of my SQL instructions.
IIUC I should change the properties of the alias. But I can load or not load _all_ the schemas; I cannot say "load only this schema and don't load the others". I'm missing something?

Thanks a lot in advance
Federico

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&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
David | 25 Jul 16:53 2014
Picon

Re: FW: Instructions for upgrading SQL Squirrel version?

Wary users back up the $HOME/.squirrel-sql/ dir where your settings reside in case a file is overwritten.
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
David | 25 Jul 16:53 2014
Picon

Re: FW: Instructions for upgrading SQL Squirrel version?

Wary users back up the $HOME/.squirrel-sql/ dir where your settings reside in case a file is overwritten.
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

FW: Instructions for upgrading SQL Squirrel version?

To any future readers – I got responses from one user who successfully installs new versions on top of the existing install, and another user that installs in a new directory each time.  I chose to install in a new directory and it worked for me; my existing driver config and aliases worked in the new version without any work on my part.

 

Thanks

 

Martin

 

From: Herbener, Martin - Division of Engineering and Management
Sent: Wednesday, July 23, 2014 12:53 PM
To: 'squirrel-sql-users <at> lists.sourceforge.net'
Subject: Instructions for upgrading SQL Squirrel version?

 

Hi,

 

I am getting ready to upgrade an existing SQL Squirrel 3.4.0 installation on 64-bit Windows 7 to the most current release of SQL Squirrel; are there any instructions I should follow to preserve driver settings, aliases, etc?

 

Thanks!

 

Martin

 

 

Martin Herbener

Kentucky Department of Education

502 564 2020

 

KDE on Facebook: www.facebook.com/kydeptofed

KDE on Twitter: twitter.com/KyDeptofEd

 

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Instructions for upgrading SQL Squirrel version?

Hi,

 

I am getting ready to upgrade an existing SQL Squirrel 3.4.0 installation on 64-bit Windows 7 to the most current release of SQL Squirrel; are there any instructions I should follow to preserve driver settings, aliases, etc?

 

Thanks!

 

Martin

 

 

Martin Herbener

Kentucky Department of Education

502 564 2020

 

KDE on Facebook: www.facebook.com/kydeptofed

KDE on Twitter: twitter.com/KyDeptofEd

 

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
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,
 
Wesley S. Newswanger
 IT & Database Administrator

Keystone CollectionsT 
         by Martin's Wood Products LLC

Office: 866.881.6680     ext. 1028
Fax:    877.517.8121
Email:  wesleyn <at> keystonecollections.com

www.keystonecollections.com

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
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

Gmane