Uploaded image for project: 'JGroups'
  1. JGroups
  2. JGRP-1569

JDBC_PING doesn't work on mssql

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 3.3
    • 2.12.1
    • None
    • Hide

      No

      Show
      No
    • Hide

      with below property file to initialize jchannel

      <config xmlns="urn:org:jgroups" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="urn:org:jgroups http://www.jgroups.org/schema/JGroups-2.12.xsd">
      <TCP bind_port="8800" discard_incompatible_packets="true"
      enable_bundling="true" log_discard_msgs="false" loopback="true"
      max_bundle_size="64K" max_bundle_timeout="30" oob_thread_pool.enabled="true"
      oob_thread_pool.keep_alive_time="5000" oob_thread_pool.max_threads="8"
      oob_thread_pool.min_threads="1" oob_thread_pool.queue_enabled="false"
      oob_thread_pool.queue_max_size="100" oob_thread_pool.rejection_policy="discard"
      recv_buf_size="${tcp.recv_buf_size:20M}" send_buf_size="${tcp.send_buf_size:640K}"
      sock_conn_timeout="300" thread_pool.enabled="true"
      thread_pool.keep_alive_time="5000" thread_pool.max_threads="10"
      thread_pool.min_threads="1" thread_pool.queue_enabled="false"
      thread_pool.queue_max_size="100" thread_pool.rejection_policy="discard"
      timer.keep_alive_time="3000" timer.max_threads="10" timer.min_threads="4"
      timer.queue_max_size="500" timer_type="new" use_send_queues="true" />

      <JDBC_PING
      break_on_coord_rsp="true"
      connection_driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
      connection_password="vitria"
      connection_url="jdbc:sqlserver://10.111.3.75:1526;databaseName=wyang;"
      connection_username="sa" ergonomics="false" max_rank="0" timeout="20000" />
      <MERGE2 max_interval="30000" min_interval="10000" />
      <FD_SOCK />
      <FD max_tries="5" shun="true" timeout="10000" />
      <FD_ALL />
      <VERIFY_SUSPECT timeout="15000" />
      <BARRIER />
      <pbcast.NAKACK discard_delivered_msgs="true"
      exponential_backoff="500" use_mcast_xmit="false"
      use_stats_for_retransmission="false" />
      <UNICAST timeout="300,600,1200" />
      <VIEW_SYNC avg_send_interval="60000" />
      <pbcast.STABLE desired_avg_gossip="50000" max_bytes="4M"
      stability_delay="1000" />
      <pbcast.GMS join_timeout="30000" print_local_addr="true"
      view_bundling="true" />
      <UFC max_credits="2M" min_threshold="0.4" />
      <MFC max_credits="2M" min_threshold="0.4" />
      <FRAG2 frag_size="60K" />
      <!--pbcast.STREAMING_STATE_TRANSFER / -->
      <pbcast.STATE_TRANSFER />
      <!-- pbcast.FLUSH / -->
      </config>

      Show
      with below property file to initialize jchannel <config xmlns="urn:org:jgroups" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:org:jgroups http://www.jgroups.org/schema/JGroups-2.12.xsd "> <TCP bind_port="8800" discard_incompatible_packets="true" enable_bundling="true" log_discard_msgs="false" loopback="true" max_bundle_size="64K" max_bundle_timeout="30" oob_thread_pool.enabled="true" oob_thread_pool.keep_alive_time="5000" oob_thread_pool.max_threads="8" oob_thread_pool.min_threads="1" oob_thread_pool.queue_enabled="false" oob_thread_pool.queue_max_size="100" oob_thread_pool.rejection_policy="discard" recv_buf_size="${tcp.recv_buf_size:20M}" send_buf_size="${tcp.send_buf_size:640K}" sock_conn_timeout="300" thread_pool.enabled="true" thread_pool.keep_alive_time="5000" thread_pool.max_threads="10" thread_pool.min_threads="1" thread_pool.queue_enabled="false" thread_pool.queue_max_size="100" thread_pool.rejection_policy="discard" timer.keep_alive_time="3000" timer.max_threads="10" timer.min_threads="4" timer.queue_max_size="500" timer_type="new" use_send_queues="true" /> <JDBC_PING break_on_coord_rsp="true" connection_driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" connection_password="vitria" connection_url="jdbc:sqlserver://10.111.3.75:1526;databaseName=wyang;" connection_username="sa" ergonomics="false" max_rank="0" timeout="20000" /> <MERGE2 max_interval="30000" min_interval="10000" /> <FD_SOCK /> <FD max_tries="5" shun="true" timeout="10000" /> <FD_ALL /> <VERIFY_SUSPECT timeout="15000" /> <BARRIER /> <pbcast.NAKACK discard_delivered_msgs="true" exponential_backoff="500" use_mcast_xmit="false" use_stats_for_retransmission="false" /> <UNICAST timeout="300,600,1200" /> <VIEW_SYNC avg_send_interval="60000" /> <pbcast.STABLE desired_avg_gossip="50000" max_bytes="4M" stability_delay="1000" /> <pbcast.GMS join_timeout="30000" print_local_addr="true" view_bundling="true" /> <UFC max_credits="2M" min_threshold="0.4" /> <MFC max_credits="2M" min_threshold="0.4" /> <FRAG2 frag_size="60K" /> <!--pbcast.STREAMING_STATE_TRANSFER / --> <pbcast.STATE_TRANSFER /> <!-- pbcast.FLUSH / --> </config>

    Description

      JDBC_PING with mssql database connection information, will give below exception:

      it seems caused by there is ";" in mssql connection_url, while the delimiter in propertiesToString also used ";"

      Exception in thread "main" org.jgroups.ChannelException: unable to setup the protocol stack
      at org.jgroups.JChannel.init(JChannel.java:1728)
      at org.jgroups.JChannel.<init>(JChannel.java:249)
      at org.jgroups.JChannel.<init>(JChannel.java:187)
      at JGroupTest.main(JGroupTest.java:41)
      Caused by: java.lang.Exception: Configurator.ProtocolConfiguration(): '=' not found in of JDBC_PING
      at org.jgroups.conf.ProtocolConfiguration.parsePropertiesString(ProtocolConfiguration.java:181)
      at org.jgroups.conf.ProtocolConfiguration.getOriginalProperties(ProtocolConfiguration.java:71)
      at org.jgroups.stack.Configurator.createInetAddressMap(Configurator.java:636)
      at org.jgroups.stack.Configurator.setupProtocolStack(Configurator.java:94)
      at org.jgroups.stack.Configurator.setupProtocolStack(Configurator.java:55)
      at org.jgroups.stack.ProtocolStack.setup(ProtocolStack.java:534)
      at org.jgroups.JChannel.init(JChannel.java:1725)
      ... 3 more

      Attachments

        Activity

          People

            rhn-engineering-bban Bela Ban
            freeliuade freeliuade freeliuade (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: