快捷導(dǎo)航

關(guān)于MyBatisSystemException異常產(chǎn)生的原因及解決過(guò)程

更新時(shí)間：2025年01月23日 17:14:57 作者：宣布無(wú)人罪

文章講述了在使用MyBatis進(jìn)行數(shù)據(jù)庫(kù)操作時(shí)遇到的異常及其解決過(guò)程,首先考慮了事務(wù)問(wèn)題,但未解決,接著懷疑是MyBatis的一級(jí)緩存問(wèn)題,關(guān)閉緩存后問(wèn)題依舊存在,最終發(fā)現(xiàn)是SQL映射文件中的參數(shù)傳遞錯(cuò)誤,使用了錯(cuò)誤的標(biāo)簽導(dǎo)致循環(huán)插入

MyBatisSystemException異常產(chǎn)生原因及解決

異常發(fā)生場(chǎng)景

當(dāng)我使用mybatis對(duì)數(shù)據(jù)庫(kù)操作時(shí)報(bào)的錯(cuò)誤

<resultMap id="shoppingCartProduct" type="shoppingCartProductVo">
        <id property="shoppingCartId" column="shopping_cart_id"></id>
        <result property="productId" column="product_id"></result>
        <result property="num" column="num"></result>
        <result property="productName" column="product_name"></result>
        <result property="productTitle" column="product_title"></result>
        <result property="productIntro" column="product_intro"></result>
        <result property="productPicture" column="product_picture"></result>
        <result property="productPrice" column="product_price"></result>
        <result property="productSellingPrice" column="product_selling_price"></result>
    </resultMap>
    <select id="selectShoppingCartByIds" resultMap="shoppingCartProduct">
        select
            s.shopping_cart_id,
            s.num,
            s.product_id,
            p.product_name,
            p.product_title,
            p.product_intro,
            p.product_picture,
            p.product_price,
            p.product_selling_price
            FROM
            shopping_cart AS s
            left JOIN
            product AS p
            ON s.product_id = p.product_id
            WHERE
            s.shopping_cart_id 
            in (<foreach collection="list" index="id" separator=",">
                #{id}
            </foreach>)
    </select>

嘗試解決問(wèn)題的過(guò)程

1.事務(wù)問(wèn)題

一開(kāi)始，我以為是事務(wù)問(wèn)題，于是在service層加上了@Transactional開(kāi)啟事務(wù)

@Override
@Transactional
public GetData postOrders(List<Long> shoppingCartIds, Long userId) {
    //1.判斷用戶(hù)是否存在
    if (msUserMapper.FindUser(userId) == null) {
        GetData getData=new GetData(500,"無(wú)此賬號(hào)",null);
        return getData;
    }
    //2.生成訂單
    Orders orders=new Orders();
    orders.setOrderNum(UUID.randomUUID().toString());
    orders.setUserId(userId);
    orders.setOrderTime(new Date());
    orderProductMapper.addOrders(orders);
    System.out.println(orders.getOrderId());
    System.out.println(orders.getOrderId().getClass().getTypeName());
    System.out.println(shoppingCartIds);

    //3.查詢(xún)購(gòu)物車(chē)商品數(shù)據(jù)
    List<ShoppingCartProductVo> shoppingCartProductVos = productMapper.selectShoppingCartByIds(shoppingCartIds);
    System.out.println(shoppingCartProductVos.size());
    System.out.println(shoppingCartProductVos);
    List<OrdersDtl> ordersDtls = new ArrayList<>();
    for (ShoppingCartProductVo vo : shoppingCartProductVos) {
        OrdersDtl ordersDtl = new OrdersDtl();
        ordersDtl.setOrderId(orders.getOrderId());
        ordersDtl.setProductId(vo.getProductId());
        ordersDtl.setProductIntro(vo.getProductIntro());
        ordersDtl.setProductName(vo.getProductName());
        ordersDtl.setProductPicture(vo.getProductPicture());
        ordersDtl.setProductPrice(vo.getProductPrice());
        ordersDtl.setProductSellingPrice(vo.getProductSellingPrice());
        ordersDtl.setProductTitle(vo.getProductTitle());
        ordersDtl.setNum(vo.getNum());
        ordersDtls.add(ordersDtl);
    }
    System.out.println(ordersDtls);
    orderProductMapper.addBatchOrderDtlsInt(ordersDtls);
    System.out.println(1);
    int rs =shoppingCartMapper.deleteShoppingCarts(shoppingCartIds);

    if (rs>0){
        GetData getData=new GetData(200,"操作成功",null);
        return getData;
    }else {
        GetData getData=new GetData(500,"操作成功",rs);
        return getData;
    }

}

現(xiàn)在想想，真是沒(méi)抓住重點(diǎn)，看錯(cuò)了代碼的報(bào)錯(cuò)信息

2.MyBatis一級(jí)緩存問(wèn)題

接著排查發(fā)現(xiàn)發(fā)現(xiàn)查詢(xún)出的數(shù)據(jù)與同樣的代碼在數(shù)據(jù)庫(kù)里不一樣，人當(dāng)場(chǎng)傻了
面向百度編程后認(rèn)為是出現(xiàn)了MyBatis一級(jí)緩存問(wèn)題
于是在yml文件中關(guān)閉關(guān)閉了MyBatis一級(jí)緩存

# 配置mybatis
mybatis:
  # mapper配置文件
  mapper-locations: classpath:mapper/*.xml
  # resultType別名，沒(méi)有這個(gè)配置resultType包名要寫(xiě)全，配置后只要寫(xiě)類(lèi)名
  type-aliases-package: com.example.demo.com.mashang.dao
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    map-underscore-to-camel-case: true
    local-cache-scope: statement # 設(shè)置一級(jí)緩存關(guān)閉，mybatis默認(rèn)開(kāi)啟

當(dāng)然還是不對(duì)，無(wú)可奈何之下，我只能回歸最初的報(bào)錯(cuò)信息，意思大概是文件映射有問(wèn)題

問(wèn)題的產(chǎn)生及其原因

沒(méi)辦法，如果真是映射出了錯(cuò)，那就只能一個(gè)一個(gè)排查過(guò)去了
終于在結(jié)合了springboot的報(bào)錯(cuò)日志
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

select 
s.num, s.product_id, p.product_name, p.product_title, p.product_intro, p.product_picture, p.product_price, p.product_selling_price 
FROM shopping_cart AS s 
INNER JOIN product AS p 
ON s.product_id = p.product_id 
WHERE s.shopping_cart_id 
in ( ? , ? , ? )

終于，我發(fā)現(xiàn)mybatis執(zhí)行的語(yǔ)句中，三個(gè)問(wèn)號(hào)插入的值是固定的0,1,2
也就是循環(huán)插入出了問(wèn)題
果然，我錯(cuò)誤的使用了標(biāo)簽index

解決方式

只要認(rèn)真檢查mybatis的映射文件，我的話(huà)是把標(biāo)簽換成即可，以下是修改后的mybatis映射文件

<resultMap id="shoppingCartProduct" type="shoppingCartProductVo">
    <id property="shoppingCartId" column="shopping_cart_id"></id>
    <result property="productId" column="product_id"></result>
    <result property="num" column="num"></result>
    <result property="productName" column="product_name"></result>
    <result property="productTitle" column="product_title"></result>
    <result property="productIntro" column="product_intro"></result>
    <result property="productPicture" column="product_picture"></result>
    <result property="productPrice" column="product_price"></result>
    <result property="productSellingPrice" column="product_selling_price"></result>
</resultMap>
<select id="selectShoppingCartByIds" resultMap="shoppingCartProduct">
    select
        s.shopping_cart_id,
        s.num,
        s.product_id,
        p.product_name,
        p.product_title,
        p.product_intro,
        p.product_picture,
        p.product_price,
        p.product_selling_price
        FROM
        shopping_cart AS s
        left JOIN
        product AS p
        ON s.product_id = p.product_id
        WHERE
        s.shopping_cart_id 
        in (<foreach collection="list" item="id" separator=",">
            #{id}
        </foreach>)
</select>