I am getting following exception when i do Test Connection on WAS 6.1
Can Some one please help me
java.sql.SQLException: jcct420111237http://3.50.152 Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000DSRA0010E: SQL State = 28000, Error Code = -4,214
com.ibm.db2.jcc.b.SqlException: jcc107110611http://3.50.152 Caught java.security.InvalidAlgorithmParameterException while initializing EncryptionManager. See attached Throwable for details. ERRORCODE=-4223, SQLSTATE=null
... 63 more
java.security.InvalidAlgorithmParameterException: Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)
at com.ibm.crypto.provider.DHKeyPairGenerator.initialize(Unknown Source)
Message was edited by: PavanChoukhada
This topic has been locked.
3 replies Latest Post - 2009-08-04T21:54:29Z by SystemAdmin
Pinned topic Connection error while connecting to DB2 using Universal JDBC driver
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-08-04T21:54:29Z at 2009-08-04T21:54:29Z by SystemAdmin
Sawan 270000UTQ856 PostsACCEPTED ANSWER
Re: Connection error while connecting to DB2 using Universal JDBC driver2008-06-25T11:43:04Z in response to SystemAdminWhich Security mechanism are you trying to use ? Could you refer to the following mechanisms.
These are the supported mechanisms by IBM Data Server Driver for JDBC and SQLJ
Re: Connection error while connecting to DB2 using Universal JDBC driver2009-08-04T21:54:29Z in response to SystemAdminI was also getting the error:
"com.ibm.db2.jcc.b.SQLException: Connection authorization failure occurred. Reason: security mechanism not supported".
To solve it, I changed my connection info to use encryption since it was required at the server.
So I changed this:
myConn = DriverManager.getConnection(url, myuserid, mypassword);
Properties properties = new Properties();
myConn = DriverManager.getConnection(url, properties);
The format of the url did not need any changes. It was formatted like this:
url = "jdbc:db2://my.company.com:portnumber/DBNAME"
There are many other possible settings for "securityMechanism" so you may need to find the right one.
Here is a link to information which was very helpful for me: