DB Tips

msg:
java.sql.SQLException: Table storage engine for 'point_history' doesn't have this option
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)


원인: Engine 설정이 쓰기 가능하지 않음.
related: http://www.mysqlkorea.co.kr/sub.html?mcode=manual&scode=01&m_no=21937&cat1=14&cat2=426&cat3=0&lang=k

해결법: Engine을 MyISAM 등의 쓰기 가능한 영역으로 변경.
alter table `point_history` ,type=MyISAM comment='포인트 이력' row_format=fixed