How to get the Datasource test connection status using http api

[balamv]

Hi,
I like to check if the respective database connection is successful for the datasource using http management api. I was not getting the expected output, can some one help me here ?

http://MANAGEMENT_HOST:PORT/management/host/MYHOST/server/MYSERVER/datasources/xa-data-source/MYDATASOURCE/operation=test-connection-in-pool

{"outcome": "failed", "result": null, "failure-description": "WFLYCTL0216: Management resource '[\n (\"subsystem\" => \"datasources\"),\n (\"xa-data-source\" => \"MYDATASOURCE:operation=test-connection-in-pool\")\n]' not found", "rolled-back": true}

[zhurlik]

Hi,

Could you have a look at Monitoring datasource connection pool on JBoss AS7.1

For example, for me the following link works

http://localhost:9990/management/subsystem/datasources/data-source/ExampleDS/statistics/pool?include-runtime=true

Thanks,

Vlad

[mayerw01]

Only basic operations are supported with GET jndi-view via http management interface

But you could get this info eg like:
curl --digest -D - http://localhost:9990/management --header "Content-Type: application/json" -d '{"operation":"test-connection-in-pool", "address":["subsystem","datasources","data-source","ExampleDS"],  "json.pretty":1}' -u name:password