private void executeUpsert(Connection connection, MarshalledEntry entry, String keyStr, int segment) throws InterruptedException, SQLException { PreparedStatement ps = null; String sql = tableManager.getUpsertRowSql(); if (trace) { log.tracef("Running sql '%s'. Key string is '%s'", sql, keyStr); } try { ps = connection.prepareStatement(sql); prepareUpsertStatement(entry, keyStr, segment, ps); ps.executeUpdate(); } finally { JdbcUtil.safeClose(ps); } }
if (upsertSupported) { String keyStr = key2Str(entry.getKey()); prepareUpsertStatement(entry, keyStr, segment, upsertBatch); upsertBatch.addBatch(); } else {
for (MarshalledEntry entry : marshalledEntries) { String keyStr = key2Str(entry.getKey()); prepareUpsertStatement(entry, keyStr, getSegment(entry), upsertBatch); upsertBatch.addBatch(); batchSize++;