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

  • 1.  How do I convert a string to a clob

    Posted Fri May 14, 2004 07:18 PM

    I am trying to do a simple SQL Insert into an Oracle database table that has a field of CLOB data type. I would like to be able to accept string or XML data to insert into this field with an Insert SQL adapter service. How can I convert a string to the java.sql.clob data type so I can do this?

    We are using wM 6.1 and v6.0.3 of the JDBC adapter.


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


  • 2.  RE: How do I convert a string to a clob

    Posted Tue May 18, 2004 10:17 PM

    Matt,

    You do not need to convert the String data to a CLOB. In your JDBC Insert Adapter service, make the data type for the CLOB field a String. The JDBC Adapter will do the necessary conversion for you at runtime. Also, please note that you’ll want to use the OCI driver for your JDBC connection.

    HTH


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


  • 3.  RE: How do I convert a string to a clob

    Posted Mon June 26, 2006 07:09 PM

    Hi chris,

    I have a string datatype to be inserted in a database clob field. I am using a JDBC thin driver instead of the OCI driver. would webMethods take care of the typecasting internally even when I am using the thin driver?
    Please suggest some typecasting which might be needed to make this insertion possible.


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


Related Content