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
(12) |
Oct
(9) |
Nov
(2) |
Dec
|
|
From: Wesley N. <We...@Ke...> - 2017-03-03 15:11:14
|
I am running into a weird problem with Squirrel snapshot 20170214_2214 causing my columns to double in my Pervasive database.
If I run a simple Select * from query on a table it adds a whole set of duplicate columns. The duplicate columns do not show in the query. After this happens I get the following error when attempting to link in MS Access - 'Cannot define field more than once'. Squirrel shows the column names twice.
Here is an example of table schema from Pervasive before and after running a query.
/* ==========================================
* TABLE: INVENTORY_COST
* ========================================== */
CREATE TABLE "INVENTORY_COST"(
"PART" CHAR(20),
"LOCN" CHAR(2),
"COST" NUMERIC(16,6),
"MATL" NUMERIC(16,6),
"LABOR" NUMERIC(16,6),
"OVHD" NUMERIC(16,6),
"OUTS" NUMERIC(16,6),
"FREIGHT" NUMERIC(16,6),
"OTH" NUMERIC(16,6),
"CHG_DATE" DATE,
"CHG_TIME" TIME,
"CHG_BY" CHAR(8),
"CHG_PGM" CHAR(8),
"FILLER" CHAR(30));
CREATE UNIQUE NOT MODIFIABLE INDEX "INVENTORY_COSTK00" USING 0 ON "INVENTORY_COST"("PART", "LOCN");
/* ==========================================
* TABLE: INVENTORY_COST
* ========================================== */
CREATE TABLE "INVENTORY_COST"(
"PART" CHAR(20),
"LOCN" CHAR(2),
"COST" NUMERIC(16,6),
"MATL" NUMERIC(16,6),
"LABOR" NUMERIC(16,6),
"OVHD" NUMERIC(16,6),
"OUTS" NUMERIC(16,6),
"FREIGHT" NUMERIC(16,6),
"OTH" NUMERIC(16,6),
"CHG_DATE" DATE,
"CHG_TIME" TIME,
"CHG_BY" CHAR(8),
"CHG_PGM" CHAR(8),
"FILLER" CHAR(30),
"column0" CHAR(20),
"column1" CHAR(2),
"column2" NUMERIC(16,6),
"column3" NUMERIC(16,6),
"column4" NUMERIC(16,6),
"column5" NUMERIC(16,6),
"column6" NUMERIC(16,6),
"column7" NUMERIC(16,6),
"column8" NUMERIC(16,6),
"column9" DATE,
"column10" TIME,
"column11" CHAR(8),
"column12" CHAR(8),
"column13" CHAR(30));
CREATE UNIQUE NOT MODIFIABLE INDEX "INVENTORY_COSTK00" USING 0 ON "INVENTORY_COST"("PART", "LOCN");
Best Regards,
Wesley S. Newswanger<http://w3w.cm/today.astounding.equals> IT & Database Administrator
Keystone Collections(tm)
Office: 866.881.6680 ext. 1028
Email: we...@ke... <mailto:we...@ke...>
[cid:image001.gif@01D29401.8C65B6C0]<http://www.keystonecollections.com/>
|
|
From: John H. <jh...@im...> - 2017-02-25 20:22:54
|
On Sat, 25 Feb 2017, John Hardin wrote: > (2) write some SQL to create a work table (e.g. t_pasta) with one column of > > SELECT pasta FROM menu WHERE pasta IN (SELECT pasta FROM t_pasta_file); Oop - apologies for the editing error there, it should of course be: SELECT pasta FROM menu WHERE pasta IN (SELECT pasta FROM t_pasta); -- 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 ----------------------------------------------------------------------- Insofar as the police deter by their presence, they are very, very good. Criminals take great pains not to commit a crime in front of them. -- Jeffrey Snyder ----------------------------------------------------------------------- 432 days since the first successful real return to launch site (SpaceX) |
|
From: John H. <jh...@im...> - 2017-02-25 20:21:27
|
On Fri, 24 Feb 2017, Federico Bruni wrote: > I wonder if I can tell Squirrel to take a list of items from a CSV file. > I'd like to have a query which works like this (pseudocode): > > SELECT pasta FROM menu WHERE pasta IN :csvfile > > and the CSV file may contain the items I want to use to filter the > query, such as: > > pesto;tomato;butter > > Perhaps there's a plugin for this purpose? > > I don't want to type each item interactively, as I could do with > sqlparam plugin. > And I don't want to edit my saved query (under version control) each > time I want to run a new query. > > Thanks in advance > Federico There is a data import plugin but it's not scriptable (as far as I know - I don't use it myself). Is it acceptable to pop a UI and type in the filename and some other details every time you want to do that? If that's acceptable then how about this: (1) create your data file with one value per line rather than multiple delimited values on one line. (2) write some SQL to create a work table (e.g. t_pasta) with one column of the correct datatype. A session-temporary table (e.g. MSSQL #t_pasta) may or may not work depending on JDBC connection pooling, so you might need to use a "permanent" temporary table (i.e. one you have to explicitly drop when you're finished with it). (3) run the data import plugin to populate that table with your data file. (4) write your query to do this: SELECT pasta FROM menu WHERE pasta IN (SELECT pasta FROM t_pasta_file); (5) remember to drop t_pasta when you're finished with it if it's not a true session-temporary table. You wouldn't have to type in the data (you do have to type in the filename and some other info to load the data, but that shouldn't change from session to session assuming whatever is generating the data file puts it in the same place every time), and your SQL script can be read-only. You might want to go to the Squirrel-SQL bug tracker at SourceForge and create a feature request for adding scriptability to the data import plugin so that the interactive part of the above could be eliminated. -- 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 ----------------------------------------------------------------------- Insofar as the police deter by their presence, they are very, very good. Criminals take great pains not to commit a crime in front of them. -- Jeffrey Snyder ----------------------------------------------------------------------- 432 days since the first successful real return to launch site (SpaceX) |
|
From: Federico B. <fe...@in...> - 2017-02-24 16:10:27
|
Hi all I wonder if I can tell Squirrel to take a list of items from a CSV file. I'd like to have a query which works like this (pseudocode): SELECT pasta FROM menu WHERE pasta IN :csvfile and the CSV file may contain the items I want to use to filter the query, such as: pesto;tomato;butter Perhaps there's a plugin for this purpose? I don't want to type each item interactively, as I could do with sqlparam plugin. And I don't want to edit my saved query (under version control) each time I want to run a new query. Thanks in advance Federico |
|
From: John H. <jh...@im...> - 2017-02-16 23:34:04
|
On Thu, 16 Feb 2017, Laffrey Lynne Marie (FCA) wrote: > With the semicolon at the end I get the following error message. > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: > com.ibm.db2.jcc.am.SqlException: [jcc][1071][10615][3.67.26] Caught > java.security.InvalidAlgorithmParameterException while initializing > EncryptionManager. See attached Throwable for details. ERRORCODE=-4223, > SQLSTATE=null ...which is not a syntax error, so progress is being made. Wild guess: is your local Java runtime up-to-date? "Security Mechanism 13" might specify a recent crypto algorithm. See also: https://support.dbvis.com/support/discussions/topics/1000079566 You may need to download your Java runtime from IBM... This: http://stackoverflow.com/questions/10649009/java-security-invalidalgorithmparameterexception-while-initializing-encryptionma ...suggests that you might need some crypto initialization parameters in the JDBC connect string. I have no idea precisely how to do that, though, sorry. This has apparently been an issue for a while: https://sourceforge.net/p/squirrel-sql/bugs/998/ Here, do some digging: http://www.google.com/search?q=java.security.InvalidAlgorithmParameterException+while+initializing+EncryptionManager+db2 > From: Alex Malmyguine [mailto:ale...@bl...] > Sent: Thursday, February 16, 2017 5:45 PM > To: squ...@li... > Subject: Re: [Squirrel-sql-users] UDB databases using security mechanisms > > John Hardin just posted a few min ago that the driver requires the closing semicolon after =13; > > > From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...] > Sent: Thursday, February 16, 2017 5:40 PM > To: Alex Malmyguine; squ...@li...<mailto:squ...@li...> > Subject: RE: UDB databases using security mechanisms > > Hi Alex, > > I have tried both a colon and a semi-colon and receive the same error. When I look up the syntax, it only stops at database with nothing after it. This driver and url works for all my other UDB databases. This new one has added security to it and I can't connect. > > Sincerely, > Lynne Marie > > From: Alex Malmyguine [mailto:ale...@bl...] > Sent: Thursday, February 16, 2017 3:40 PM > To: squ...@li...<mailto:squ...@li...> > Subject: Re: [Squirrel-sql-users] UDB databases using security mechanisms > > Should it be a colon or semicolon before securityMechanism, or perhaps a question mark? > > > From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...] > Sent: Thursday, February 16, 2017 2:21 PM > To: squ...@li...<mailto:squ...@li...> > Subject: [Squirrel-sql-users] UDB databases using security mechanisms > > Hi, > > I need to connect to a UDB v10.5.2 AIX database using Squirrel. I'm using the IBM DB2 Universal type 4 driver. I get this error: > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][3.67.26] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000 > > I was told by the DBA that I would need to use securityMechanism=13 in my JDBC command, but when I try it in squirrel, I get this error: > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.67.26] Invalid database URL syntax: jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815 > > How do I pass the security mechanism parameter when using Squirrel? > > Sincerely, > > [FCA_Pantone_email] > _________________________________ > > Lynne Marie Laffrey > Data Engineer > > ICT Business Analytics > 1075 West Entrance Drive > Auburn Hills, MI 48326 > CIMS: 489-03-02 > > Phone: 248-838-4895 > Email: Lyn...@fc...<mailto:Lyn...@fc...> > > Be social follow, Business Intelligence and Analytics > > [http://files.softicons.com/download/system-icons/windows-8-metro-icons-by-dakirby309/png/512x512/Office%20Apps/SharePoint.png]<https://partners.chrysler.com/sites/smbusintl/SitePages/Home.aspx> > > The information contained in the e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delibering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. > > > -- 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 ----------------------------------------------------------------------- USMC Rules of Gunfighting #7: In ten years nobody will remember the details of caliber, stance, or tactics. They will only remember who lived. ----------------------------------------------------------------------- 6 days until George Washington's 285th Birthday |
|
From: Laffrey L. M. (FCA) <lyn...@fc...> - 2017-02-16 23:03:53
|
With the semicolon at the end I get the following error message.
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][1071][10615][3.67.26] Caught java.security.InvalidAlgorithmParameterException while initializing EncryptionManager. See attached Throwable for details. ERRORCODE=-4223, SQLSTATE=null
From: Alex Malmyguine [mailto:ale...@bl...]
Sent: Thursday, February 16, 2017 5:45 PM
To: squ...@li...
Subject: Re: [Squirrel-sql-users] UDB databases using security mechanisms
John Hardin just posted a few min ago that the driver requires the closing semicolon after =13;
From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...]
Sent: Thursday, February 16, 2017 5:40 PM
To: Alex Malmyguine; squ...@li...<mailto:squ...@li...>
Subject: RE: UDB databases using security mechanisms
Hi Alex,
I have tried both a colon and a semi-colon and receive the same error. When I look up the syntax, it only stops at database with nothing after it. This driver and url works for all my other UDB databases. This new one has added security to it and I can't connect.
Sincerely,
Lynne Marie
From: Alex Malmyguine [mailto:ale...@bl...]
Sent: Thursday, February 16, 2017 3:40 PM
To: squ...@li...<mailto:squ...@li...>
Subject: Re: [Squirrel-sql-users] UDB databases using security mechanisms
Should it be a colon or semicolon before securityMechanism, or perhaps a question mark?
From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...]
Sent: Thursday, February 16, 2017 2:21 PM
To: squ...@li...<mailto:squ...@li...>
Subject: [Squirrel-sql-users] UDB databases using security mechanisms
Hi,
I need to connect to a UDB v10.5.2 AIX database using Squirrel. I'm using the IBM DB2 Universal type 4 driver. I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][3.67.26] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000
I was told by the DBA that I would need to use securityMechanism=13 in my JDBC command, but when I try it in squirrel, I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.67.26] Invalid database URL syntax: jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815
How do I pass the security mechanism parameter when using Squirrel?
Sincerely,
[FCA_Pantone_email]
_________________________________
Lynne Marie Laffrey
Data Engineer
ICT Business Analytics
1075 West Entrance Drive
Auburn Hills, MI 48326
CIMS: 489-03-02
Phone: 248-838-4895
Email: Lyn...@fc...<mailto:Lyn...@fc...>
Be social follow, Business Intelligence and Analytics
[http://files.softicons.com/download/system-icons/windows-8-metro-icons-by-dakirby309/png/512x512/Office%20Apps/SharePoint.png]<https://partners.chrysler.com/sites/smbusintl/SitePages/Home.aspx>
The information contained in the e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delibering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message.
|
|
From: Alex M. <ale...@bl...> - 2017-02-16 22:44:41
|
John Hardin just posted a few min ago that the driver requires the closing semicolon after =13;
From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...]
Sent: Thursday, February 16, 2017 5:40 PM
To: Alex Malmyguine; squ...@li...
Subject: RE: UDB databases using security mechanisms
Hi Alex,
I have tried both a colon and a semi-colon and receive the same error. When I look up the syntax, it only stops at database with nothing after it. This driver and url works for all my other UDB databases. This new one has added security to it and I can't connect.
Sincerely,
Lynne Marie
From: Alex Malmyguine [mailto:ale...@bl...]
Sent: Thursday, February 16, 2017 3:40 PM
To: squ...@li...<mailto:squ...@li...>
Subject: Re: [Squirrel-sql-users] UDB databases using security mechanisms
Should it be a colon or semicolon before securityMechanism, or perhaps a question mark?
From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...]
Sent: Thursday, February 16, 2017 2:21 PM
To: squ...@li...<mailto:squ...@li...>
Subject: [Squirrel-sql-users] UDB databases using security mechanisms
Hi,
I need to connect to a UDB v10.5.2 AIX database using Squirrel. I'm using the IBM DB2 Universal type 4 driver. I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][3.67.26] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000
I was told by the DBA that I would need to use securityMechanism=13 in my JDBC command, but when I try it in squirrel, I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.67.26] Invalid database URL syntax: jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815
How do I pass the security mechanism parameter when using Squirrel?
Sincerely,
[FCA_Pantone_email]
_________________________________
Lynne Marie Laffrey
Data Engineer
ICT Business Analytics
1075 West Entrance Drive
Auburn Hills, MI 48326
CIMS: 489-03-02
Phone: 248-838-4895
Email: Lyn...@fc...<mailto:Lyn...@fc...>
Be social follow, Business Intelligence and Analytics
[http://files.softicons.com/download/system-icons/windows-8-metro-icons-by-dakirby309/png/512x512/Office%20Apps/SharePoint.png]<https://partners.chrysler.com/sites/smbusintl/SitePages/Home.aspx>
The information contained in the e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delibering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message.
|
|
From: Laffrey L. M. (FCA) <lyn...@fc...> - 2017-02-16 22:43:38
|
I get a syntax error with the below. -----Original Message----- From: John Hardin [mailto:jh...@im...] Sent: Thursday, February 16, 2017 4:47 PM To: Squirrel SQL users list <squ...@li...> Subject: [Sender Auth Failure] Re: [Squirrel-sql-users] UDB databases using security mechanisms On Thu, 16 Feb 2017, Alex Malmyguine wrote: > Should it be a colon or semicolon before securityMechanism, or perhaps a question mark? It looks like it needs to end with a semicolon: http://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_r0052342.html try jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13; > From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...] > > Hi, > > I need to connect to a UDB v10.5.2 AIX database using Squirrel. I'm using the IBM DB2 Universal type 4 driver. I get this error: > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: > com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: > [jcc][t4][201][11237][3.67.26] Connection authorization failure > occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, > SQLSTATE=28000 > > I was told by the DBA that I would need to use securityMechanism=13 in my JDBC command, but when I try it in squirrel, I get this error: > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: > com.ibm.db2.jcc.am.SqlSyntaxErrorException: > [jcc][10165][10051][3.67.26] Invalid database URL syntax: > jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13. > ERRORCODE=-4461, SQLSTATE=42815 > > How do I pass the security mechanism parameter when using Squirrel? -- 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 ----------------------------------------------------------------------- If asking Hillary to disarm is a call for her assassination, then asking the American people to disarm is calling for their genocide. -- Jeff Ingebritson ----------------------------------------------------------------------- 6 days until George Washington's 285th Birthday ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Laffrey L. M. (FCA) <lyn...@fc...> - 2017-02-16 22:39:54
|
Hi Alex,
I have tried both a colon and a semi-colon and receive the same error. When I look up the syntax, it only stops at database with nothing after it. This driver and url works for all my other UDB databases. This new one has added security to it and I can't connect.
Sincerely,
Lynne Marie
From: Alex Malmyguine [mailto:ale...@bl...]
Sent: Thursday, February 16, 2017 3:40 PM
To: squ...@li...
Subject: Re: [Squirrel-sql-users] UDB databases using security mechanisms
Should it be a colon or semicolon before securityMechanism, or perhaps a question mark?
From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...]
Sent: Thursday, February 16, 2017 2:21 PM
To: squ...@li...<mailto:squ...@li...>
Subject: [Squirrel-sql-users] UDB databases using security mechanisms
Hi,
I need to connect to a UDB v10.5.2 AIX database using Squirrel. I'm using the IBM DB2 Universal type 4 driver. I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][3.67.26] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000
I was told by the DBA that I would need to use securityMechanism=13 in my JDBC command, but when I try it in squirrel, I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.67.26] Invalid database URL syntax: jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815
How do I pass the security mechanism parameter when using Squirrel?
Sincerely,
[FCA_Pantone_email]
_________________________________
Lynne Marie Laffrey
Data Engineer
ICT Business Analytics
1075 West Entrance Drive
Auburn Hills, MI 48326
CIMS: 489-03-02
Phone: 248-838-4895
Email: Lyn...@fc...<mailto:Lyn...@fc...>
Be social follow, Business Intelligence and Analytics
[http://files.softicons.com/download/system-icons/windows-8-metro-icons-by-dakirby309/png/512x512/Office%20Apps/SharePoint.png]<https://partners.chrysler.com/sites/smbusintl/SitePages/Home.aspx>
The information contained in the e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delibering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message.
|
|
From: John H. <jh...@im...> - 2017-02-16 22:07:37
|
On Thu, 16 Feb 2017, Alex Malmyguine wrote: > Should it be a colon or semicolon before securityMechanism, or perhaps a question mark? It looks like it needs to end with a semicolon: http://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_r0052342.html try jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13; > From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...] > > Hi, > > I need to connect to a UDB v10.5.2 AIX database using Squirrel. I'm using the IBM DB2 Universal type 4 driver. I get this error: > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][3.67.26] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000 > > I was told by the DBA that I would need to use securityMechanism=13 in my JDBC command, but when I try it in squirrel, I get this error: > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.67.26] Invalid database URL syntax: jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815 > > How do I pass the security mechanism parameter when using Squirrel? -- 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 ----------------------------------------------------------------------- If asking Hillary to disarm is a call for her assassination, then asking the American people to disarm is calling for their genocide. -- Jeff Ingebritson ----------------------------------------------------------------------- 6 days until George Washington's 285th Birthday |
|
From: Alex M. <ale...@bl...> - 2017-02-16 21:21:29
|
Should it be a colon or semicolon before securityMechanism, or perhaps a question mark?
From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...]
Sent: Thursday, February 16, 2017 2:21 PM
To: squ...@li...
Subject: [Squirrel-sql-users] UDB databases using security mechanisms
Hi,
I need to connect to a UDB v10.5.2 AIX database using Squirrel. I'm using the IBM DB2 Universal type 4 driver. I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][3.67.26] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000
I was told by the DBA that I would need to use securityMechanism=13 in my JDBC command, but when I try it in squirrel, I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.67.26] Invalid database URL syntax: jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815
How do I pass the security mechanism parameter when using Squirrel?
Sincerely,
[FCA_Pantone_email]
_________________________________
Lynne Marie Laffrey
Data Engineer
ICT Business Analytics
1075 West Entrance Drive
Auburn Hills, MI 48326
CIMS: 489-03-02
Phone: 248-838-4895
Email: Lyn...@fc...<mailto:Lyn...@fc...>
Be social follow, Business Intelligence and Analytics
[http://files.softicons.com/download/system-icons/windows-8-metro-icons-by-dakirby309/png/512x512/Office%20Apps/SharePoint.png]<https://partners.chrysler.com/sites/smbusintl/SitePages/Home.aspx>
The information contained in the e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delibering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message.
|
|
From: Laffrey L. M. (FCA) <lyn...@fc...> - 2017-02-16 19:36:46
|
Hi,
I need to connect to a UDB v10.5.2 AIX database using Squirrel. I'm using the IBM DB2 Universal type 4 driver. I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][3.67.26] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000
I was told by the DBA that I would need to use securityMechanism=13 in my JDBC command, but when I try it in squirrel, I get this error:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.67.26] Invalid database URL syntax: jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815
How do I pass the security mechanism parameter when using Squirrel?
Sincerely,
[FCA_Pantone_email]
_________________________________
Lynne Marie Laffrey
Data Engineer
ICT Business Analytics
1075 West Entrance Drive
Auburn Hills, MI 48326
CIMS: 489-03-02
Phone: 248-838-4895
Email: Lyn...@fc...<mailto:Lyn...@fc...>
Be social follow, Business Intelligence and Analytics
[http://files.softicons.com/download/system-icons/windows-8-metro-icons-by-dakirby309/png/512x512/Office%20Apps/SharePoint.png]<https://partners.chrysler.com/sites/smbusintl/SitePages/Home.aspx>
The information contained in the e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delibering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message.
|
|
From: Neville R. <row...@ho...> - 2017-02-13 12:39:37
|
Hi - I’ve added in a template, once Gerd merges it, it will be in the subsequent snapshot. Neville > On 11 Feb 2017, at 22:42, Gerd Wagner <ger...@t-...> wrote: > > Hi JK, > > Neville is right. We only ship JDBC template definitions. > > @Neville, in case you need help adding the template please let me know. > > Gerd > > Am 09.02.2017 um 08:13 schrieb Neville Rowe: >> Hi JK, >> >> Thanks for the interest….. >> >> I’m not aware of any policy - Gerd or one of the more regular contributors might be able to help. However as a general rule I believe SquirrelSQL doesn’t ship with any JDBC drivers. What it does have is a bunch of JDBC templates so that if you add the jar containing the driver into the classpath then it will find that driver and and give examples how to define your connection, etc. >> >> Defining that template is straightforward, I’ll try to do it this weekend for your DB and commit it into the tree. >> >> What you might want to consider is developing a DB-specific plugin so that SquirrelSQL handles anything special about InfiniFlux. >> >> Neville >> >> >>> On 2 Feb 2017, at 07:42, JK <jk...@in...> wrote: >>> >>> Hi all, >>> >>> >>> Hope this email finds you well. >>> >>> First of all I find it difficult to find a right contact regarding this >>> request. So please feel free to toss this Email to a right person. >>> >>> My name is JK and I am a global marketing manager here in InfiniFlux. >>> We, InfiniFlux, are a DBMS provider which specializes in processing IoT >>> and Sensor data in real-time for IoT Gateway. >>> >>> While many of clients are using SQuirrel SQL client, we figured that it >>> would be great if we place our driver as a default driver in SQuirrel. >>> There are already a bunch of default drivers and we would like to be one >>> of default driver providers. Would you please how the procedure would be >>> and what would be required? >>> >>> We can provide all the info and drivers if required. >>> >>> >>> Thanks, >>> >>> >>> JK >>> >>> -- >>> InfiniFlux Co.,Ltd. JK KIM >>> 904 ACE Twin Tower II, Digital-ro 273, Guro-gu, Seoul, South Korea 08381 >>> T. 82-2-2109-5606 M. 82-10-3629-0662 >>> E. jk...@in... W. www.infiniflux.com >>> >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >>> _______________________________________________ >>> Squirrel-sql-users mailing list >>> Squ...@li... >>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> |
|
From: Gerd W. <ger...@t-...> - 2017-02-11 22:42:24
|
Hi JK, Neville is right. We only ship JDBC template definitions. @Neville, in case you need help adding the template please let me know. Gerd Am 09.02.2017 um 08:13 schrieb Neville Rowe: > Hi JK, > > Thanks for the interest….. > > I’m not aware of any policy - Gerd or one of the more regular contributors might be able to help. However as a general rule I believe SquirrelSQL doesn’t ship with any JDBC drivers. What it does have is a bunch of JDBC templates so that if you add the jar containing the driver into the classpath then it will find that driver and and give examples how to define your connection, etc. > > Defining that template is straightforward, I’ll try to do it this weekend for your DB and commit it into the tree. > > What you might want to consider is developing a DB-specific plugin so that SquirrelSQL handles anything special about InfiniFlux. > > Neville > > >> On 2 Feb 2017, at 07:42, JK <jk...@in...> wrote: >> >> Hi all, >> >> >> Hope this email finds you well. >> >> First of all I find it difficult to find a right contact regarding this >> request. So please feel free to toss this Email to a right person. >> >> My name is JK and I am a global marketing manager here in InfiniFlux. >> We, InfiniFlux, are a DBMS provider which specializes in processing IoT >> and Sensor data in real-time for IoT Gateway. >> >> While many of clients are using SQuirrel SQL client, we figured that it >> would be great if we place our driver as a default driver in SQuirrel. >> There are already a bunch of default drivers and we would like to be one >> of default driver providers. Would you please how the procedure would be >> and what would be required? >> >> We can provide all the info and drivers if required. >> >> >> Thanks, >> >> >> JK >> >> -- >> InfiniFlux Co.,Ltd. JK KIM >> 904 ACE Twin Tower II, Digital-ro 273, Guro-gu, Seoul, South Korea 08381 >> T. 82-2-2109-5606 M. 82-10-3629-0662 >> E. jk...@in... W. www.infiniflux.com >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: JK <jk...@in...> - 2017-02-10 01:42:08
|
Hi Neville, Thanks for taking time to write to us. I appreciate it a lot. I wonder if you need any information for you to define the template(e.i.,Driver Name, Class Name, Default Port, URL for driver... ). I can provide all of these if you require, so please let me know. Cheers, JK 2017-02-09 오후 4:13에 Neville Rowe 이(가) 쓴 글: > Hi JK, > > Thanks for the interest….. > > I’m not aware of any policy - Gerd or one of the more regular contributors might be able to help. However as a general rule I believe SquirrelSQL doesn’t ship with any JDBC drivers. What it does have is a bunch of JDBC templates so that if you add the jar containing the driver into the classpath then it will find that driver and and give examples how to define your connection, etc. > > Defining that template is straightforward, I’ll try to do it this weekend for your DB and commit it into the tree. > > What you might want to consider is developing a DB-specific plugin so that SquirrelSQL handles anything special about InfiniFlux. > > Neville > > >> On 2 Feb 2017, at 07:42, JK <jk...@in...> wrote: >> >> Hi all, >> >> >> Hope this email finds you well. >> >> First of all I find it difficult to find a right contact regarding this >> request. So please feel free to toss this Email to a right person. >> >> My name is JK and I am a global marketing manager here in InfiniFlux. >> We, InfiniFlux, are a DBMS provider which specializes in processing IoT >> and Sensor data in real-time for IoT Gateway. >> >> While many of clients are using SQuirrel SQL client, we figured that it >> would be great if we place our driver as a default driver in SQuirrel. >> There are already a bunch of default drivers and we would like to be one >> of default driver providers. Would you please how the procedure would be >> and what would be required? >> >> We can provide all the info and drivers if required. >> >> >> Thanks, >> >> >> JK >> >> -- >> InfiniFlux Co.,Ltd. JK KIM >> 904 ACE Twin Tower II, Digital-ro 273, Guro-gu, Seoul, South Korea 08381 >> T. 82-2-2109-5606 M. 82-10-3629-0662 >> E. jk...@in... W. www.infiniflux.com >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users -- InfiniFlux Co.,Ltd. JK KIM 904 ACE Twin Tower II, Digital-ro 273, Guro-gu, Seoul, South Korea 08381 T. 82-2-2109-5606 M. 82-10-3629-0662 E. jk...@in... W. www.infiniflux.com |
|
From: Neville R. <row...@ho...> - 2017-02-09 07:13:26
|
Hi JK, Thanks for the interest….. I’m not aware of any policy - Gerd or one of the more regular contributors might be able to help. However as a general rule I believe SquirrelSQL doesn’t ship with any JDBC drivers. What it does have is a bunch of JDBC templates so that if you add the jar containing the driver into the classpath then it will find that driver and and give examples how to define your connection, etc. Defining that template is straightforward, I’ll try to do it this weekend for your DB and commit it into the tree. What you might want to consider is developing a DB-specific plugin so that SquirrelSQL handles anything special about InfiniFlux. Neville > On 2 Feb 2017, at 07:42, JK <jk...@in...> wrote: > > Hi all, > > > Hope this email finds you well. > > First of all I find it difficult to find a right contact regarding this > request. So please feel free to toss this Email to a right person. > > My name is JK and I am a global marketing manager here in InfiniFlux. > We, InfiniFlux, are a DBMS provider which specializes in processing IoT > and Sensor data in real-time for IoT Gateway. > > While many of clients are using SQuirrel SQL client, we figured that it > would be great if we place our driver as a default driver in SQuirrel. > There are already a bunch of default drivers and we would like to be one > of default driver providers. Would you please how the procedure would be > and what would be required? > > We can provide all the info and drivers if required. > > > Thanks, > > > JK > > -- > InfiniFlux Co.,Ltd. JK KIM > 904 ACE Twin Tower II, Digital-ro 273, Guro-gu, Seoul, South Korea 08381 > T. 82-2-2109-5606 M. 82-10-3629-0662 > E. jk...@in... W. www.infiniflux.com > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: JK <jk...@in...> - 2017-02-08 01:40:01
|
Hi all, Hope this email finds you well. First of all I find it difficult to find a right contact regarding this request. So please feel free to toss this Email to a right person. My name is JK and I am a global marketing manager here in InfiniFlux. We, InfiniFlux, are a DBMS provider which specializes in processing IoT and Sensor data in real-time for IoT Gateway. While many of clients are using SQuirrel SQL client, we figured that it would be great if we place our driver as a default driver in SQuirrel. There are already a bunch of default drivers and we would like to be one of default driver providers. Would you please how the procedure would be and what would be required? We can provide all the info and drivers if required. Thanks, JK -- InfiniFlux Co.,Ltd. JK KIM 904 ACE Twin Tower II, Digital-ro 273, Guro-gu, Seoul, South Korea 08381 T. 82-2-2109-5606 M. 82-10-3629-0662 E. jk...@in... W. www.infiniflux.com |
|
From: Neville R. <row...@ho...> - 2017-02-02 08:33:03
|
From the readme within the plugin itself…. The Smarttools plugin adds the ability to help you with little routines on your database work. It includes the following modules: * Search null values in NOT NULL columns * Change data * Search missing indices and from here Create index or primary key You can use them by opening the session popup menu Effectively it adds a series of menu options to carry out quick analysis and modifications of the database. Note it is all based in Java - if you want to add new commands then I believe you need to code them in the plugin and recompile it. N. On 2 Feb 2017, at 02:41, Shannon Medlin <tek...@te...<mailto:tek...@te...>> wrote: Hello! I am installing your client for the first time and would like to know what the "Smart Tools" Plugin is for. I didn't see an explanation on your plugins webpage, so thought I might reach out here. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org<http://SlashDot.org>! http://sdm.link/slashdot _______________________________________________ Squirrel-sql-users mailing list Squ...@li...<mailto:Squ...@li...> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: JK <jk...@in...> - 2017-02-02 08:07:47
|
Hi all, Hope this email finds you well. First of all I find it difficult to find a right contact regarding this request. So please feel free to toss this Email to a right person. My name is JK and I am a global marketing manager here in InfiniFlux. We, InfiniFlux, are a DBMS provider which specializes in processing IoT and Sensor data in real-time for IoT Gateway. While many of clients are using SQuirrel SQL client, we figured that it would be great if we place our driver as a default driver in SQuirrel. There are already a bunch of default drivers and we would like to be one of default driver providers. Would you please how the procedure would be and what would be required? We can provide all the info and drivers if required. Thanks, JK -- InfiniFlux Co.,Ltd. JK KIM 904 ACE Twin Tower II, Digital-ro 273, Guro-gu, Seoul, South Korea 08381 T. 82-2-2109-5606 M. 82-10-3629-0662 E. jk...@in... W. www.infiniflux.com |
|
From: Shannon M. <tek...@te...> - 2017-02-02 03:08:37
|
Hello! I am installing your client for the first time and would like to know what the "Smart Tools" Plugin is for. I didn't see an explanation on your plugins webpage, so thought I might reach out here. |
|
From: John N. <joh...@ou...> - 2017-01-19 08:59:02
|
Hi, using V3.7.1. on windows 10. I have a grails H2 database running on Linux. I can connect to the db via dbconsole in a browser. It shows the tables that I have added and the entries in those tables via SQL statements. I have also connected to the same database via Squirrel. But I can not see the tables. If I try to run an sql command, I get an error as the table is not found. I know this is rather vague and probably pretty basic but what am I doing wrong? If there is further information required then please ask. Also, as an aside, during the tool installation, an entry is made in the start menu for running squirrel-sql.bat but this opens the file in an editor rather than actually runs it. And windows 10 does not seem to allow a right mouse to run script. |
|
From: Wesley N. <We...@Ke...> - 2017-01-11 15:41:55
|
Try changing the font at File > Global Preferences. Fonts tab, Other. Make sure Other is enabled. Best Regards, Wesley S. Newswanger IT & Database Administrator Keystone CollectionsT Office: 866.881.6680 ext. 1028 Email: we...@ke... www.keystonecollections.com -----Original Message----- From: Stepan RYBAR [mailto:xr...@se...] Sent: Wednesday, January 11, 2017 8:48 AM To: squ...@li... Subject: [Squirrel-sql-users] How to change font in Result Tab (table) to e. g. Arial Unicode MS for better Unicode support? Hello, can I ask You, how to change font in Result Tab (table)? I need to change it to "Arial Unicode MS" to be able to display as much as possible Unicode characters. I am able to change it for SQL Entry Area using menu -> File -> New Session Properties -> SQL -> SQL Entry Area -> Font. But I do not know how to do the same for Result Tab (for table displaying). I have already attached "-Dfile.encoding=UTF-8" inside ".\SQuirreLSQL-3.7.1\squirrel-sql.bat" file. When I copy characters (displayed as square) from Result Tab to SQL Entry Area, they are displayed fine, so I suppose, that it is not the problem of SQuirreL itself, but the font used for rendering Result Tab. For example "U+1E02 (7682)", one can see on "http://www.charbase.com/1e02-unicode-latin-capital-letter-b-with-dot-above". Thank You in advance for answer, Stepan ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Stepan R. <xr...@se...> - 2017-01-11 13:48:03
|
Hello, can I ask You, how to change font in Result Tab (table)? I need to change it to "Arial Unicode MS" to be able to display as much as possible Unicode characters. I am able to change it for SQL Entry Area using menu -> File -> New Session Properties -> SQL -> SQL Entry Area -> Font. But I do not know how to do the same for Result Tab (for table displaying). I have already attached "-Dfile.encoding=UTF-8" inside ".\SQuirreLSQL-3.7.1\squirrel-sql.bat" file. When I copy characters (displayed as square) from Result Tab to SQL Entry Area, they are displayed fine, so I suppose, that it is not the problem of SQuirreL itself, but the font used for rendering Result Tab. For example "U+1E02 (7682)", one can see on "http://www.charbase.com/1e02-unicode-latin-capital-letter-b-with-dot-above". Thank You in advance for answer, Stepan |
|
From: Björn S. <bjo...@gm...> - 2017-01-11 09:33:15
|
I just downloaded and installed the snapshot "squirrel-sql-snapshot-20161227_2119-standard". If I have an open session and want to close it over the contect menu "Close Session" or by hitting CTRL-F6 the session is closed but the session tabs (Objects, SQL) remain open. Any further attempt to close the session tab is not successful. If one afterwards attempts to close the session tab over the 'x' on the tab an error is logged, that the ISession is null (see attached log). The only way to close the session tab now is to close the application itself. The session tabs close as expected when one do it by ckicking the 'x' of the session tab directly or by kicking the mouse middle button (wheel). This providing one has not attempted closing as described above before. System setup: Windows 8.1 64 bit Java 1.8 Database connected is H2 Log attached Cheers Bjoern -- Björn Sundin Sarmenstorferstrasse 9A 5619 Büttikon Switzerland Tel: +41 (0)56 622 7154 Mobile: +41 (0)79 237 1618 -------------------------------------------------------------- Ferienhaus in Graubünden Informationen unter http://www.valmedel.ch -------------------------------------------------------------- |
|
From: Federico B. <fe...@in...> - 2017-01-09 11:17:30
|
It doesn't work either: 1. no icon in gnome-shell 2. cannot open the .ico file with Gnome image viewer. I get the error: "Invalid header in icon". Why not changing to .png? Il giorno mar 27 dic 2016 alle 21:28, Gerd Wagner <ger...@t-...> ha scritto: > Sorry, I can't reproduce the problem on my KDE desktop. But since > there seems to be a problem with icon compression you may try out the > following snapshot where the icon isn't compressed anymore. > > https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161227_2119/ > > Gerd > > > Am 24.12.2016 um 10:07 schrieb Federico Bruni: >> I've tried, but now no icon is displayed when I search or bookmark >> Squirrel. >> The desktop file still contains a link to the .ico file: >> >> Icon=/home/fede/usr/squirrel-sql-snapshot-20161223_2019/icons/acorn.ico >> >> I cannot open the acorn.ico file. The Gnome image viewer says >> "Compressed icons not supported". >> >> $ file usr/squirrel-sql-snapshot-20161223_2019/icons/acorn.ico >> usr/squirrel-sql-snapshot-20161223_2019/icons/acorn.ico: MS Windows >> icon >> resource - 1 icon, 256x256 with PNG image data, 512 x 512, >> 8-bit/color >> RGBA, non-interlaced, 32 bits/pixel >> >> >> >> Il giorno ven 23 dic 2016 alle 20:27, Gerd Wagner >> <ger...@t-...> ha scritto: >>> >>> The problem should be fixed. Could you please give >>> http://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161223_2019 >>> >>> a try. >>> >>> Thanks >>> Gerd >>> >>> Am 22.12.2016 um 17:02 schrieb Federico Bruni: >>>> Hi all >>>> >>>> In the last snapshots I've noticed the new crispy icon acorn.png >>>> However in Linux (Fedora, gnome-shell) I see the old acorn.ico >>>> when I >>>> search the application (and when I mark it as favorite) and I see >>>> the >>>> nice acorn.png when SquirrelSQL is running. Inconsistent behaviour. >>>> >>>> This is because the .desktop file generated during the installation >>>> contains the path to the .ico file. >>>> Can you change it to the .png file? >>>> >>>> [squirrel-sql-git (master)]$ git grep acorn\.ico >>>> archive/sql12/build/Unix_shortcutSpec.xml: >>>> iconFile="$INSTALL_PATH/icons/acorn.ico" >>>> archive/sql12/build/shortcutSpec.xml: >>>> iconFile="$INSTALL_PATH/icons/acorn.ico" >>>> archive/squirrel-sql/build/shortcutSpec.xml: >>>> iconFile="$INSTALL_PATH/icons/acorn.ico" >>>> sql12/core/doc/changes.txt:On Mac OS X the SQuirreL now uses the >>>> acorn >>>> icon instead of the default java coffee cup icon. >>>> sql12/installer/other/Unix_shortcutSpec.xml: >>>> iconFile="$INSTALL_PATH/icons/acorn.ico" >>>> sql12/installer/other/shortcutSpec.xml: >>>> iconFile="$INSTALL_PATH/icons/acorn.ico" >>>> >>>> >>>> As far as I can see in the freedesktop spec, PNG is the recommended >>>> bitmap format: >>>> >>>>> An icon file is an image that can be loaded and used as an icon. >>>>> The >>>>> supported image file formats are PNG, XPM and SVG. PNG is the >>>>> recommended bitmap format, and SVG is for vectorized icons. XPM is >>>>> supported due to backwards compability reasons, and it is not >>>>> recommended that new themes use XPM files. Support for SVGs is >>>>> optional. >>>> >>>> From: >>>> https://standards.freedesktop.org/icon-theme-spec/icon-theme-spec-latest.html >>>> >>>> >>>> Thanks >>>> Federico >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> >>>> Developer Access Program for Intel Xeon Phi Processors >>>> Access to Intel Xeon Phi processor-based developer platforms. >>>> With one year of Intel Parallel Studio XE. >>>> Training and support from Colfax. >>>> Order your platform today.http://sdm.link/intel >>>> _______________________________________________ >>>> Squirrel-sql-users mailing list >>>> Squ...@li... >>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >> >> |
