Oracle SOA Suite (MOSC)

MOSC Banner

DBAdapter Timestamp with Timezone

edited Nov 11, 2018 4:00AM in Oracle SOA Suite (MOSC) 1 commentAnswered

We have a Oracle database  table column which is defined as TIMESTAMP WITH TIME ZONE . I

n the SOA Composite where we have defined the DBAdapter configuration, the wizard creates following type of mapping configuration :

<attribute-mapping xsi:type="direct-mapping">

               <attribute-name>createdAt</attribute-name>

               <field table="TIMESTAMP_TEST" name="CREATED_AT" xsi:type="column"/>

               <attribute-classification>java.sql.TIMESTAMPTZ</attribute-classification>

</attribute-mapping>

but in order to preserve the Timezone we changed the configuration as following

<attribute-mapping xsi:type="direct-mapping">

               <attribute-name>createdAt</attribute-name>

               <field table="TIMESTAMP_TEST" name="CREATED_AT" xsi:type="column"/>

               <attribute-classification>oracle.sql.TIMESTAMPTZ</attribute-classification>

</attribute-mapping>

But the change gave following error. Does anybody know any solution for this?  I did find this link but we are using 12.2.1.1.0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center