Insert into Federated tables using mysql triggers
Hi,
I have a local table A and a federated table B.
I'm trying to insert into federated table B using After trigger Insert on local table A.
Everything works as long as both servers are connected.
Whenever the other server is either down or unavailable during insert action it gets hung or something. I'm not sure whether it is waiting for the server. It gets hung and as long as i reconnect back to other server the action resumes.
I would like to throw an error and keep going.
I tried RESIGNAL as below
DECLARE EXIT HANDLER FOR SQLEXCEPTION
RESIGNAL;
But doesn't seem to help. Any ideas?
Thanks.
Subject
Views
Written By
Posted
Insert into Federated tables using mysql triggers
1790
January 16, 2019 04:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.