MessageDAO

public interface MessageDAO extends DAO
Author:Donahue Sze, Twinsen Tsang (modifiers)

Methods

addMessage

public void addMessage(MessageDVO data)

deleteMessage

public void deleteMessage(MessageDVO data)

findInboxPendingMessagesByTimestamp

public List findInboxPendingMessagesByTimestamp(MessageDVO messageDVO)

findInboxReadyMaxSequenceNoByCpa

public int findInboxReadyMaxSequenceNoByCpa(MessageDVO data)

findMaxSequenceGroupByMessageBoxAndCpa

public int findMaxSequenceGroupByMessageBoxAndCpa(MessageDVO data)

findMaxSequenceNoByMessageBoxAndCpa

public int findMaxSequenceNoByMessageBoxAndCpa(MessageDVO data)

findMessage

public boolean findMessage(MessageDVO data)

findMessageByCpa

public List findMessageByCpa(MessageDVO data, int numberOfMessage)

findMessagesBeforeTime

public List findMessagesBeforeTime(int time_period)

findMessagesByHistory

public List findMessagesByHistory(MessageDVO data, int numberOfMessage, int offset)

findMessagesByTime

public List findMessagesByTime(int time_period, MessageDVO data, int numberOfMessage, int offset)

findNumOfMessagesByMessageBoxAndCpaAndSequenceGroup

public int findNumOfMessagesByMessageBoxAndCpaAndSequenceGroup(MessageDVO data)

findNumberOfMessagesByHistory

public int findNumberOfMessagesByHistory(MessageDVO data)

findOrderedMessageByMessageBoxAndCpaAndSequenceGroupAndSequenceNo

public boolean findOrderedMessageByMessageBoxAndCpaAndSequenceGroupAndSequenceNo(MessageDVO data)

findOrderedMessagesByMessageBoxAndCpaAndStatus

public List findOrderedMessagesByMessageBoxAndCpaAndStatus(MessageDVO data)

findOutboxPendingMessagesByTimestamp

public List findOutboxPendingMessagesByTimestamp(MessageDVO messageDVO)

findOutboxProcessingMessagesByTimestamp

public List findOutboxProcessingMessagesByTimestamp(MessageDVO messageDVO)

findRefToMessage

public boolean findRefToMessage(MessageDVO data)

updateMessage

public boolean updateMessage(MessageDVO data)

updateTimedOutMessageStatus

public int updateTimedOutMessageStatus(String status, Date currentTime)

Update the status of all timed-out message to status. A message is considered as timed-out if the timeout timestamp is earlier than the currentTime.

Throws:
  • DAOException – When status is null or Error in persistence connectivity.

See also: hk.hku.cecid.ebms.spa.dao.MessageDVO.getTimeoutTimestamp(), hk.hku.cecid.ebms.spa.dao.MessageDVO.setTimeoutTimestamp(java.sql.Timestamp)