Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void updateListData(String newId, String oldId) {
- StringBuilder sql = new StringBuilder("UPDATE card_info c ");
- sql.append("SET c.xxx_id = :newId ");
- sql.append("WHERE c.xxx_id <> '' AND c.status = 1 AND c.is_private = 1 AND c.delete = 0 AND c.xxx_id = :oldId ");
- Query query = getEntityManager().createNativeQuery(sql.toString());
- query.setParameter("newId", newId);
- query.setParameter("oldId", oldId);
- query.executeUpdate();
- }
- WARN : org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1265, SQLState: 01000
- ERROR: org.hibernate.engine.jdbc.spi.SqlExceptionHelper - data truncated for primary key column: <card_id>
Add Comment
Please, Sign In to add comment