Testing Datasource connections using CLI in JBoss EAP

Solution Verified - Updated -

Issue

  • How to test the jdbc datasource that is configured in the standalone.xml file through the JBoss CLI command.
  • Is there a CLI command available which can be used to Test the DataSource Connections ?
  • How to test JDBC connection in domain mode using CLI command ?
  • How can one verify that datasource is available for application usage?
  • How to test a connection from a Datasource using the CLI in JBoss EAP 6?
  • How do I test a database connection in EAP 6.
  • Getting following ERROR while testing datasource connection in EAP 6:
$ ./jboss/bin/jboss-cli.sh --connect /host="test-host"/server="test_server"/subsystem=datasources/data-source="Test_DataSource":test-connection-in-pool

{
    "outcome" => "failed",
    "result" => undefined,
    "failure-description" => "JBAS014807: Management resource '[(\"subsystem\" => \"datasources\")]' not found",
    "rolled-back" => true
}
  • Getting following ERROR while testing datasource connection in JBoss EAP domain mode:
[domain@localhost:9999 /] /profile=full/subsystem=datasources/data-source=ExampleDS:test-connection-in-pool()
{
    "outcome" => "failed",
    "failure-description" => "JBAS014884: No operation named 'test-connection-in-pool' exists at address [
    (\"profile\" => \"full\"),
    (\"subsystem\" => \"datasources\"),
    (\"data-source\" => \"ExampleDS\")
]",
    "rolled-back" => true
}
  • I would like to know how to check or monitor the DB connection through the JBoss EAP connection pool. did any database pool log to verify?

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 6
    • 7

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In