Thursday, January 26, 2012

Test DB2 JDBC Data source failed in WebSphere 7 cluster

As far as how to create a new DB2 datasource in WebSphere 7 is pretty straightforward, it contains two steps:
1. Create a new JAAS J2C data entry to hold your username and password.
2. Create a new DataSource by using the newly created JAAS J2C data entry.
That's all you need to do. But where may be a catch when you try to do it in a cluster environment, you may run into the following exepction when you try to test your newly created Data source:
java.lang.Exception: java.sql.SQLException: null userid not supported

My solution is to restart the nodeagents on the custer nodes.