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.  JDBC Stored Procedure

    Posted Tue May 06, 2003 10:02 AM

    I am trying to call a stored Procedure form JDBC Adapter 6.0.1 and I am returned:

    com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service AodsJdbc.DatabaseServices.osqwautg.StoredProcedures:sp_PivotHistoryReadings.
    [ADA.1.316] Cannot execute the SQL statement “{call aods.dbo.sp_PivotHistoryReadings (?, ?, ?, ?, ?) }”. "
    (HY000/7391) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The operation could not be performed because the OLE DB provider ‘MSDAORA’ was unable to begin a distributed transaction." [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The operation could not be performed because the OLE DB provider ‘MSDAORA’ was unable to begin a distributed transaction.
    at com.wm.pkg.art.ns.AdapterServiceNode.invokeService(AdapterServiceNode.java:618)
    at com.wm.pkg.art.ns.ARTNSService.baseInvoke(ARTNSService.java:46)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:339)
    at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:85)
    at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:167)
    at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:203)
    at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
    at java.lang.Thread.run(Thread.java:479)

    Can anyone tell me what this error means?

    (I have a simple stroed procedure that works fine… same server same database, different tables)

    Thanks


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