[CONJ-428] Have a MariaDbConnection.ping method to permit JBOSS connection validation Created: 2017-02-09  Updated: 2017-02-09  Resolved: 2017-02-09

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: None
Fix Version/s: N/A

Type: Task Priority: Trivial
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Won't Do Votes: 0
Labels: None


 Description   

JBOSS has 2 differents connection validation method :

  • defined a "check-valid-connection-sql" command : 

    <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>

  • define "valid-connection-checker" :

<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>

This validation checker use reflect to check if connection has a "ping" method. if not execute a "SELECT 1" command.



 Comments   
Comment by Diego Dupin [ 2017-02-09 ]

cannot be done with MySQLValidConnectionChecker (example : http://grepcode.com/file/repository.jboss.org/nexus/content/repositories/releases/org.jboss.jbossas/jboss-as-connector/6.1.0.Final/org/jboss/resource/adapter/jdbc/vendor/MySQLValidConnectionChecker.java) since using MySQL driver path

Generated at Thu Feb 08 03:15:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.