Guys
JDBC resource gets configured from command line where all DS connection attributes are given correctly.I get a message saying " JDBC Resource Configuration Completed " .I open admin console of WAS(7.0beta) & try to test the connection for the newly created datasource.
I get following error:
The test connection operation failed for data source TradeDataSource on server nodeagent at node was7node1 with the following exception: java.sql.SQLException: [jcc][t4][10205][11234][3.50.152] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815DSRA0010E: SQL State = 42815, Error Code = -4,461.
Here's what i get to configure on command line while creating this datasource
------------------------------------------------
Collecting Database/Datasource Information
------------------------------------------------
Select the backend database type (db2|oracle|db2zos) [db2]:
db2
NOTE: wsadmin requires ";" for delimiting the database
driver path regardless of platform!
Please enter the database driver path [c:/sqllib/java/db2jcc.jar;c:/sqllib/java/db2jcc_license_cu.jar;c:/sqllib/java/db2jcc_license_cisuz.jar]:
<db2inst_home_path>/sqllib/java/db2jcc.jar:<db2inst_home_path>/sqllib/java/db2jcc_license_cu.jar
Please enter the database name (location) [tradedb]:
trade6db
Please enter the DB2 database hostname [localhost]:
<unix_host_name>
Please enter the DB2 database port number [50000]:
60000
Please enter the database username [db2admin]:
db2inst9
Please enter the database password [password]:
******
Any idea what this error? Is it some driver issue?
Kindly advice.
Regards
Abhi