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.
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.
Sawan 270000UTQ856 Posts
Re: Connection error while connecting to DB2 using Universal JDBC driver2008-06-25T11:43:04ZThis is the accepted answer. This is the accepted answer.Which 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:29ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
"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: