MQSeries.net :: View topic - Invaid lexical representation(timestamp 2012-12-22 00:00:0)

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Invaid lexical representation(timestamp 2012-12-22 00:00:0)

Invaid lexical representation(timestamp 2012-12-22 00:00:0)

« View previous topic :: View next topic »

Author

Message

gheekshike

Posted: Mon Mar 10, 2014 7:00 am Post subject: Invaid lexical representation(timestamp 2012-12-22 00:00:0)

Novice

Joined: 13 Dec 2012
Posts: 11

I am using WMB version 8.0.0.1
In mapping node im trying to import the java method.
Im able to call the java method. The thing is In coming value is date(2012-12-22) need to conver into timestamp for that im using java method.
But im getting Invaid lexical representation(timestamp 2012-12-22 00:00:0)
probem. If retrun Time stamp from java also getting same problem.

Plz seggest me what is the reason behind this error.

Thanks in Adavnce

smdavies99

Posted: Mon Mar 10, 2014 8:49 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Is there any reason why you are using Java for something that is very simple in ESQL?

In any event, with this bit

timestamp 2012-12-22 00:00:0

should it not be

timestamp 2012-12-22 00:00:00

?????
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

kimbert

Posted: Mon Mar 10, 2014 9:01 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

This is nothing to do with the Mapping node. It's a Java question, and Google should be able to help you to find the answer.

Have you tried searching for the error message using your favourite search engine?
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too.

gheekshike

Posted: Mon Mar 10, 2014 9:19 am Post subject:

Novice

Joined: 13 Dec 2012
Posts: 11

Thank you for your response.

Actuallu in our project we using Mapping nodes for forming the request for stored procedure cal.. we are getting the date from input(like 20012-12-22)..
but in SP is expecting timestamp value.
here the problem is in mapping we used convert.. but its converting the data in 2 ways... sometimes like 'TIMESTAMP' 2012-12-22'' and 2012-12-22T00:00:00

This is the problem im facing...
Here I need 2012-12-22 00:00:00 format.

can anyone help?
thanks in advance.

smdavies99

Posted: Mon Mar 10, 2014 11:29 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

There are a number of posts on this very forum that cover your problem. Well apart from the majority of those posts use ESQL to solve the problem.
In ESQL is very easy to convert from 2012-12-22T00:00:00 to 2012-12-22 00:00:00 and to a multitude of other formats.

I take it that '20012-12-22' is a typo on your part?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Invaid lexical representation(timestamp 2012-12-22 00:00:0)

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP