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.  JDBC Adapter Connection

    Posted 11/15/14 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 11/16/14 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 11/16/14 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 11/17/14 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 11/17/14 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 11/17/14 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