Testing a connection using wsadmin

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

Note: This invocation style is currently supported only for databases that do not require a user ID and password to make a connection.

To test a connection using wsadmin, perform the following steps:

  1. Invoke the getid method for your data source.

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

    set myds [$AdminConfig getid /JDBCProvider:mydriver/DataSource:mydatasrc/]

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

  3. Test the connection to the database.

    $AdminControl testConnection $myds