Test connection when 'allow-multiple-users' is 'true' in JBoss EAP

Solution Verified - Updated -

Issue

  • A datasource was created with created with <allow-multiple-users>true</allow-multiple-users>
  • When testing the pool from the web based admin console or running test-connection-in-pool via JBoss CLI failure occurs:

    # EAP 6
    [standalone@localhost:9999 /] /subsystem=datasources/xa-data-source=OracleXA_DS:test-connection-in-pool()
    {
        "outcome" => "failed",
        "failure-description" => "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid",
        "rolled-back" => true
    }
    
    # EAP 7
    [standalone@localhost:9990 /] /subsystem=datasources/data-source=ExampleDS:test-connection-in-pool
    {
        "outcome" => "failed",
        "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid",
        "rolled-back" => true
    }
    

Environment

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

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