You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(9) |
Feb
(4) |
Mar
(20) |
Apr
(10) |
May
(5) |
Jun
(2) |
Jul
(10) |
Aug
(4) |
Sep
(15) |
Oct
(5) |
Nov
(8) |
Dec
(2) |
| 2003 |
Jan
(11) |
Feb
(5) |
Mar
(10) |
Apr
(20) |
May
(24) |
Jun
(13) |
Jul
(6) |
Aug
(5) |
Sep
(10) |
Oct
(10) |
Nov
(9) |
Dec
(7) |
| 2004 |
Jan
(4) |
Feb
(10) |
Mar
(5) |
Apr
(18) |
May
(18) |
Jun
(14) |
Jul
(24) |
Aug
(14) |
Sep
(6) |
Oct
(18) |
Nov
(5) |
Dec
(3) |
| 2005 |
Jan
(5) |
Feb
(1) |
Mar
(5) |
Apr
(10) |
May
(10) |
Jun
(16) |
Jul
(46) |
Aug
(36) |
Sep
(16) |
Oct
(11) |
Nov
(12) |
Dec
(29) |
| 2006 |
Jan
(33) |
Feb
(45) |
Mar
(42) |
Apr
(23) |
May
(23) |
Jun
(21) |
Jul
(19) |
Aug
(23) |
Sep
(17) |
Oct
(50) |
Nov
(74) |
Dec
(44) |
| 2007 |
Jan
(35) |
Feb
(18) |
Mar
(46) |
Apr
(25) |
May
(26) |
Jun
(24) |
Jul
(33) |
Aug
(4) |
Sep
(41) |
Oct
(43) |
Nov
(23) |
Dec
(42) |
| 2008 |
Jan
(26) |
Feb
(20) |
Mar
(21) |
Apr
(18) |
May
(28) |
Jun
(32) |
Jul
(25) |
Aug
(28) |
Sep
(27) |
Oct
(34) |
Nov
(16) |
Dec
(42) |
| 2009 |
Jan
(21) |
Feb
(36) |
Mar
(40) |
Apr
(51) |
May
(27) |
Jun
(13) |
Jul
(38) |
Aug
(40) |
Sep
(5) |
Oct
(14) |
Nov
(4) |
Dec
(7) |
| 2010 |
Jan
(16) |
Feb
(10) |
Mar
(38) |
Apr
(83) |
May
(27) |
Jun
(41) |
Jul
(57) |
Aug
(24) |
Sep
(14) |
Oct
(22) |
Nov
(28) |
Dec
(42) |
| 2011 |
Jan
(52) |
Feb
(13) |
Mar
(41) |
Apr
(14) |
May
(24) |
Jun
(14) |
Jul
(16) |
Aug
(15) |
Sep
(19) |
Oct
(20) |
Nov
(35) |
Dec
(48) |
| 2012 |
Jan
(30) |
Feb
(9) |
Mar
(33) |
Apr
(15) |
May
(13) |
Jun
(13) |
Jul
(57) |
Aug
(20) |
Sep
(18) |
Oct
(29) |
Nov
(28) |
Dec
(9) |
| 2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
| 2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
| 2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
| 2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
| 2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
| 2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
| 2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
| 2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
| 2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
(3) |
Nov
(3) |
Dec
|
| 2025 |
Jan
|
Feb
(5) |
Mar
(33) |
Apr
(8) |
May
(10) |
Jun
(7) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Shull, D. <Dan...@cm...> - 2014-09-03 19:35:30
|
Hi, In SQuirreL any way to run a query, then email the results to a specified distribution list? Any way to automate this using scripting, pugins etc? Any way to run a SQuirreL query from a cmd line, then redirect to sendmail? Use of sendmail assumes UNIX not sure the same can be done in Windows (I read someone built a Windows sendmail binary...)? Thanks, --Dan |
|
From: John H. <jh...@im...> - 2014-08-23 17:05:51
|
On Sat, 23 Aug 2014, John Hardin wrote: > On Fri, 22 Aug 2014, Alexandre Peshansky wrote: > >> Leonid, >> You can create as many aliases as you need - one for each database. >> Switching between tabs is even easier than jumping between databases and >> tables in the same tree - for me, at least. You do need to log in for >> each alias, though, but only to see the trees - multi-database queries >> run fine as long as you are logged into any of the databases. > > And if the databases are on the same server the dbname:schema:tablename > syntax works fine in any tab. Oops. I meant dbname.schema.tablename syntax of course. D'oh! -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- End users want eye candy and the "ooo's and aaaahhh's" experience when reading mail. To them email isn't a tool, but an entertainment form. -- Steve Lake ----------------------------------------------------------------------- Tomorrow: the 1935th anniversary of the destruction of Pompeii |
|
From: John H. <jh...@im...> - 2014-08-23 16:49:18
|
On Fri, 22 Aug 2014, Alexandre Peshansky wrote: > Leonid, > You can create as many aliases as you need - one for each database. > Switching between tabs is even easier than jumping between databases and > tables in the same tree - for me, at least. You do need to log in for > each alias, though, but only to see the trees - multi-database queries > run fine as long as you are logged into any of the databases. And if the databases are on the same server the dbname:schema:tablename syntax works fine in any tab. You don't get tab completion of schema elements, but oh, well. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- The Constitution is a written instrument. As such its meaning does not alter. That which it meant when adopted, it means now. -- U.S. Supreme Court SOUTH CAROLINA v. US, 199 U.S. 437, 448 (1905) ----------------------------------------------------------------------- Tomorrow: the 1935th anniversary of the destruction of Pompeii |
|
From: Mironov, L. {BIS} <Leo...@pe...> - 2014-08-22 04:55:39
|
Yes, setting the default catalog makes life much easier - thanks for the
tip, but I still can see tables of only one database at a time which
makes writing multiple-database queries a rather irksome experience. I
hoped that local refresh from the right-click context menu for the
database, schema or TABLE object may bring the table list of the
non-default database into the object tree view, but no such luck.
From: Alex Malmyguine [mailto:ale...@wo...]
Sent: Thursday, August 21, 2014 5:01 PM
To: squ...@li...; Mironov, Leonid {BIS}
Subject: RE: [Squirrel-sql-users] cannot browse tables in multiple MS
SQLdatabases
Leonid,
I am still on 3.5.0 and I can Set Default Catalog on another database
and refresh tree and cache, and it would fetch the objects.
Give it a try. Hopefully that would be a lesser inconvenience. It looks
like Squirrel only fetches from default catalog.
Alex
From: Mironov, Leonid {BIS} [mailto:Leo...@pe...]
Sent: Thursday, August 21, 2014 6:05 AM
To: squ...@li...
Subject: [Squirrel-sql-users] cannot browse tables in multiple MS SQL
databases
Squirrel 3.5.3 on windows 7 with jtds 1.3.1 is used to connect to MS SQL
10 with several databases on the same server using AD authentication,
connection string is
'jdbc:jtds:sqlserver://address:1433/db;;integratedSecurity=true;authenti
cationScheme=JavaKerberos'. The problem is that with this connection
string I can browse tables (i.e. expand <database>.<schema>.TABLE in the
objects pane) only of the database specified in the connection string,
others are empty, and if I don't specify database name there I cannot
browse tables at all. All tables of all databases are still accessible
in SQL queries but having to remember tables and fields by heart is
rather trying, creating individual aliases for each of the databases is
only a little better. Is it possible to browse tables of multiple
databases?
|
|
From: Alex M. <ale...@wo...> - 2014-08-21 13:16:23
|
Leonid,
I am still on 3.5.0 and I can Set Default Catalog on another database and refresh tree and cache, and it would fetch the objects.
Give it a try. Hopefully that would be a lesser inconvenience. It looks like Squirrel only fetches from default catalog.
Alex
From: Mironov, Leonid {BIS} [mailto:Leo...@pe...]
Sent: Thursday, August 21, 2014 6:05 AM
To: squ...@li...
Subject: [Squirrel-sql-users] cannot browse tables in multiple MS SQL databases
Squirrel 3.5.3 on windows 7 with jtds 1.3.1 is used to connect to MS SQL 10 with several databases on the same server using AD authentication, connection string is 'jdbc:jtds:sqlserver://address:1433/db;;integratedSecurity=true;authenticationScheme=JavaKerberos'. The problem is that with this connection string I can browse tables (i.e. expand <database>.<schema>.TABLE in the objects pane) only of the database specified in the connection string, others are empty, and if I don't specify database name there I cannot browse tables at all. All tables of all databases are still accessible in SQL queries but having to remember tables and fields by heart is rather trying, creating individual aliases for each of the databases is only a little better. Is it possible to browse tables of multiple databases?
|
|
From: Mironov, L. {BIS} <Leo...@pe...> - 2014-08-21 10:07:27
|
Squirrel 3.5.3 on windows 7 with jtds 1.3.1 is used to connect to MS SQL 10 with several databases on the same server using AD authentication, connection string is 'jdbc:jtds:sqlserver://address:1433/db;;integratedSecurity=true;authenti cationScheme=JavaKerberos'. The problem is that with this connection string I can browse tables (i.e. expand <database>.<schema>.TABLE in the objects pane) only of the database specified in the connection string, others are empty, and if I don't specify database name there I cannot browse tables at all. All tables of all databases are still accessible in SQL queries but having to remember tables and fields by heart is rather trying, creating individual aliases for each of the databases is only a little better. Is it possible to browse tables of multiple databases? |
|
From: hany b. <bar...@gm...> - 2014-08-02 02:23:12
|
http://turkstationery.com/uzufitrq/ucouylvhhihsa.cynhlefsdhtdh hany bardissi 8/2/2014 2:56:15 AM |
|
From: David G <jam...@gm...> - 2014-08-01 01:40:47
|
Nah.. not that terrible. But the app is already full of things that help you do things quicker and easier. So why stop now? And it gets to be monotonous when you do it 100 times a day. Incidentally, it wouldn't be bad if it could be done one handed. But the keys are on opposite ends. I can easily make an AutoHotKey script to turn it into a one-key operation, but I didn't want to if it already existed. On Thu, Jul 31, 2014 at 3:53 PM, John Hardin <jh...@im...> wrote: > On Thu, 31 Jul 2014, David G wrote: > > 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? >> > > A single-key shortcut for that would save one keystroke. is [CTRL]-A > [CTRL]-[ENTER] really that terrible? :) > > -- > John Hardin KA7OHZ http://www.impsec.org/~jhardin/ > jh...@im... FALaholic #11174 pgpk -a jh...@im... > key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 > ----------------------------------------------------------------------- > ...much of our country's counterterrorism security spending is not > designed to protect us from the terrorists, but instead to protect > our public officials from criticism when another attack occurs. > -- Bruce Schneier > ----------------------------------------------------------------------- > 5 days until the 279th anniversary of John Peter Zenger's acquittal > |
|
From: David G. <da...@fr...> - 2014-08-01 01:36:01
|
Yeah, that works, but it makes the script harder to read and find your way in the code. I thought that DBAs and other devs would've really barked for this kind of feature, and that it surely is already in the product. Squirrel SQL works so well. I'm kinda mystified that such a basic and handy feature hasn't been worked in somehow. I guess I could put empty comment lines between queries as a work-around until (and if) someone comes forward with the shortcut or setting to make them all run together. Thanks for chiming in with a response, Alexandre! On Thu, Jul 31, 2014 at 3:12 PM, Alexandre Peshansky < Ale...@ei...> wrote: > Just don't separate them with empty lines. > Works for me in Sybase. > -- > Alexandre Peshansky, MS > Senior Bioinformatics Analyst, Research Informatics Core (RIC) > Einstein-Montefiore Institute for Clinical and Translational Research > (ICTR) > Albert Einstein College of Medicine > 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461 > (718) 430-2440 (Mo, Tu, Th, Fr) (718) 920-4885 (We) > > ------------------------------ > *From:* David Gardner [da...@fr...] > *Sent:* Thursday, July 31, 2014 3:08 PM > *To:* squirrel-sql-users > *Subject:* [Squirrel-sql-users] 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
|
From: John H. <jh...@im...> - 2014-07-31 19:53:36
|
On Thu, 31 Jul 2014, David G wrote: > 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? A single-key shortcut for that would save one keystroke. is [CTRL]-A [CTRL]-[ENTER] really that terrible? :) -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- ...much of our country's counterterrorism security spending is not designed to protect us from the terrorists, but instead to protect our public officials from criticism when another attack occurs. -- Bruce Schneier ----------------------------------------------------------------------- 5 days until the 279th anniversary of John Peter Zenger's acquittal |
|
From: Alexandre P. <Ale...@ei...> - 2014-07-31 19:12:43
|
Just don't separate them with empty lines. Works for me in Sybase. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Einstein-Montefiore Institute for Clinical and Translational Research (ICTR) Albert Einstein College of Medicine 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461 (718) 430-2440 (Mo, Tu, Th, Fr) (718) 920-4885 (We) ________________________________ From: David Gardner [da...@fr...] Sent: Thursday, July 31, 2014 3:08 PM To: squirrel-sql-users Subject: [Squirrel-sql-users] 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! |
|
From: David G <jam...@gm...> - 2014-07-31 19:12:33
|
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! |
|
From: David G. <da...@fr...> - 2014-07-31 19:09:23
|
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! |
|
From: Federico B. <fed...@gm...> - 2014-07-28 08:59:34
|
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 |
|
From: David <dgp...@ao...> - 2014-07-25 14:53:17
|
Wary users back up the $HOME/.squirrel-sql/ dir where your settings reside in case a file is overwritten. |
|
From: David <dgp...@ao...> - 2014-07-25 14:53:14
|
Wary users back up the $HOME/.squirrel-sql/ dir where your settings reside in case a file is overwritten. |
|
From: Herbener, M. - D. of E. a. M. <mar...@ed...> - 2014-07-24 13:44:49
|
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: 'squ...@li...' 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<http://www.facebook.com/kydeptofed> KDE on Twitter: twitter.com/KyDeptofEd |
|
From: Paul S. <ads...@tp...> - 2014-07-23 22:50:41
|
Hi Martin, I just run the install jar and everything is sweet. The only thing to look out for is the version number in the name of the 'program files' directory. The install jar is set to create a new one for each Squirrel version. I just remove the version number from the name so that each version goes into the same folder overwriting the last. Work for me! Win7-64 likes to put configuration files under individual user profiles. Squirrel SQL looks like it uses %USERPROFILE%\.squirrel-sql to hold all its settings, so overwriting the program files shouldn't affect this. HTH, Paul From: Herbener, Martin - Division of Engineering and Management [mailto:mar...@ed...] Sent: Thursday, 24 July 2014 2:53 AM To: squ...@li... Subject: [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: <http://www.facebook.com/kydeptofed> www.facebook.com/kydeptofed KDE on Twitter: twitter.com/KyDeptofEd |
|
From: Herbener, M. - D. of E. a. M. <mar...@ed...> - 2014-07-23 16:53:29
|
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<http://www.facebook.com/kydeptofed> KDE on Twitter: twitter.com/KyDeptofEd |
|
From: Wesley N. <We...@Ke...> - 2014-07-18 23:40:41
|
It works great! Thanks for the fix.
Best regards,
Wesley S. Newswanger
IT & Database Administrator
Keystone CollectionsT
by Martins
Office: 866.881.6680 ext. 1028
Fax: 877.517.8121
Email: we...@ke...
www.keystonecollections.com
-----Original Message-----
From: Gerd Wagner [mailto:ger...@t-...]
Sent: Friday, July 18, 2014 7:31 PM
To: Wesley Newswanger; squ...@li...
Subject: Re: [Squirrel-sql-users] Unexpected Error with snapshot-20140709_2314
The problem should be fixed in the new snapshot
http://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20140719_0104/
Unfortunately I don't have access to Pervasive. Please give it a try and
let me know if it works.
Thanks
Gerd
Am 17.07.2014 14:43, schrieb Wesley Newswanger:
> 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: we...@ke...
>
> 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
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
|
|
From: Gerd W. <ger...@t-...> - 2014-07-18 23:30:47
|
The problem should be fixed in the new snapshot http://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20140719_0104/ Unfortunately I don't have access to Pervasive. Please give it a try and let me know if it works. Thanks Gerd Am 17.07.2014 14:43, schrieb Wesley Newswanger: > 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: we...@ke... > > 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 > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Wesley N. <We...@Ke...> - 2014-07-17 12:43:58
|
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: we...@ke...
www.keystonecollections.com
|
|
From: Gerd W. <ger...@t-...> - 2014-06-21 07:33:11
|
Hi Jan, no, the Plugin interface does not yet support to do this. But I'm also sure that it wouldn't be hard to change the interface accordingly and implement the functionality in RDBMS specific Plugins. Please feel invited to do it (as well as anybody else reading this). You may either send patches of the changes to me or even better drop them here: http://sourceforge.net/p/squirrel-sql/patches/ Thanks Gerd Am 19.06.2014 10:46, schrieb jan_bar: > > 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 > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: jan_bar <her...@ya...> - 2014-06-19 08:46:36
|
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 |
|
From: mcg1103 <ma...@ma...> - 2014-05-21 17:29:13
|
When connecting to a postgres database (or any db for that matter) over an ssl tunnel, that is over the internet, it takes two or three minutes to connect and be ready to start initiating queries. Once connected everything is fine. I have tried to change the cache setup to not load all the schema info everytime I connect, but this sometimes has the reverse affect of taking longer or never finish connected. The databases I am connecting to have around 200 tables. I have found another tool that connects instantly but does not have all the fancy features of Squirrel. SQL Workbench, is also java based. Connects instantly and has some code completion features. We all still prefer Squirrel SQL but just would like it to initiate the connection faster... so Yes we would like our cake and want to eat it too. Thanks for any advice on how to use this excellent tool better! -Mark -- View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Slow-to-initiate-connection-over-tunnel-tp3365.html Sent from the Users mailing list archive at Nabble.com. |
