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

JDBC adapter service problem with SQL2005

  • 1.  JDBC adapter service problem with SQL2005

    Posted Mon March 24, 2008 09:28 PM

    Hi All,
    I’m calling stored procedure using JDBC adapter service (stored proc with signature). The strange thing is when I deploy the package containing the adapter service to another server. The name of the stored proc is appended by ;1(E.g. stored proc name on Server A=abc, after deploying on server B the stored proc name becomes abc;1) and in some cases the name changes all together pointing so some other stored procedure in the database.I would appreciate any inputs to fix this problem
    Environment
    Integration server: 6.1
    Updates:
    IS_6-1_SP2
    TNS_6-1_SP1
    JDBC adapter version: 6.0.3
    Database I’m connecting to MS SQL 2005
    Note: There is firewall between our organization and the client(SQL2005).The adapter connection is enable without any errors.
    Thank you,
    Salvo.


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


  • 2.  RE: JDBC adapter service problem with SQL2005

    Posted Tue March 25, 2008 08:59 PM

    The problem was fixed… there was discrepancy in JDBC drivers.


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


Related Content