squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] Columns double when running a simple select table

[Wesley N. <We...@Ke...>]

It appears to have something to do with viewing and possible sorting on the table columns tab. Switching from one table to another with the columns tab open sometimes causes all the column data to be shown twice.

How this gets back into my Pervasive schema is something I have not been able to duplicate consistently. Sometimes it happens, but most times the schema is unchanged. I wish I could figure out a way to duplicate it consistently.

I restarted Squirrel and cannot get it to corrupt the tables. I am going to dig into it further on my end. We did just do a major software update and possibly they had something wrong in there update process.

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@01D29411.916F96D0]<http://www.keystonecollections.com/>
From: Wesley Newswanger
Sent: Friday, March 03, 2017 9:47 AM
To: 'Squ...@li...' <Squ...@li...>
Subject: Columns double when running a simple select table

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@01D29411.916F96D0]<http://www.keystonecollections.com/>

Re: [Squirrel-sql-users] Columns double when running a simple select table

[John H. <jh...@im...>]

On Fri, 3 Mar 2017, Wesley Newswanger wrote:

> If I run a simple Select * from query on a table it adds a whole set of duplicate columns.

> Here is an example of table schema from Pervasive before and after running a query.

{snip}

Just to be clear about what you're saying: running a SELECT query in 
Squirrel causes the table schema in the database to be modified?


-- 
  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
-----------------------------------------------------------------------
   Taking my gun away because I *might* shoot someone is like cutting
   my tongue out because I *might* yell "Fire!" in a crowded theater.
                                                   -- Peter Venetoklis
-----------------------------------------------------------------------
  10 days until Albert Einstein's 138th Birthday

[Squirrel-sql-users] Columns double when running a simple select table

[Wesley N. <We...@Ke...>]

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/>

Re: [Squirrel-sql-users] feed a CSV file into a IN statement

[John H. <jh...@im...>]

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)

Re: [Squirrel-sql-users] feed a CSV file into a IN statement

[John H. <jh...@im...>]

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)

[Squirrel-sql-users] feed a CSV file into a IN statement

[Federico B. <fe...@in...>]

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

Re: [Squirrel-sql-users] UDB databases using security mechanisms

[John H. <jh...@im...>]

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

Re: [Squirrel-sql-users] UDB databases using security mechanisms

[Laffrey L. M. (FCA) <lyn...@fc...>]

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.

Re: [Squirrel-sql-users] UDB databases using security mechanisms

[Alex M. <ale...@bl...>]

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.

Re: [Squirrel-sql-users] [Sender Auth Failure] Re: UDB databases using security mechanisms

[Laffrey L. M. (FCA) <lyn...@fc...>]

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

Re: [Squirrel-sql-users] UDB databases using security mechanisms

[Laffrey L. M. (FCA) <lyn...@fc...>]

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.

Re: [Squirrel-sql-users] UDB databases using security mechanisms

[John H. <jh...@im...>]

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

Re: [Squirrel-sql-users] UDB databases using security mechanisms

[Alex M. <ale...@bl...>]

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.

[Squirrel-sql-users] UDB databases using security mechanisms

[Laffrey L. M. (FCA) <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?

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.

Re: [Squirrel-sql-users] default driver provider

[Neville R. <row...@ho...>]

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
>> 

Re: [Squirrel-sql-users] default driver provider

[Gerd W. <ger...@t-...>]

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
>

Re: [Squirrel-sql-users] default driver provider

[JK <jk...@in...>]

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

Re: [Squirrel-sql-users] default driver provider

[Neville R. <row...@ho...>]

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

[Squirrel-sql-users] default driver provider

[JK <jk...@in...>]

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

Re: [Squirrel-sql-users] Smart Tools Plugin

[Neville R. <row...@ho...>]

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

[Squirrel-sql-users] default driver provider

[JK <jk...@in...>]

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

[Squirrel-sql-users] Smart Tools Plugin

[Shannon M. <tek...@te...>]

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.

[Squirrel-sql-users] looking at H2 database

[John N. <joh...@ou...>]

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.

Re: [Squirrel-sql-users] How to change font in Result Tab (table) to e. g. Arial Unicode MS for better Unicode support?

[Wesley N. <We...@Ke...>]

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

[Squirrel-sql-users] How to change font in Result Tab (table) to e. g. Arial Unicode MS for better Unicode support?

[Stepan R. <xr...@se...>]

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