String getAllMsgFromOldSQL = strBuf.toString();
Statement stmt = null;
ResultSet rs = null;
Packet msg = null;
String oldMsgID = null;
Exception myex = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery( getAllMsgFromOldSQL );
while (rs.next()) {
oldMsgID = rs.getString(1);
msg = new Packet(false);
msg.generateTimestamp(false);
msg.generateSequenceNumber(false);
InputStream is = useBlob ?
rs.getBlob(2).getBinaryStream() : rs.getBinaryStream(2);
msg.readPacket(is);
is.close();
SysMessageID sysMsgID = msg.getSysMessageID();
String dstID = rs.getString(3);
long createdTS = createdTS = rs.getLong(4);
if ( createdTS == 0 ) {
createdTS = sysMsgID.getTimestamp();
}
msgDAO.insert( conn, dstID, msg, null, null,
storeSessionID, createdTS, false );
String newMsgID = sysMsgID.toString();
oldIDToNewID.put(oldMsgID, newMsgID);
msgToDst.put(newMsgID, dstID);
}
} catch (Exception e) {
myex =e;
String errorMsg = br.getKString(
BrokerResources.X_JDBC_UPGRADE_MESSAGES_FAILED,
(msg == null ? oldMsgID : msg.getSysMessageID().toString()));
logger.logStack(Logger.ERROR, errorMsg, e);
throw new BrokerException(errorMsg, e);
} finally {
Util.close( rs, stmt, null, myex );
}