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

how to typecast a string field to clob/blob in oracle db using wemethods 8

  • 1.  how to typecast a string field to clob/blob in oracle db using wemethods 8

    Posted Mon January 16, 2012 04:53 PM

    my scenario:

    I need to insert a huge xml file(it can be off any size) in to oracle table.
    Do I need to need use glob/clob datatype for this field.
    if yes,how to do typecasting of a string field to clob/blob.

    is their any other better way than using clob/blob.

    Please advice ?


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


  • 2.  RE: how to typecast a string field to clob/blob in oracle db using wemethods 8

    Posted Mon January 16, 2012 07:05 PM

    I am not sure if this will work but try creating a column of type clob and then create a java service to convert a string to a clob value using the setCharecterStream method described at below URL.

    map that object to the JDBC adapter input clob object and see if it works!

    cheers,
    Akshith


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


  • 3.  RE: how to typecast a string field to clob/blob in oracle db using wemethods 8

    Posted Mon January 16, 2012 09:41 PM

    Review the JDBC Adapter User’s Guide. It defines the mappings the adapters support between CLOB/BLOB and Java data types.


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


Related Content