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.
- Invoke the getid method for your data source.
- Set the value of the configuration id to a variable.where /JDBCProvider:mydriver/DataSource:mydatasrc/ is the data source you want to test. After you have the configuration IDset xDS [$AdminConfig getid /JDBCProvider:MyJDBC/DataSource:MyDataSource/]
- Test the connection to the database$AdminControl testConnection $myds