We want to implement Oracle Database Continuous Query Notification in a multiple cluster environment . But what we desire is that the DB change notification should be sent to only one instance of the application , because as of now it sending the change notification to all of the instance. How do I get the desired characteristic. My listener code is as
 DCNDemoListener list = new DCNDemoListener(this);
            dcr.addListener(list);
            // second step: add objects in the registration:
            Statement stmt = conn.createStatement();
            // associate the statement with the registration:
            ((OracleStatement)stmt).setDatabaseChangeRegistration(dcr);
            ResultSet rs = stmt.executeQuery("select * from testtable where ID=1");
Properties :
OracleConnection conn = connect();
        // first step: create a registration on the server:
        Properties prop = new Properties();
        prop.setProperty(OracleConnection.DCN_NOTIFY_ROWIDS,"true");
        prop.setProperty(OracleConnection.DCN_QUERY_CHANGE_NOTIFICATION,"true");
        DatabaseChangeRegistration dcr = conn.registerDatabaseChangeNotification(prop);