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.


#TechXchangePresenter
 View Only
  • 1.  JDBC Adapter Connection

    Posted Sat November 15, 2014 12:27 PM

    Hi

    I want to create JDBC Adapter connection. I used “com.dd.jdbcx.sqlserver.SQLServerDataSource” datsource calss.
    When I try to enable Adapter connection it gives error: Data source class not found.

    Can anyone answer why this error is comming and solution for this error.

    Thanks in advance. :slight_smile:


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


  • 2.  RE: JDBC Adapter Connection

    Posted Sun November 16, 2014 12:55 AM

    Make sure you place the jars file within Integration Server/WmJDBC adapter. What is your IS version? What type of database are you trying to connect?

    Refer webMethods_Adapters_System_Requirements


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


  • 3.  RE: JDBC Adapter Connection

    Posted Sun November 16, 2014 01:38 AM

    Hi There,

    I guess you are using SQL server DB. In case yes, instead of using “dd” try to use “ddtek” in “com.wm.dd.jdbcx.sqlserver.SQLServerDataSource”. If you still get the error change from XA_TRANSACTION to LOCAL_TRANSACTION. Please try the above options and let us know result.

    Thanks,


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


  • 4.  RE: JDBC Adapter Connection

    Posted Mon November 17, 2014 07:23 AM

    Hi
    I tried the above option. However it is not working.


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


  • 5.  RE: JDBC Adapter Connection

    Posted Mon November 17, 2014 07:54 AM

    As I suggested earlier install the required jdbc drivers.


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


  • 6.  RE: JDBC Adapter Connection

    Posted Mon November 17, 2014 10:36 AM

    Hi Niraj,

    Did you encounter any errors after changing details as I said and if yes kindly share the logs to better suggest to get rid of this issue.

    Thanks,


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