SwitchYard SQL binding in a clustered environment
Issue
- I am using SwitchYard SQL (camel-sql) binding.
- In a clustered environment, how can I lock the records when the binding reads them so that another node in the cluster does not read the same rows?
- What is most important is being able to query rows using the SQL binding once and only once, even in a clustered environment.
- We would like for each node in the cluster to run the exact same deployments.
- Does SwitchYard SQL binding support clustered deployments?
- Does the binding use
SELECT .. FOR UPDATE
syntax to lock the selected rows until the transaction is complete? If not, do you have any suggestions?
Environment
- Red Hat JBoss Fuse Service Works (FSW)
- 6.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.