Db2 v 8.2 on Windows
WAS 6

While creating the data source, I used the user name as db2admin which I used to create the database as well as for login on machine. Also on the websphere the test connection is successful. But when tried to run application fetching data from data source, the ‘java.sql.exception’ occurs. When I run application using Driver Manager, connectivity to database is successful. So suspecting a JNDI lookup problem. Tried to patch up fix pack for the webshpere version which I am using. Still problem persists.

log given below
[2/28/07 18:43:22:365 IST] 00000037 SystemErr R java.sql.SQLException: [ibm][db2][jcc][t4][10205][11235] Null password is not supported.DSRA0010E: SQL State = null, Error Code = -99,999
[2/28/07 18:43:22:365 IST] 00000037 SystemErr R at com.ibm.db2.jcc.b.b.d(b.java:1801)
[2/28/07 18:43:22:365 IST] 00000037 SystemErr R at com.ibm.db2.jcc.b.b.b(b.java:606)
[2/28/07 18:43:22:365 IST] 00000037 SystemErr R at com.ibm.db2.jcc.b.b.a(b.java:593)
[2/28/07 18:43:22:365 IST] 00000037 SystemErr R at com.ibm.db2.jcc.b.b.a(b.java:355)
[2/28/07 18:43:22:365 IST] 00000037 SystemErr R at com.ibm.db2.jcc.b.b.<init>(b.java:292)
[2/28/07 18:43:22:365 IST] 00000037 SystemErr R at com.ibm.db2.jcc.DB2PooledConnection.<init>(DB2Pool edConnection.java:67)
[2/28/07 18:43:22:365 IST] 00000037 SystemErr R at com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPoo ledConnectionX(DB2ConnectionPoolDataSource.java:14 4)
[2/28/07 18:43:22:365 IST] 00000037 SystemErr R at com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPoo ledConnection(DB2ConnectionPoolDataSource.java:58)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreH elper$1****n(InternalGenericDataStoreHelper.java:89 7)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:118)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreH elper.getPooledConnection(InternalGenericDataStore Helper.java:892)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ws.rsadapter.spi.InternalDB2UniversalDataS toreHelper.getPooledConnection(InternalDB2Universa lDataStoreHelper.java:1368)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooled Connection(WSRdbDataSource.java:1181)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.getGoodConnection(WSManagedConnectionFactory Impl.java:2573)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.createManagedConnection(WSManagedConnectionF actoryImpl.java:1109)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ejs.j2c.FreePool.createManagedConnectionWi thMCWrapper(FreePool.java:1793)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection (FreePool.java:1541)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.ja va:2145)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrappe r(ConnectionManager.java:846)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ejs.j2c.ConnectionManager.allocateConnecti on(ConnectionManager.java:585)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java:431)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java:400)
[2/28/07 18:43:22:375 IST] 00000037 SystemErr R at com.mastek.beanpack.PolicyBean.getConn(PolicyBean. java:51)