Hibernate: 
    update
        alarm 
    set
        read=1 
    where
        alarm_id=?
2022-05-04 16:28:08.884 TRACE 4448 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [1]
2022-05-04 16:28:08.897  WARN 4448 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 1064, SQLState: 42000
2022-05-04 16:28:08.897 ERROR 4448 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read=1 where alarm_id=1' at line 1
2022-05-04 16:28:08.924 ERROR 4448 --- [nio-8080-exec-1] o.a.c.c.C.[.[.[.[dispatcherServlet]      : Servlet.service() for servlet [dispatcherServlet] in context with path [/api] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement] with root cause

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read=1 where alarm_id=1' at line 1

분명 sql문에 아무 오류가 없는 것 같은데 SQLSyntaxErrorException 가 떴다

혹시 몰라 MySQL 예약어를 찾아보니 read가 예약어이기 때문에 오류가 난 것으로 확인하고 isRead로 칼럼명을 변경해서 해결했다!

MySQL 예약어 종류

https://henerd.tistory.com/24