Network Deployment (Distributed operating systems), v8.0 > Administer applications and their environment > Administer Data access resources > Administer data access applications > Configure a JDBC provider and data source
Test a connection using wsadmin
The AdminControl object of the wsadmin scripting tool has a testConnection operation that tests the configuration properties of a data source object. The testConnection operation takes a data source configuration ID as an argument.
This invocation cannot accept user IDs and passwords that must be defined in the database itself. This invocation can be used only for databases that do not require a user ID and password to make a connection (such as DB2 on a Windows machine), or for data sources that have a component-managed or container-managed authentication alias set on the data source object.
Procedure
- Start the getid() method for your data source.
- 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 to test. After we have the configuration ID of the data source, you can test the connection to the database.- Test the connection to the database. Use the following command:
$AdminControl testConnection $myds
Test connection service
Test a connection with the administrative console