Announcement

Collapse

NextGen (Mirth) Connect 3.9.1 Released!

NextGen (Mirth) Connect 3.9.1 is now available as an appliance update and on our GitHub page. This release contains bug fixes and adds support for eHealth Exchange UDDI providers in the Interoperability plugin. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Has anybody successfully used a JOIN?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Has anybody successfully used a JOIN?

    I have a ticket into JIRA regarding this and another post, but thought I would troll the forum to see if anybody has successfully used a JOIN (in any db) for the Database Reader SQL Statement? If you have can you share the syntax and DB you are using ?

    I have failed to get it to work on two different platforms: postgres / mysql on winders and mac...

    JIRA Issue


    My join is pretty straightforward... and works from the shell...

    THANKS, IM STUCK

  • #2
    Re: Has anybody successfully used a JOIN?

    Sween -

    It doesn't appear that Mule (our ESB) supports JOINS - however there is a way to access the native Java JDBC layer from the transformer (using the createDatabaseConnection function that you can drag and drop).

    Check the forum for a few examples of using this, or shoot me an email for an example channel.

    -Chris
    Chris Lang

    Comment

    Working...
    X