Causal error not reported for datasource connection test failure in web console in JBoss EAP

Solution Verified - Updated -

Issue

  • An invalid (e.g. misspelled) user is specified in a datasource configuration
  • When testing datasource connectivity, the web console reports a generic error which provides no indication of the root cause

    WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid
    
  • The causal error can be found by opening the server.log

    ... WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (External Management Request Threads -- 1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
        ...
    Caused by: java.sql.SQLException: Access denied for user 'notme'@'localhost' (using password: YES)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
        ...
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
        ...
    

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP) 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