Skip to Content
avatar image
Former Member

JDBC DATE conversion Issue

Hi All,

I am working on a Proxy to JDBC (Async to Sync) scenario in this I am passing a sender field to target and retrieving the data from data base as response

Created the Request structure as below

Statement

   Action

     Aceess

      f1

      f2

      f3

     f4

    Key

     f1

      compareOperation

     f2

      compareOperation

Mapped the source field to  f1 under key node and maintained the compare Operation as EQ and where the f2 field is the date,I have mapped it with constant( Value is GET DATE ()-90) and maintained the compare operation as GTEQ.

during run time getting issue at mapping as unable to convert the date,Could any one please help me with this.

Thanks & Regards,

AK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 26, 2015 at 07:27 AM

    Hello AK,

    You need to define of "hasQuot" attribute with value "NO" for f2 under key. GETDATE() is database function and it should not be treated as string during the execution.

    You can refer the blog below for more information on this:

    DATE/TIME datatypes and Oracle Database

    Alternatively, you can use following SQL_QUERY structure with creating the entire pl/sql statement and passing it into access element.

    <root>

      <StatementName>

      <anyName action=” SQL_QUERY”>

      <access>select f1, f2, f3, f4 from xyz where f1 = getdate() - 90</access>

      </anyName >

      </StatementName>

    </root>


    More information on this second approach is available at below link:

    Defining an SQL_QUERY Statement - Advanced Adapter Engine - SAP Library


    Add comment
    10|10000 characters needed characters exceeded

  • Aug 26, 2015 at 07:21 AM

    Hi Ak,

    You should share the exact exception and the data with your are trying to do it.

    You should use the standard functions currentDate and dateTrans. Check a few examples:

    Yes it is possible with DateTrans function!

    Mapping logic to convert Time format from 24 hours to 12 hours format in PI/XI

    Regards.

    Add comment
    10|10000 characters needed characters exceeded