Getting error "Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied" while datasource password being secured with credential store
Issue
-
Unable to start the EAP server due to datasource password being secured with credential store.
-
The below error is seen during datasource password being secured with credential store
WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (management-handler-thread - 1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection
......
......
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:441)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:436)
......
......
2022-09-01 16:37:48,774 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 1) WFLYCTL0013: Operation ("test-connection-in-pool") failed - address: ([
("subsystem" => "datasources"),
("data-source" => "my_datasource")
]) - failure description: "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid"
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 7.1 or later
- Java Database Connectivity (JDBC) Datasources
- Elytron Credential Stores
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.