Hey I'm trying to connect to our db2 server and I got an error (bellow):
Can't establish connection to database
java.sql.SQLException: [ibm][db2][jcc][t4] Connection authorization failure occurred. Reason: Security mechanism not supported.
I looked around and I found this: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.java.doc/doc/cjvjcsec.htm
It seems that our corp server is configured to use encryption or something. I found another thread where s there somebody shared that they changed the connection properties and it worked, bellow is the quote. Hope all that would help you guys to figure out how to improve OUR BELOVED IDEA! :)
I work now in a very IBM like corp shop and I'm preaching IDEA to everybody around however - I feel that Idea needs to learn to communicate better with WebSphere and IBM's DB2 ...
Deian (old fan and user!)
I 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: