Unable to access data source with launchClient command

[tang.hu...@prudential.com.sg]

I have set up a data source (using DB2 JCC Driver) in Webpshere Application Server V7.0 to connect to the database. The database is IBM DB2 V9.5 which is on the same box as WAS. I have also created a new JAAS - J2C authentication data and assigned it to the data source. I test the connection in admin console and it's successful. However, I'm not able to connect to the database with launchClient command.

launchClient -profileName myProfile C:\temp\hs\TestEAR.ear -CCBootstrapHost=158.245.5.22 -CCBootstrapPort=2809 -CCclasspath="C:\Apps\lib\common\log4j-1.2.8.jar;D:\DB2\IBM\SQLLIB\java\db2jcc.jar;C:\WAS7\lib\bootstrap.jar;C:\WAS7\properties;C:\WAS7\lib\lmproxy.jar;C:\WAS7\lib\urlprotocols.jar;C:\Apps\lib\interface\j2ee.jar" -CCverbose=true

The error is as followed :
java.sql.SQLNonTransientException: [jcc][t4][10205][11234][4.0.100] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815DSRA0010E: SQL State = 42815, Error Code = -4,461
at com.ibm.db2.jcc.a.yc.a(yc.java:579)
at com.ibm.db2.jcc.a.yc.a(yc.java:57)
at com.ibm.db2.jcc.a.yc.a(yc.java:102)
at com.ibm.db2.jcc.t4.b.J(b.java:1898)
at com.ibm.db2.jcc.t4.b.f(b.java:1905)
at com.ibm.db2.jcc.t4.b.d(b.java:631)
at com.ibm.db2.jcc.t4.b.c(b.java:618)
at com.ibm.db2.jcc.t4.b.a(b.java:360)
at com.ibm.db2.jcc.t4.b. (b.java:298)
at com.ibm.db2.jcc.DB2PooledConnection.(DB2PooledConnection.java:78)
at com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPooledConnectionX(DB2ConnectionPoolDataSource.java:348)
at com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPooledConnection(DB2ConnectionPoolDataSource.java:156)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:1175)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:1212)
at com.ibm.ws.rsadapter.spi.InternalDB2UniversalDataStoreHelper.getPooledConnection(InternalDB2UniversalDataStoreHelper.java:1540)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:2019)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1422)
at com.ibm.ws.rsadapter.spi.WSDefaultConnectionManagerImpl.allocateConnection(WSDefaultConnectionManagerImpl.java:81)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:646)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:613)

After that, I created a new data source by selecting "Data Source (WebSphere Application Server V4) ". I'm able to get through this time. Seems like the launchClient command is not able to access the J2C authentication data defined.

Please advise. Thanks.

[Brian S Paskin]

Hi, did you follow the following document:

[link]http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/tatk_condacli.html[link]

Regards,
brian

[tang.hu...@prudential.com.sg]

Thanks for your reply. Yes, I did. But I still get the same error message.

[AJAY KUMAR M.]

I belive "Container Managed Authentication" (with J2C authentication alias) is deprecated since WAS 6.0.

Since you application run outside the container, it might be giving this error.

What authentication settings do you use?

Thanks.