Re: E J2CA0036E: An exception occurred while invoking method setDataSourceProperties

[pank...@us.ibm.com]

Hi,

I faced similar issue on WebSphere Application Server 6.1 ND environment; but on a cluster of WAS 6.1 servers. The reason was that, I was creating JDBC providers and WAS DataSource at cluster level for my network deployed EJB application to access DB2 8.2 database. I was not overrriding the cluster scoped JDBC resources with the managed node scoped equivalents of the same. Still I was expecting that, the JDBC connection request from my EJB deployed on each cluster member running on managed nodes in the DMGR cell should get satisfied by the JDBC resources defined at cluster scope. This was failing!!!
What was required is, one should have a 100% homogeneous cluster for this; homogeneous in all senses including a)underlying OS, b)location of DB2 JDBC driver JARs on DMGR and all Managed nodes, & c)The WAS product installed on DMGR and all Managed nodes.
Going ahead, one need to define DB2UNIVERSAL_JDBC_PROVIDER_PATH variable at CELL level of DMGR and set value of this variable as PATH to JDBC driver JARs on local machine (which is no different to the path of same JARs on all managed nodes). Thats all about it!!

I dont know how much this fits and applies into your context of problem!! But still I hope this would give some helpful pointers to others facing similar problem.

Regards,
Pankaj