In a channel 'Database Reader' -> 'LLP Sender' I use this query, in javascript source pannel, to select "messages to send" :
SELECT IDLINK,OR_ERRORCNT,EVENT_CODE,to_char(SYSDATE,'yyy ymmddHH24miss') AS eventdate FROM THL_ORM where OR_STATUS='0' order by IDLINK
I note that messages aren't sent in idlink order.
Whith this query:
SELECT IDLINK,OR_ERRORCNT,EVENT_CODE,to_char(SYSDATE,'yyy ymmddHH24miss') AS eventdate FROM THL_ORM where OR_STATUS='0' AND rownum < 2 order by IDLINK
Messages are obviously sent ordered.
Enviroment:
Mirth 1.6
Oracle 9.2
Win XP
SELECT IDLINK,OR_ERRORCNT,EVENT_CODE,to_char(SYSDATE,'yyy ymmddHH24miss') AS eventdate FROM THL_ORM where OR_STATUS='0' order by IDLINK
I note that messages aren't sent in idlink order.
Whith this query:
SELECT IDLINK,OR_ERRORCNT,EVENT_CODE,to_char(SYSDATE,'yyy ymmddHH24miss') AS eventdate FROM THL_ORM where OR_STATUS='0' AND rownum < 2 order by IDLINK
Messages are obviously sent ordered.
Enviroment:
Mirth 1.6
Oracle 9.2
Win XP
Comment