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.