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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content