This discussion is archived
4 Replies Latest reply: Sep 12, 2013 11:01 PM by S.Ananth RSS

Database adapter - timezone value not being picked up

961903 Newbie
Currently Being Moderated

We are using Oracle SOA suite v 11.1.1.6, along with database adapter to connect to different Oracle database - D1 and D2. All 3 system - SOA suite, D1 and D2 are set to different timezones. Within the SOA composite, we are using Database adapter to

  1. query data from Oracle database
  2. execute pl/sql stored procedure in Oracle database.

 

In all cases we noticed that the date time data seen in the SOA EM console is same as in the respective database system, but surprisingly the timezone value in the data field is constant and it does matches with that of SOA suite.

 

 

<D1_DATE>2013-08-15T01:10:00.000-06:00</D1_DATE>
<D2_DATE>2013-08-15T02:10:00.000-06:00</D2_DATE>
Ideally the timezone value should match with that of respective database, from where the date value is being picked up. Did we miss any set up or this a known issue ?
Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points