[jboss-jira] [JBoss JIRA] (JGRP-2064) JDBC_PING: make subclass of FILE_PING

[Ashish Agarwal (JIRA)]

    [ https://issues.jboss.org/browse/JGRP-2064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13506333#comment-13506333 ] 

Ashish Agarwal commented on JGRP-2064:
--------------------------------------

I tried using remove_old_coords_on_view_change and remove_all_files_on_view_change  in my xml file but its not working

Please suggest.

My xml looks like this :
<JDBC_PING connection_url="DB url"
               connection_username="user_name" connection_password="password"
               connection_driver="oracle.jdbc.OracleDriver"
               remove_old_coords_on_view_change="true"
               initialize_sql="CREATE TABLE IF NOT EXISTS jgroup_ping (
                       own_addr varchar(200) NOT NULL,
                                    cluster_name varchar(200) NOT NULL,
                                    ping_data varbinary(5000) DEFAULT NULL,
                                    PRIMARY KEY (own_addr, cluster_name)
                       )ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin"

               insert_single_sql="INSERT INTO jgroup_ping (own_addr, cluster_name, ping_data) values (?, ?, ?)"
               delete_single_sql="DELETE FROM jgroup_ping WHERE own_addr=? AND cluster_name=?"
               select_all_pingdata_sql="SELECT ping_data FROM jgroup_ping WHERE cluster_name=?" />

> JDBC_PING: make subclass of FILE_PING
> -------------------------------------
>
>                 Key: JGRP-2064
>                 URL: https://issues.jboss.org/browse/JGRP-2064
>             Project: JGroups
>          Issue Type: Feature Request
>            Reporter: Bela Ban
>            Assignee: Bela Ban
>            Priority: Minor
>             Fix For: 4.0
>
>
> This way, zombie removal would be possible, e.g. attributes {{remove_old_coords_on_view_change}} and {{remove_all_files_on_view_change}} would be usable.
> Currently, JDBC_PING extends Discovery only, not FILE_PING



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)