SwitchYard SQL binding in a clustered environment

Solution Unverified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In