| Author |
Message
|
| UrsusMajor |
 Posted: Wed Aug 09, 2006 7:44 am Post subject: reading DateTime |
 |
|
Newbie
Joined: 28 Jul 2005
Posts: 5
Location: Slovakia
|
Hi,
I have some strange problem when I want to read "long datetime" from input message.
I have defined messageset within message containing element "TestDateTime". I have set runtime parser of messageset to "MRM". In physical properties of messageset I set "Datetime settings" to "Derive default dateime format from logical type" (default). Then I change physical properties of "TestDateTime" element to "yy-MM-dd'T'HH:mm:ss.SSSSSS".
But when I put test message "06-08-08'T'12:30:40.123456" it reads only "06-08-08-'T'12:30:40.456" (in miliseconds section it reads only last 3 digits, doesn't matter if there is pattern "SSS" ... "SSSSSS" always only last 3)
Anyone any idea whats wrong ?
Thx a lot
P.S. I have tried CWF and XML wire formats... both the same. In CWF there is one more strange thing : when input is ... x.000000 it cut all "zeroes" and generate error due to incorrect input vs. pattern ... |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Aug 09, 2006 7:56 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What version?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| UrsusMajor |
| Posted: Wed Aug 09, 2006 8:07 am Post subject: |
|
|
Newbie
Joined: 28 Jul 2005
Posts: 5
Location: Slovakia
|
| jefflowrey wrote: |
| What version? |
Sorry I forgot ... AIX ver. 5.0.1.7 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 09, 2006 8:08 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What version of broker.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| UrsusMajor |
| Posted: Wed Aug 09, 2006 8:12 am Post subject: |
|
|
Newbie
Joined: 28 Jul 2005
Posts: 5
Location: Slovakia
|
| jefflowrey wrote: |
| What version of broker. |
AIX system -> broker version 5.0.1.7
right now testing on Windows system same broker version. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 09, 2006 8:30 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Okay, looking a little closer...
You've got the T in there, that indicates that you're using an ISO8601 time format, which only supports three digits of SSS.
I think.
Open a PMR. I've heard of the same missing zero problem in v6.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ghada |
| Posted: Thu Aug 10, 2006 1:57 am Post subject: |
|
|
Apprentice
Joined: 13 Oct 2005
Posts: 41
Location: Egypt
|
Hi UrsusMajor
In the messageSet.mset file
in the physical format properities of the XML put
Use Default Date Time Format to: 'I'
this type accepts many date formats I tried your date format and it was successfuly parsed.
I hope it helps
Ghada |
|
| Back to top |
|
|
| UrsusMajor |
| Posted: Thu Aug 10, 2006 4:46 am Post subject: |
|
|
Newbie
Joined: 28 Jul 2005
Posts: 5
Location: Slovakia
|
Hello,
I really appreciate your response, but I have no clue what do you mean with
| ghada wrote: |
Use Default Date Time Format to: 'I'
|
Could you please explain it little bit more...
Thx
P.S. FixPack 08 didn't solve it ... I'll open PMR with IBM at monday... |
|
| Back to top |
|
|
| ghada |
| Posted: Sat Aug 12, 2006 10:58 pm Post subject: |
|
|
Apprentice
Joined: 13 Oct 2005
Posts: 41
Location: Egypt
|
hi
I mean
go to your messageset project
click on the messageset.mset
on physical properities click on the physical properity for example "XML1"
On the field " Use default date time format" set its value to "I"
its a format in the broker that accepts many formats of dateTime
I copied these lines from IBM support pac "IA96_0604" to show how to configure the physical property
* Check 'Suppress DOCTYPE'.
* Set Root Tag Name to blank.
* Uncheck 'Enable Versioning Support'.
* Click 'Use default dateTime Format' and set value to I.
* Check 'Strict DateTime checking'.
* Set Time Zone to GMT-05:00 (New York).
Try it, I hope it helps
Ghada |
|
| Back to top |
|
|
|
|
