JDBC_Ping Error During Shutdown

[David Baddeley]

We are using JDBC_Ping with latest Wildfly 26.1.1 in standalone-ha profile

When the server is shutdown we are seeing the following:

JGRP000115: Could not open connection to database: java.sql.SQLException: javax.resource.ResourceException: IJ000470: You are trying to use a connection factory that has been shut down: java:/webDatasource

I can see that this issue is reported against EAP here already- https://issues.redhat.com/browse/JBEAP-4911?page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel&showAll=true

However the solution (setting data-source attribute on the protocol) requires the use of the jgroups 5.0 schema and in Wildfly 26 its using 4.0 I think

Is there a solution for Wildfly I can use or should this be reported as a bug?

[Valerii Pekarskyi]

Actually Wildfly 26 uses jgroups schema version 8.0, so there should no issues setting the database connection like this within your protocol stack:

<jdbc-protocol type="JDBC_PING" data-source="myDataSource">

[David Baddeley]

I can't seem to get this config working either

Using:

<jdbc-protocol type="JDBC_PING" data-source="java:/webDatasource">

or

<jdbc-protocol type="JDBC_PING" data-source="webDatasource">

produces following error:

17:06:38,949 ERROR [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0362: Capabilities required by resource '/subsystem=jgroups/stack=tcp/protocol=JDBC_PING' are not available:

    org.wildfly.data-source.java:/webDatasource; Possible registration points for this capability: 

       /subsystem=datasources/data-source=*

       /subsystem=datasources/xa-data-source=*

[Paul Ferraro]

The data-source attribute references a capability from the datasource subsystem.  Therefore, you first need to create a datasource.  See:

https://github.com/wildfly/wildfly/blob/main/docs/src/main/asciidoc/_admin-guide/subsystem-configuration/DataSource.adoc

[David Baddeley]

Yes I had the datasource defined but you need to use the jdbc reference in the end

this is the working config....

<jdbc-protocol type="JDBC_PING" data-source="jdbc/webDatasource">