JDBC_Ping Error During Shutdown

246 views
Skip to first unread message

David Baddeley

unread,
Aug 9, 2022, 11:09:22 AM8/9/22
to WildFly
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


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

unread,
Aug 10, 2022, 4:17:41 AM8/10/22
to WildFly
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

unread,
Aug 10, 2022, 12:09:22 PM8/10/22
to WildFly

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

unread,
Aug 10, 2022, 1:17:04 PM8/10/22
to WildFly
The data-source attribute references a capability from the datasource subsystem.  Therefore, you first need to create a datasource.  See:

David Baddeley

unread,
Aug 25, 2022, 8:32:22 AM8/25/22
to WildFly

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">
Reply all
Reply to author
Forward
0 new messages