IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  Select Pattern with MySQL

    Posted Thu November 24, 2005 01:23 PM

    Hello,

    I am using a JDBC adapter with MySQL.
    When I create a new Adapter service with a select template, the SQL request generated is:

    SELECT ALL ChannelStatus.ChannelID,ChannelStatus.Status FROM channeltables.ROOT@CLAP101H.CLA.FR.channelstatus t1 WHERE (ChannelStatus.ChannelID = ChannelID)

    This request is refused by MySql because it can’t recognise the table name channeltables.ROOT@CLAP101H.CLA.FR.channelstatus. However if I replace it with the simple table name “channelstatus”, it works.

    Do you know why ? or to you know How to force the simple table name ?

    Thanks


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


Related Content