How JDBC Control converts Date to XML document In Terms of Format

(Doc ID 1348294.1)

Last updated on AUGUST 16, 2016

Applies to:

BEA WebLogic Workshop - Version All and later
Information in this document applies to any platform.

Symptoms

When you try to run a simple Webservice calling a JDBC control to read a date from DB to an XML document, this is the following output displayed:

Test WSR: <wsr:WSR xmlns:wsr="http://www.bea.com/WSR"><wsr:WSR_DATA><wsr:ZWC>TEST</wsr:ZWC><wsr:PON>CALENDAR038</wsr:PON><wsr:DT_SENT>2011-08-01 08:54:29.0</wsr:DT_SENT><wsr:QTY>-1</wsr:QTY><wsr:SERVICE_REQ_TYPE>PREM</wsr:SERVICE_REQ_TYPE><wsr:SERVICE_TYPE>WIPS_PremToPremMegalink</wsr:SERVICE_TYPE><wsr:CKT_OPT_1/><wsr:CKT_OPT_2/><wsr:CKT_OPT_3/><wsr:CKT_OPT_4/><wsr:CKT_OPT_5/><wsr:CKT_OPT_6/><wsr:CKT_OPT_7/><wsr:CKT_OPT_8/><wsr:RPON/><wsr:ORIG_FNAME>WSC</wsr:ORIG_FNAME><wsr:ORIG_LNAME>
USER 1</wsr:ORIG_LNAME><wsr:ORIG_TN_AREA>213</wsr:ORIG_TN_AREA><wsr:ORIG_TN_EXCH>457</wsr:ORIG_TN_EXCH><wsr:ORIG_TN_NUM>3456</wsr:ORIG_TN_NUM><wsr:ORIG_EMAIL>SYLVIA.SMITH2@BELLSOUTH.COM</wsr:ORIG_EMAIL><wsr:CUST_NAME>AT&T INTERNAL</wsr:CUST_NAME><wsr:CKT_1/><wsr:CKT_2/><wsr:CKT_3/><wsr:CKT_4

got from the testJDBCControl print out:
<wsr:DT_SENT>2011-08-01 08:54:29.0</wsr:DT_SENT>


Instead of the expected datetime format:
2011-12-29T00:00:00-05:00

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms