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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  watt.adapter.JDBC.UsePlainString Key

    Posted 02/18/14 02:31 PM

    I have enabled Trace logging for JDBC adapter and I see a lot of these messages:
    [293513]2014-02-18 12:19:23 CST [ADA.0001.0115T] Info: “watt.adapter.JDBC.UsePlainString is set to = false”

    What exactly does “watt.adapter.JDBC.UsePlainString” represent? I searched in forums and wM 8 documentation but could not get.


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


  • 2.  RE: watt.adapter.JDBC.UsePlainString Key

    Posted 02/18/14 04:45 PM

    when you trace, you will see many internal loggings, unless it concerns you, you probably don’t need to know.
    I guess that line referring to the way the SQL command to be passed to the server.
    If you think it causing issue or certain unexpected behavior, open ticket with SAG.


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


  • 3.  RE: watt.adapter.JDBC.UsePlainString Key

    Posted 02/18/14 04:54 PM

    Also you see those internal messages in the logs unless you have bumped up the logging level (Trace or Debug) under the Server logger…can you check that settings also?

    HTH,RMG


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


  • 4.  RE: watt.adapter.JDBC.UsePlainString Key

    Posted 02/18/14 11:32 PM

    @phdiwakar,

    My wild guess, what I got to know while working in Spring and Hibernate:

    SQL is preferred language to access the data but you can use plain text as well. There might be a parameter to set in JDBC of webMethods to switch between plain text and SQL, depending upon the RDBMS.

    Thanks,
    Rankesh


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