public String getFindLastSequenceIdInAcksStatement() { if (findLastSequenceIdInAcksStatement == null) { findLastSequenceIdInAcksStatement = "SELECT MAX(LAST_ACKED_ID) FROM " + getFullAckTableName(); } return findLastSequenceIdInAcksStatement; }
/** * @return the lastAckedDurableSubscriberMessageStatement */ public String getLastAckedDurableSubscriberMessageStatement() { if (lastAckedDurableSubscriberMessageStatement == null) { lastAckedDurableSubscriberMessageStatement = "SELECT MAX(LAST_ACKED_ID) FROM " + getFullAckTableName() + " WHERE CONTAINER=? AND CLIENT_ID=? AND SUB_NAME=?"; } return lastAckedDurableSubscriberMessageStatement; }
public String getUpdateDurableLastAckWithPriorityStatement() { if (updateDurableLastAckWithPriorityStatement == null) { updateDurableLastAckWithPriorityStatement = "UPDATE " + getFullAckTableName() + " SET LAST_ACKED_ID=?, XID = NULL WHERE CONTAINER=? AND CLIENT_ID=? AND SUB_NAME=? AND PRIORITY=?"; } return updateDurableLastAckWithPriorityStatement; }
public String getFindDurableSubStatement() { if (findDurableSubStatement == null) { findDurableSubStatement = "SELECT SELECTOR, SUB_DEST " + "FROM " + getFullAckTableName() + " WHERE CONTAINER=? AND CLIENT_ID=? AND SUB_NAME=?"; } return findDurableSubStatement; }
public String getClearDurableLastAckInTxStatement() { if (clearDurableLastAckInTxStatement == null) { clearDurableLastAckInTxStatement = "UPDATE " + getFullAckTableName() + " SET XID = NULL WHERE CONTAINER=? AND CLIENT_ID=? AND SUB_NAME=? AND PRIORITY=?"; } return clearDurableLastAckInTxStatement; }
public String getDeleteSubscriptionStatement() { if (deleteSubscriptionStatement == null) { deleteSubscriptionStatement = "DELETE FROM " + getFullAckTableName() + " WHERE CONTAINER=? AND CLIENT_ID=? AND SUB_NAME=?"; } return deleteSubscriptionStatement; }
public String getRemoveAllSubscriptionsStatement() { if (removeAllSubscriptionsStatement == null) { removeAllSubscriptionsStatement = "DELETE FROM " + getFullAckTableName() + " WHERE CONTAINER=?"; } return removeAllSubscriptionsStatement; }
public String getSelectDurablePriorityAckStatement() { if (selectDurablePriorityAckStatement == null) { selectDurablePriorityAckStatement = "SELECT LAST_ACKED_ID FROM " + getFullAckTableName() + " WHERE CONTAINER=? AND CLIENT_ID=? AND SUB_NAME=?" + " AND PRIORITY = ?"; } return selectDurablePriorityAckStatement; }
public String getFindAcksPendingOutcomeStatement() { if (findAcksPendingOutcomeStatement == null) { findAcksPendingOutcomeStatement = "SELECT XID," + " CONTAINER, CLIENT_ID, SUB_NAME FROM " + getFullAckTableName() + " WHERE XID IS NOT NULL"; } return findAcksPendingOutcomeStatement; }
public String getCreateDurableSubStatement() { if (createDurableSubStatement == null) { createDurableSubStatement = "INSERT INTO " + getFullAckTableName() + "(CONTAINER, CLIENT_ID, SUB_NAME, SELECTOR, LAST_ACKED_ID, SUB_DEST, PRIORITY) " + "VALUES (?, ?, ?, ?, ?, ?, ?)"; } return createDurableSubStatement; }
public String getUpdateDurableLastAckStatement() { if (updateDurableLastAckStatement == null) { updateDurableLastAckStatement = "UPDATE " + getFullAckTableName() + " SET LAST_ACKED_ID=?, XID = NULL WHERE CONTAINER=? AND CLIENT_ID=? AND SUB_NAME=?"; } return updateDurableLastAckStatement; }
public String getUpdateDurableLastAckWithPriorityInTxStatement() { if (updateDurableLastAckWithPriorityInTxStatement == null) { updateDurableLastAckWithPriorityInTxStatement = "UPDATE " + getFullAckTableName() + " SET XID=? WHERE CONTAINER=? AND CLIENT_ID=? AND SUB_NAME=? AND PRIORITY=?"; } return updateDurableLastAckWithPriorityInTxStatement; }
public String getFindAllDurableSubsStatement() { if (findAllDurableSubsStatement == null) { findAllDurableSubsStatement = "SELECT SELECTOR, SUB_NAME, CLIENT_ID, SUB_DEST" + " FROM " + getFullAckTableName() + " WHERE CONTAINER=? AND PRIORITY=0"; } return findAllDurableSubsStatement; }
public String getUpdateLastPriorityAckRowOfDurableSubStatement() { if (updateLastPriorityAckRowOfDurableSubStatement == null) { updateLastPriorityAckRowOfDurableSubStatement = "UPDATE " + getFullAckTableName() + " SET LAST_ACKED_ID=?" + " WHERE CONTAINER=? AND CLIENT_ID=? AND SUB_NAME=? AND PRIORITY=?"; } return updateLastPriorityAckRowOfDurableSubStatement; }
public String getInsertDurablePriorityAckStatement() { if (insertDurablePriorityAckStatement == null) { insertDurablePriorityAckStatement = "INSERT INTO " + getFullAckTableName() + "(CONTAINER, CLIENT_ID, SUB_NAME, PRIORITY)" + " VALUES (?, ?, ?, ?)"; } return insertDurablePriorityAckStatement; }
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; }