Announcement

Collapse
No announcement yet.

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