| Author |
Message
|
| mqkid |
 Posted: Sat May 27, 2006 11:30 pm Post subject: MQMD.Expiry |
 |
|
Newbie
Joined: 27 May 2006
Posts: 2
|
| i am populating MQMD.Expiry(datatype GMTTIMESTAMP) with a datatype of NUMBER in Oracle database, gives me an exception in Message Broker...ny fixes? Urgetnt................... |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Sun May 28, 2006 5:05 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What's the exception?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kevinf2349 |
| Posted: Sun May 28, 2006 10:14 am Post subject: |
|
|
Grand Master
Joined: 28 Feb 2003
Posts: 1311
Location: USA
|
You aren't trying to set a date and time for the message to expire are you?
You don't set a time stamp, you give it a 'lifespan' value. This is the number of 'units' for the message to live. I say 'units' because I believe the value you actually provide is the lifespan in hundredths of a second.
This is clearly documented |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Sun May 28, 2006 11:02 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
...tenths of a second.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| kevinf2349 |
| Posted: Sun May 28, 2006 1:22 pm Post subject: |
|
|
Grand Master
Joined: 28 Feb 2003
Posts: 1311
Location: USA
|
Thanks Peter  ... and for ridding us of Cira700 or whatever they called themselves |
|
| Back to top |
|
|
|
|
