无法访问服务器上的JDBC_PING无法正常工作

Question

我处于infinispan服务器实验阶段，并且在设置本地计算机上的无限集群时遇到问题。 配置文件： 我通过使用udp堆栈和jdbc_ping发现更改jgroup堆栈的一部分来更改配置文件cluster.xml。

<subsystem xmlns="urn:infinispan:server:jgroups:7.0" default-stack="${jboss.default.jgroups.stack:udp-jdbc}"> 
     <stack name="udp-jdbc"> 
      <transport type="UDP" socket-binding="jgroups-udp"> 
       <property name="ip_mcast">false</property> 
    </transport> 
      <protocol type="JDBC_PING"> 
       <property name="connection_url">jdbc:mysql://localhost/jgroups</property> 
       <property name="connection_username">root</property> 
       <property name="connection_password">root</property>    
       <property name="connection_driver">com.mysql.jdbc.Driver</property> 
    </protocol>     
      <protocol type="FD_SOCK" socket-binding="jgroups-udp-fd"/> 
      <protocol type="FD_ALL"/> 
      <protocol type="VERIFY_SUSPECT"/> 
      <protocol type="pbcast.NAKACK2"/> 
      <protocol type="UNICAST3"/> 
      <protocol type="pbcast.STABLE"/> 
      <protocol type="pbcast.GMS"/> 
      <protocol type="UFC"/> 
      <protocol type="MFC"/> 
      <protocol type="FRAG2"/> 
      <protocol type="RSVP"/> 
     </stack> 

我把MySQL驱动程序文件夹中独立/部署，运行服务器，这里是我有什么作为输出

20:13:15,389 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015876: Starting deployment of "mysql-connector-java-5.1.34-bin.jar" (runtime-name: "mysql-connector-java-5.1.34-bin.jar") 
20:13:15,461 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-1) MSC000001: Failed to start service jboss.jgroups.channel.clustered: org.jboss.msc.service.StartException in service jboss.jgroups.channel.clustered: java.lang.IllegalArgumentException: JDBC Driver required for JDBC_PING protocol could not be loaded: 'com.mysql.jdbc.Driver' 
    at org.jboss.as.clustering.jgroups.subsystem.ChannelService.start(ChannelService.java:74) 
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948) [jboss-msc-1.2.2.Final.jar:1.2.2.Final] 
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881) [jboss-msc-1.2.2.Final.jar:1.2.2.Final] 
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_25] 
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_25] 
    at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_25] 
Caused by: java.lang.IllegalArgumentException: JDBC Driver required for JDBC_PING protocol could not be loaded: 'com.mysql.jdbc.Driver' 
    at org.jgroups.protocols.JDBC_PING.loadDriver(JDBC_PING.java:267) 
    at org.jgroups.protocols.JDBC_PING.init(JDBC_PING.java:93) 
    at org.jgroups.stack.ProtocolStack.initProtocolStack(ProtocolStack.java:860) 
    at org.jgroups.stack.ProtocolStack.setup(ProtocolStack.java:481) 
    at org.jgroups.JChannel.init(JChannel.java:848) 
    at org.jgroups.JChannel.<init>(JChannel.java:159) 
    at org.jboss.as.clustering.jgroups.JChannelFactory.createChannel(JChannelFactory.java:87) 
    at org.jboss.as.clustering.jgroups.subsystem.ChannelService.start(ChannelService.java:69) 
    ... 5 more 

20:13:15,559 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1) 
20:13:15,561 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.fabric.jdbc.FabricMySQLDriver (version 5.1) 
20:13:15,563 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-7) JBAS010417: Started Driver service with driver-name = mysql-connector-java-5.1.34-bin.jar_com.mysql.jdbc.Driver_5_1 
20:13:15,564 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-5) JBAS010417: Started Driver service with driver-name = mysql-connector-java-5.1.34-bin.jar_com.mysql.fabric.jdbc.FabricMySQLDriver_5_1 
20:13:15,597 INFO [org.jboss.as.server] (ServerService Thread Pool -- 18) JBAS018559: Deployed "mysql-connector-java-5.1.34-bin.jar" (runtime-name : "mysql-connector-java-5.1.34-bin.jar") 
20:13:15,599 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report 
JBAS014777: Services which failed to start:  service jboss.jgroups.channel.clustered: org.jboss.msc.service.StartException in service jboss.jgroups.channel.clustered: java.lang.IllegalArgumentException: JDBC Driver required for JDBC_PING protocol could not be loaded: 'com.mysql.jdbc.Driver' 

你可以从JBoss日志，子系统的Infinispan看到：服务器：由于JDBC驱动程序未加载（由JDBC_PING所要求），jgroups无法启动，但在此步骤之后，infinispan服务器成功部署了mysql jdbc驱动程序。在我使用数据源的条件下，这种相同的错误占据了相同的位置。 有什么办法可以告诉infinispan：服务器：jgroups子系统在驱动程序加载之前或jndi命名创建之前启动？ 或任何解决方法，这将有助于

在此先感谢

Answer 1

对于直接使用JDBC的使用，你需要允许JGroups的模块加载JDBC驱动程序模块。为此，请将JDBC驱动程序jar安装为模块，然后打开modules/system/layers/base/org/jgroups/main/module.xml，在依赖项部分添加您的JDBC驱动程序模块。

对于使用EAGER缓存的数据源查找，我认为目前无法确保数据源在JGroups尝试使用它之前可用。服务引导顺序由编程依赖性控制，但无法通过配置文件声明依赖性，因此JGroups不会等待数据源。