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.  WmDeveloper - ServiceException

    Posted Tue April 17, 2007 03:40 PM

    I created a new Adapter Service (mysql connection).

    My JDBC Adapter:
    Connection Properties
    Transaction Type LOCAL_TRANSACTION
    DataSource Class com.mysql.jdbc.jdbc2.optional.MysqlDataSource
    serverName
    user root (just for testing permissions)
    password ******
    databaseName
    portNumber 3306
    networkProtocol tcp

    Everything looks perfect except when I try a “SELECT” .

    Unable to invoke adapter service mysql2:Mysqls2. [ADA.1.316] Cannot execute the SQL statement “SELECT teste01.ID FROM mysqlwm.ROOT@LOCALHOST.teste01 teste01”. "

    Obviously this “ROOT@LOCALHOST” was not supposed to be there. I did not find out how to remove it. Anyone?


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


  • 2.  RE: WmDeveloper - ServiceException

    Posted Tue April 17, 2007 05:30 PM

    Edit the Table Name value on the Tables tab of your adapter service.


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


  • 3.  RE: WmDeveloper - ServiceException

    Posted Tue April 17, 2007 05:38 PM

    On the “Tables” , I have:

    Table Alias Teste01
    Table Name mysqlwm..teste01
    Type Table

    I cannot remove this !!


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


  • 4.  RE: WmDeveloper - ServiceException

    Posted Tue April 17, 2007 06:28 PM

    Sorry !! I know nothing about this…lol :o This works : ..teste01


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


Related Content