DBAdapter Timestamp with Timezone
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