rs = s.executeQuery(); int count = 0; if (this.statements.isUseExternalMessageReferences()) { while (rs.next() && count < maxReturned) { if (listener.recoverMessageReference(rs.getString(1))) {
rs = s.executeQuery(); int count = 0; if (this.statements.isUseExternalMessageReferences()) { while (rs.next() && count < maxReturned) { if (listener.recoverMessageReference(rs.getString(1))) {
s.setString(3, subscriptionName); rs = s.executeQuery(); if (this.statements.isUseExternalMessageReferences()) { while (rs.next()) { if (!listener.recoverMessageReference(rs.getString(2))) {
@Override public void doRecover(TransactionContext c, ActiveMQDestination destination, JDBCMessageRecoveryListener listener) throws Exception { PreparedStatement s = null; ResultSet rs = null; try { s = c.getConnection().prepareStatement(this.statements.getFindAllMessagesStatement()); s.setString(1, destination.getQualifiedName()); rs = s.executeQuery(); if (this.statements.isUseExternalMessageReferences()) { while (rs.next()) { if (!listener.recoverMessageReference(rs.getString(2))) { break; } } } else { while (rs.next()) { if (!listener.recoverMessage(rs.getLong(1), getBinaryData(rs, 2))) { break; } } } } finally { close(rs); close(s); } }
if (this.statements.isUseExternalMessageReferences()) { while (rs.next() && count < maxReturned) { if (listener.recoverMessageReference(rs.getString(1))) {
+ ", MSGID_SEQ " + statements.getSequenceDataType() + ", EXPIRATION " + statements.getLongDataType() + ", MSG " + (statements.isUseExternalMessageReferences() ? statements.getStringIdDataType() : statements.getBinaryDataType()) + ", PRIMARY KEY ( ID ) )", "CREATE INDEX " + statements.getFullMessageTableName() + "_MIDX ON " + statements.getFullMessageTableName() + " (MSGID_PROD,MSGID_SEQ)",
s.setString(3, subscriptionName); rs = s.executeQuery(); if (this.statements.isUseExternalMessageReferences()) { while (rs.next()) { if (!listener.recoverMessageReference(rs.getString(2))) {
public void doRecover(TransactionContext c, ActiveMQDestination destination, JDBCMessageRecoveryListener listener) throws Exception { PreparedStatement s = null; ResultSet rs = null; cleanupExclusiveLock.readLock().lock(); try { s = c.getConnection().prepareStatement(this.statements.getFindAllMessagesStatement()); s.setString(1, destination.getQualifiedName()); rs = s.executeQuery(); if (this.statements.isUseExternalMessageReferences()) { while (rs.next()) { if (!listener.recoverMessageReference(rs.getString(2))) { break; } } } else { while (rs.next()) { if (!listener.recoverMessage(rs.getLong(1), getBinaryData(rs, 2))) { break; } } } } finally { cleanupExclusiveLock.readLock().unlock(); close(rs); close(s); } }
rs = s.executeQuery(); int count = 0; if (this.statements.isUseExternalMessageReferences()) { while (rs.next() && count < maxReturned) { if (listener.recoverMessageReference(rs.getString(1))) {
rs = s.executeQuery(); int count = 0; if (this.statements.isUseExternalMessageReferences()) { while (rs.next() && count < maxReturned) { if (listener.recoverMessageReference(rs.getString(1))) {
s.setString(3, subscriptionName); rs = s.executeQuery(); if (this.statements.isUseExternalMessageReferences()) { while (rs.next()) { if (!listener.recoverMessageReference(rs.getString(2))) {
rs = s.executeQuery(); int count = 0; if (this.statements.isUseExternalMessageReferences()) { while (rs.next() && count < maxReturned) { if (listener.recoverMessageReference(rs.getString(1))) {
rs = s.executeQuery(); int count = 0; if (this.statements.isUseExternalMessageReferences()) { while (rs.next() && count < maxReturned) { if (listener.recoverMessageReference(rs.getString(1))) {
@Override public void doRecover(TransactionContext c, ActiveMQDestination destination, JDBCMessageRecoveryListener listener) throws Exception { PreparedStatement s = null; ResultSet rs = null; try { s = c.getConnection().prepareStatement(this.statements.getFindAllMessagesStatement()); s.setString(1, destination.getQualifiedName()); rs = s.executeQuery(); if (this.statements.isUseExternalMessageReferences()) { while (rs.next()) { if (!listener.recoverMessageReference(rs.getString(2))) { break; } } } else { while (rs.next()) { if (!listener.recoverMessage(rs.getLong(1), getBinaryData(rs, 2))) { break; } } } } finally { close(rs); close(s); } }
@Override public void doRecover(TransactionContext c, ActiveMQDestination destination, JDBCMessageRecoveryListener listener) throws Exception { PreparedStatement s = null; ResultSet rs = null; try { s = c.getConnection().prepareStatement(this.statements.getFindAllMessagesStatement()); s.setString(1, destination.getQualifiedName()); rs = s.executeQuery(); if (this.statements.isUseExternalMessageReferences()) { while (rs.next()) { if (!listener.recoverMessageReference(rs.getString(2))) { break; } } } else { while (rs.next()) { if (!listener.recoverMessage(rs.getLong(1), getBinaryData(rs, 2))) { break; } } } } finally { close(rs); close(s); } }
@Override public void doRecover(TransactionContext c, ActiveMQDestination destination, JDBCMessageRecoveryListener listener) throws Exception { PreparedStatement s = null; ResultSet rs = null; try { s = c.getConnection().prepareStatement(this.statements.getFindAllMessagesStatement()); s.setString(1, destination.getQualifiedName()); rs = s.executeQuery(); if (this.statements.isUseExternalMessageReferences()) { while (rs.next()) { if (!listener.recoverMessageReference(rs.getString(2))) { break; } } } else { while (rs.next()) { if (!listener.recoverMessage(rs.getLong(1), getBinaryData(rs, 2))) { break; } } } } finally { close(rs); close(s); } }
+ ", MSGID_SEQ " + statements.getSequenceDataType() + ", EXPIRATION " + statements.getLongDataType() + ", MSG " + (statements.isUseExternalMessageReferences() ? statements.getStringIdDataType() : statements.getBinaryDataType()) + ", PRIMARY KEY ( ID ) )", "CREATE INDEX " + statements.getFullMessageTableName() + "_MIDX ON " + statements.getFullMessageTableName() + " (MSGID_PROD,MSGID_SEQ)",
+ ", MSGID_SEQ " + statements.getSequenceDataType() + ", EXPIRATION " + statements.getLongDataType() + ", MSG " + (statements.isUseExternalMessageReferences() ? statements.getStringIdDataType() : statements.getBinaryDataType()) + ", PRIMARY KEY ( ID ) )", "CREATE INDEX " + statements.getFullMessageTableName() + "_MIDX ON " + statements.getFullMessageTableName() + " (MSGID_PROD,MSGID_SEQ)",
+ ", MSGID_SEQ " + statements.getSequenceDataType() + ", EXPIRATION " + statements.getLongDataType() + ", MSG " + (statements.isUseExternalMessageReferences() ? statements.getStringIdDataType() : statements.getBinaryDataType()) + ", PRIMARY KEY ( ID ) )", "CREATE INDEX " + statements.getFullMessageTableName() + "_MIDX ON " + statements.getFullMessageTableName() + " (MSGID_PROD,MSGID_SEQ)",
+ ", MSGID_SEQ " + statements.getSequenceDataType() + ", EXPIRATION " + statements.getLongDataType() + ", MSG " + (statements.isUseExternalMessageReferences() ? statements.getStringIdDataType() : statements.getBinaryDataType()) + ", PRIMARY KEY ( ID ) )", "CREATE INDEX " + statements.getFullMessageTableName() + "_MIDX ON " + statements.getFullMessageTableName() + " (MSGID_PROD,MSGID_SEQ)",