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.  No ResultSet set was produced

    Posted 07/07/04 04:19 PM

    I am facing this error in a IC

    ‘Adapter’: ‘JDBC’

    ‘Error Category’: ‘Adapter’

    ‘Error Text’: ‘(316) Could not execute SQL statement “SELECT t1.SP_No, t1.stores_Date, t1.measured_TI, t1.measured_SDR, t1.measured_weight, t1.error_code, t1.error_description, t1.business_stream, t1.wm_rowid FROM WMB_WSC_JDBC01_WSCNotification t1 ORDER BY wm_rowid”.
    (HY000/0) [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.’


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


  • 2.  RE: No ResultSet set was produced

    Posted 08/20/04 07:38 PM

    Try to use Custom SQL for the same.
    if u still face the problem, pls try to explain it little more.
    Custom SQL should work.


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


Related Content