« Return to Thread: MalformedEndpointException

MalformedEndpointException

by acw :: Rate this Message:

Reply to Author | View in Thread

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?

 « Return to Thread: MalformedEndpointException