Skip to Content
avatar image
Former Member

Insert query in JDBC Reciever adapter!!!

Hi All,

We have an interface in which we are inserting data in Oracle server using JDBC Reciever Adapter.

The interface ends up in error on adapter engine level whenever the we are sending long data in one of the field of target structure. The error which we get in communication channel monitoring is that "String too long", on googling i found that in oracle they solve such problem by making the field data type as CLOB.

Thus can we define target structure field of CLOB type so that while inserting the data in Oracle server we never face the issue of this long string.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 19, 2009 at 03:36 AM

    >

    > Hi All,

    >

    > We have an interface in which we are inserting data in Oracle server using JDBC Reciever Adapter.

    > The interface ends up in error on adapter engine level whenever the we are sending long data in one of the field of target structure. The error which we get in communication channel monitoring is that "String too long", on googling i found that in oracle they solve such problem by making the field data type as CLOB.

    >

    > Thus can we define target structure field of CLOB type so that while inserting the data in Oracle server we never face the issue of this long string.

    >

    > Thanks

    if the field contains very large data then yes, defining the target field in Oracle as a CLOB will solve your issue.

    http://www.herongyang.com/jdbc/MySQL-CLOB-Overview.html

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      Actually, the field is of type CLOB on Oracle side but in PI that is of type string so whenever it is long string we are getting error in Communication Channel. In fact we have another interface where we are calling a Stored Procedure and in that we have defined the filed of CLOB type both in PI and Oracle, so it is working perfectly. But in PI while creating the structure for INSERT query you can't define the field type as CLOB because the structure doesn't allow to do so.

      Thus, my question is there any way we can handle long data with INSERT query in PI.

      Thanks

  • May 19, 2009 at 04:56 AM

    try using a JAVA or XSL instead of graphical mapping when large amount of String is being passed in transformation. I have had to insert to CLOB and it has worked for me but mine was not a graphical mapping.. dont remember why i had to avoid it but i guess it was something on similar lines.

    Why dont you try with a java or XSL?

    Add comment
    10|10000 characters needed characters exceeded