while (rs.next()) {
long id = rs.getLong(1);
tid = new TransactionUID(id);
int state = rs.getInt(2);
TransactionState txnState = (TransactionState)Util.readObject(rs, 3);
if(DEBUG)
{
String msg = "reading transaction from old format: state="+state+
" txnState = "+txnState;
logger.log(Logger.DEBUG, msg);
}
txnState.setState(state);
// insert in new table
try {
pstmt.setLong( 1, id );
pstmt.setInt( 2, TransactionInfo.TXN_LOCAL );
pstmt.setInt( 3, state );
pstmt.setInt( 4, txnState.getType().intValue() );
JMQXid jmqXid = txnState.getXid();
if ( jmqXid != null ) {
pstmt.setString( 5, jmqXid.toString() );
} else {
pstmt.setNull( 5, Types.VARCHAR );
}
Util.setObject( pstmt, 6, txnState );
Util.setObject( pstmt, 7, null );
Util.setObject( pstmt, 8, null );
pstmt.setLong( 9, storeSessionID );
pstmt.setLong( 10, txnState.getExpirationTime() );
pstmt.setLong( 11, txnState.getLastAccessTime() );
if (dobatch) {
pstmt.addBatch();
} else {
pstmt.executeUpdate();