I have a couple of queries on how DAP
<http://gemfirexd.docs.pivotal.io/latest/developers_guide/topics/server-side/data-aware-procedures.html#data-aware-procedures>
and SYS listeners
<http://gemfirexd.docs.pivotal.io/latest/reference/system_procedures/add_listener.html>
work.
1. Event Listeners - Can the event listener be configured to be executed
*only* on the primary node in the case when the table is replicated on
multiple nodes?
2. Data Aware Procedure - I wanted to understand the behavior of a data
aware procedure code execution when
1. It is called ON a table that is replicated on multiple nodes? Would
the procedure execute on all the replicated nodes or only on the primary
node? If it executes on all nodes, is there a way to configure it to
execute on only on the primary node?
2. I would like the DAP to join the transaction started by the jdbc
client that invoked it. This could also lead to recursive
invocation of the
procedure to perform DML queries on multiple tables. Is that
theoretically
possible?
I would be helpful if someone could share their insights on this.
Thanks,
Amit
