android 一个事务的sql删除和新增，sql失败后回滚

private DatabaseHelper db;

public ProductDao(Context context) {
    db = DatabaseHelper.getInstance(context);
    try {
        dao = db.getDao(ProductEntity.class);
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

/**
 * 删除所有的产品
 */
public void deleteAllProductAndUpdateData(Context context) {
    String counterCode = SharedPrefUtil.getCounterCode(context);
    AndroidDatabaseConnection connection = new AndroidDatabaseConnection(db.getWritableDatabase(),true);

    try {
        dao.setAutoCommit(connection,false);
        dao.startThreadConnection();
        dao.executeRaw("delete from WPM_products where type = 'PROD' and counter_id = '" + counterCode + "'");
        StringBuffer sb = new StringBuffer();
        sb.append("INSERT INTO ");
        sb.append("       WPM_products ");
        sb.