Date Format ErrorUrgent Help Needed

, , ,
1

Hi,

I am a webMethods rookie…Can anybody tell me how to solve this problem…

I am inserting the data into oracle and before insertion I am converting the date to oracle format…i.e.,

Original DateField(Registration_Date)--------- 20041118(yyyyMMdd)
So I used datetimeformat of wMPublic to convert the date to oracle format i.e., yyyy-MM-dd hh:mm:ss

Now when I am trying to insert I am getting the below error…Can u tell me what date format oracle is expecting…

An error occurred while tracing. com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service newcorp.fpl.TeleMarketing.db:insertWhTransaction.
[ADA.1.314] Cannot set data for the input field “REGISTRATION_DATE”
Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff

2

Ghanasyam,

Please check this link,a similar kind of issue
[url=“wmusers.com”]wmusers.com

And make sure you are not doing like srivats mistake and finally he found the bug in the mapping itself.

This is sure a mapping problem not related to JDBC Adapter or Oracle.

HTH,
RMG

3

RMG,

I resolved this issue. I used the below format.
yyyy-MM-dd 00:00:01 a

Thank You,

Ghanasyam

4

yes this format works yyyy-MM-dd HH:mm:ss.

Glad you solved.