Skip to Content
avatar image
Former Member

xi jdbc reveiver adapter

Hi,

have somebody ever faced the situation where communication channel says ' it's allright', but there are no updates on DB?

One of the posted fields is a date-field, mapping: date=sysdate (without any hasQuot attribute), so actually sql statement must look like "update ... set date='sysdate' ..." which would throw an oracle error, but communication channel shows that the statement was posted successfully.

Question: can we rely on XI monitoring?

Thanks a lot in advance.

Elena

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Sep 24, 2010 at 09:52 AM

    >

    > look like "update ... set date='sysdate' ..."

    >

    You update statement is not correct, you are using function sysdate.

    the syntex should like :

    UPDATE ..... set date = sysdate()..."

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 24, 2010 at 11:10 AM

    for an oracle DB date=sysdate works pretty fine 😊

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2011 at 08:11 AM

    This solution has worked fine.

    Add comment
    10|10000 characters needed characters exceeded