MyBatis+oracle 批量插入数据的一些问题

    <select id="InsertUserPrivilegeTemp" parameterType="Integer"
        resultMap="userPrivilegeTemp">

        insert into userPrivilegeTemp
        select ui.UserID, rp.PrivilegeID
        from UserInfo ui
        left join UserRole ur on ur.UserID=ui.UserID
        left join RolePrivilege rp on rp.RoleID=ur.RoleID
        <where>
            and ui.UserID=#{id}
        </where>
    </select> 

当mybaties执行到 insert into userPrivilegeTemp这里的时候，进程就卡死了，
后来我改为insert into userPrivilegeTemp(UserID,PrivilegeID)就不会卡了，
应该是mybaties不认识insert into userPrivilegeTemp代表insert into userPrivilegeTemp（UserID,PrivilegeID）

注意：userPrivilegeTemp表就UserID,PrivilegeID2个字段。

转载于:https://www.cnblogs.com/feiZhou/p/9344155.html