Test a connection using wsadmin

 

The AdminControl object of wsadmin has a testConnection operation that tests the configuration properties of a data source object using a configuration ID as an argument.

This invocation is currently supported only for databases that do not require a user ID and password to make a connection, such as DB2 on a Windows NT machine.

1. Invoke the getid method for your data source.

2. Set the value of the configuration id to a variable.

   set xDS [$AdminConfig getid /JDBCProvider:MyJDBC/DataSource:MyDataSource/] 
   

   where /JDBCProvider:mydriver/DataSource:mydatasrc/ is the data source you want to test. After you have the configuration ID

3. Test the connection to the database

   $AdminControl testConnection $myds
   

 

---