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
Back to discussions
Expand all | Collapse all

JDBC adaptor service throwing an error while calling stored procedure

  • 1.  JDBC adaptor service throwing an error while calling stored procedure

    Posted Mon June 06, 2011 10:55 AM

    Hi All,

    I am getting the below error when an adapter service calls a stored procedure.
    I can run all other sql statements select, insert and update without any issues.

    com.wm.pkg.art.error.DetailedServiceException:[ART.117.4002}Adapter Runtime(Adapter Service): Unable to invoke adapter service TEST.adapters:wm_test [ART.114.505 ] Error while invoking adapter service com.wm.adapter.emjdbc.services.StoredProcedure.null at com.wm.pkg.art.error.DetaileServiceException.create

    Database used : SQL server 2000.
    webMethods server : 6.5 with SP1

    Also placed the three jar files and restarted the server.
    1.mssqlserver.jar
    2.msutil.jar
    3.msbase.jar

    Still seeing the same issue.

    Please help me.

    Thanks!!!
    Renuka


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


  • 2.  RE: JDBC adaptor service throwing an error while calling stored procedure

    Posted Mon June 06, 2011 01:06 PM

    Check if you can execute strored proc directly from passing input directly. If it is giving proper results ?


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


Related Content