« Return to Thread: MalformedEndpointException

RE: MalformedEndpointException

by Jan-Olav :: Rate this Message:

Some parts of this message have been removed. Learn more about Nabble's security policy.

Have you tried using the TO_DATE Oracle function instead of using the date as string directly? I think you may see some issues with the TNS_DATE_FORMAT value of your session. (it may not be set in your case)

From: Tim Schraepen [mailto:sch3lp@...]
Sent: 13. april 2007 15:45
To: user@...
Subject: Re: [mule-user] MalformedEndpointException

My first guess would be the ":" that mark the separators between hours, minutes and seconds.
I think they're being "misinterperated" by the connector.

On 4/13/07, acw <andreas.willadsen@...> wrote:

When i try to fire this sql aganst Oracle
jdbc://SELECT%*%20FROM%20CATS_OWNER.V_CATS_CPH_WWW_SUBSCRIBE%20WHERE%20(FLT_TYPE%20in%20('B','C','G','J','S')%20AND%20PUBLIC_ROLL_OFF%20=%200)%20AND%20SCHEDULE_TM%20>=%20'2007-04-13%2012:16:40'%20AND%20SCHEDULE_TM%20<=%20'2007-04-13%2014:16:40'

i get an org.mule.umo.endpoint.MalformedEndpointException.

This sql works perfectly in sql+ and TOra.

The problem only comes when i add the last two conditions, SCHEDULE_TM >=
'2007-04-13 12:16:40' AND SCHEDULE_TM <= '2007-04-13 14:16:40'
...SCHEDULE_TM is a Date field.

What's wrong with inserting dates this way?
--
View this message in context: http://www.nabble.com/MalformedEndpointException-tf3571684.html#a9979137
Sent from the Mule - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe from this list please visit:

http://xircles.codehaus.org/manage_email

« Return to Thread: MalformedEndpointException