qlrm사용시 주의사항

qlrm 라이브러리와 mariaDB 사용시 주의사항

Subscribe.Service @Transactional(readOnly = true) public List subscribeList(long principalId, long pageUserId) { StringBuffer sb = new StringBuffer(); sb.append("select u.id userId, u.username, u.profileImageUrl, "); sb.append("if( (select true from subscribe where fromUserId = ? and toUserId = u.id), true, false) subscribeState, "); // principalDetails.user.id sb.append("if(u.id = ?, true, fals..