Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-5514

Please allow flexible SQL bindings for SwitchYard

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Won't Do
    • Icon: Major Major
    • jboss-fuse-6.3
    • jboss-fuse-6.2.1
    • SwitchYard
    • None
    • % %
    • 0
    • 0% 0%

      The SwitchYard SQL binding offers a way to bind message variables to a SQL query specified in the binding: a List is passed, these are plugged into variables marked '#'.

      SQL can also be specified on a property, "CamelSqlQuery". This allows us to over-ride the sql the reference binding would otherwise use, but does not offer the flexibility of binding objects from the message into the query.
      ReferenceInvocation invocation = invoker.newInvocation("execute");
      invocation.setProperty("CamelSqlQuery", "SELECT * FROM persons WHERE somecriteria .....");

      Our customer finds this sub-optimal. This requires one binding per SQL operation, which leads to cluttered SY diagrams. It would be better if we could have a mechanism where SwitchYard provides both a query and a list of objects, having the infrastructure map the right values into the query. (Perhaps the query is provided via a message property, like case 2 above.)

        1. A_Camel_SQL_Fixed.tar.gz
          31 kB
        2. A_Camel_SQL.tar.gz
          7 kB
        3. A_Camel_SQL.working.tar.gz
          9 kB
        4. MariaDBKit.tar.gz
          308 kB

            toigaras@redhat.com tomohisa igarashi
            rhn-support-rick Rick Wagner
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: