Spring boot Native Query 구문 오류

Question

안녕하세요!Spring boot Native Query를 사용하려는 데요..ㅠㅠㅠ MySql Workbench에선 해당 구문이 잘 돌아가는데...spring에서 사용하려고 하니 구문 오류뜨네요..ㅠ EntityManager em = emf.createEntityManager(); String sql = "set @n\:=current_date; select time as regDate, cpu, disk, memory from (select date_format( DATE_ADD((select @n\:= @n + interval 5 minute), interval -5 minute), '%Y-%m-%d %H:%i') time " + "from ServerMonitor where @n < now() " + ") timeTable left join ( " + "select regDate as oriTime, date_format(regDate, '%Y-%m-%d %H:%i') as fullTime, avg(cpu) AS `cpu`,avg(disk) AS `disk`,avg(memory) AS `memory`, concat(date_format(regDate, '%Y-%m-%d %H:'), floor(minute(regDate)/5)) as compareTime " + "from ServerMonitor " + "where regDate BETWEEN current_date() " + "AND now() " + "group by compareTime " + ") dataTable on timeTable.time = dataTable.fullTime " + "order by time;"; Query nativeQuery = em.createNativeQuery(sql); List resultList = nativeQuery.getResultList(); List serverMonitorChartDtos = resultList.stream().map(product -> new ServerMonitorChartDto( ((Timestamp) product[0]).toLocalDateTime(), (Double) product[1], (Double) product[2], (Double) product[3] )).collect(Collectors.toList());

잘하고싶따 · Answer

보니까 이 구문에서 에러가 걸리는 것 같네요ㅠㅠset &#64;n:&#61;current_date;근데 아무리 찾아봐도 set을 사용해서 구현한게 안보이네요 지원을 안하는건가..?

Spring boot Native Query 구문 오류

1개의 답변

Q&A 목록