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
Expand all | Collapse all

End Of TNS Channel while using JDBC adapter

  • 1.  End Of TNS Channel while using JDBC adapter

    Posted Tue November 08, 2005 06:31 AM

    Hi

    While trying to insert data ( BLOB) using the JDBC adapter, i get the error message
    “[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service RsUtil.differenceEngine.db.AdapterServices:insertBlobData.
    [ADA.1.316] Cannot execute the SQL statement “INSERT INTO SWOOD_CAND_DATA_NEW (id,check_sum,length,data) VALUES (‘50073779’, 3382132632, 7319,?)”. "
    (17002) Io exception: End of TNS data channel”
    Io exception: End of TNS data channel

    Can you please let me know

    1. What is the data limitation for BLOBS using the thin driver?.
    2. Can we use oci drivers for if the data limit exceeds the limitations?
    3. Is there any other way to insert huge data using the thin driver.?

    Thanks in advance


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


  • 2.  RE: End Of TNS Channel while using JDBC adapter

    Posted Wed November 09, 2005 05:46 AM