public String getAddMessageStatement() { if (addMessageStatement == null) { addMessageStatement = "INSERT INTO " + getFullMessageTableName() + "(ID, MSGID_PROD, MSGID_SEQ, CONTAINER, EXPIRATION, PRIORITY, MSG, XID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"; } return addMessageStatement; }
public String getFindAllMessagesStatement() { if (findAllMessagesStatement == null) { findAllMessagesStatement = "SELECT ID, MSG FROM " + getFullMessageTableName() + " WHERE CONTAINER=? ORDER BY ID"; } return findAllMessagesStatement; }
public String getFindXidByIdStatement() { if (findXidByIdStatement == null) { findXidByIdStatement = "SELECT XID FROM " + getFullMessageTableName() + " WHERE ID=?"; } return findXidByIdStatement; }
public String getFindOpsPendingOutcomeStatement() { if (findOpsPendingOutcomeStatement == null) { findOpsPendingOutcomeStatement = "SELECT ID, XID, MSG FROM " + getFullMessageTableName() + " WHERE XID IS NOT NULL ORDER BY ID"; } return findOpsPendingOutcomeStatement; }
public String getFindMessageSequenceIdStatement() { if (findMessageSequenceIdStatement == null) { findMessageSequenceIdStatement = "SELECT ID, PRIORITY FROM " + getFullMessageTableName() + " WHERE MSGID_PROD=? AND MSGID_SEQ=? AND CONTAINER=?"; } return findMessageSequenceIdStatement; }
public String getFindAllMessageIdsStatement() { // this needs to be limited maybe need to use getFindLastSequenceIdInMsgsStatement // and work back for X if (findAllMessageIdsStatement == null) { findAllMessageIdsStatement = "SELECT ID, MSGID_PROD, MSGID_SEQ FROM " + getFullMessageTableName() + " ORDER BY ID DESC"; } return findAllMessageIdsStatement; }
public String getLastProducerSequenceIdStatement() { if (lastProducerSequenceIdStatement == null) { lastProducerSequenceIdStatement = "SELECT MAX(MSGID_SEQ) FROM " + getFullMessageTableName() + " WHERE MSGID_PROD=?"; } return lastProducerSequenceIdStatement; }
public String getUpdateMessageStatement() { if (updateMessageStatement == null) { updateMessageStatement = "UPDATE " + getFullMessageTableName() + " SET MSG=? WHERE MSGID_PROD=? AND MSGID_SEQ=? AND CONTAINER=?"; } return updateMessageStatement; }
public String getRemoveMessageStatement() { if (removeMessageStatement == null) { removeMessageStatement = "DELETE FROM " + getFullMessageTableName() + " WHERE ID=?"; } return removeMessageStatement; }
public String getUpdateXidFlagStatement() { if (updateXidFlagStatement == null) { updateXidFlagStatement = "UPDATE " + getFullMessageTableName() + " SET XID = ? WHERE ID = ?"; } return updateXidFlagStatement; }
public String getFindMessageByIdStatement() { if (findMessageByIdStatement == null) { findMessageByIdStatement = "SELECT MSG FROM " + getFullMessageTableName() + " WHERE ID=?"; } return findMessageByIdStatement; }
public String getFindLastSequenceIdInMsgsStatement() { if (findLastSequenceIdInMsgsStatement == null) { findLastSequenceIdInMsgsStatement = "SELECT MAX(ID) FROM " + getFullMessageTableName(); } return findLastSequenceIdInMsgsStatement; }
public String getRemoveAllMessagesStatement() { if (removeAllMessagesStatement == null) { removeAllMessagesStatement = "DELETE FROM " + getFullMessageTableName() + " WHERE CONTAINER=?"; } return removeAllMessagesStatement; }
/** * @return the findNextMessagesStatement */ public String getFindNextMessagesStatement() { if (findNextMessagesStatement == null) { findNextMessagesStatement = "SELECT ID, MSG FROM " + getFullMessageTableName() + " WHERE CONTAINER=? AND ID < ? AND ID > ? AND XID IS NULL ORDER BY ID"; } return findNextMessagesStatement; }
public String getClearXidFlagStatement() { if (clearXidFlagStatement == null) { clearXidFlagStatement = "UPDATE " + getFullMessageTableName() + " SET XID = NULL, ID = ? WHERE ID = ?"; } return clearXidFlagStatement; }
public String getFindAllDurableSubMessagesStatement() { if (findAllDurableSubMessagesStatement == null) { findAllDurableSubMessagesStatement = "SELECT M.ID, M.MSG FROM " + getFullMessageTableName() + " M, " + getFullAckTableName() + " D " + " WHERE D.CONTAINER=? AND D.CLIENT_ID=? AND D.SUB_NAME=?" + " AND M.CONTAINER=D.CONTAINER AND M.ID > D.LAST_ACKED_ID" + " ORDER BY M.PRIORITY DESC, M.ID"; } return findAllDurableSubMessagesStatement; }
public String getFindDurableSubMessagesStatement() { if (findDurableSubMessagesStatement == null) { findDurableSubMessagesStatement = "SELECT M.ID, M.MSG FROM " + getFullMessageTableName() + " M, " + getFullAckTableName() + " D " + " WHERE D.CONTAINER=? AND D.CLIENT_ID=? AND D.SUB_NAME=?" + " AND M.XID IS NULL" + " AND M.CONTAINER=D.CONTAINER AND M.ID > D.LAST_ACKED_ID" + " AND M.ID > ?" + " ORDER BY M.ID"; } return findDurableSubMessagesStatement; }
public String getFindAllDestinationsStatement() { if (findAllDestinationsStatement == null) { findAllDestinationsStatement = "SELECT DISTINCT CONTAINER FROM " + getFullMessageTableName() + " WHERE CONTAINER IS NOT NULL UNION SELECT DISTINCT CONTAINER FROM " + getFullAckTableName(); } return findAllDestinationsStatement; }
public String getNextDurableSubscriberMessageStatement() { if (nextDurableSubscriberMessageStatement == null) { nextDurableSubscriberMessageStatement = "SELECT M.ID, M.MSG FROM " + getFullMessageTableName() + " M, " + getFullAckTableName() + " D " + " WHERE D.CONTAINER=? AND D.CLIENT_ID=? AND D.SUB_NAME=?" + " AND M.CONTAINER=D.CONTAINER AND M.ID > ?" + " ORDER BY M.ID "; } return nextDurableSubscriberMessageStatement; }
public String[] getDropSchemaStatements() { if (dropSchemaStatements == null) { dropSchemaStatements = new String[] {"DROP TABLE " + getFullAckTableName() + "", "DROP TABLE " + getFullMessageTableName() + "", "DROP TABLE " + getFullLockTableName() + ""}; } return dropSchemaStatements; }