Guest User

Untitled

a guest
Oct 26th, 2016
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. public void updateListData(String newId, String oldId) {
  2. StringBuilder sql = new StringBuilder("UPDATE card_info c ");
  3. sql.append("SET c.xxx_id = :newId ");
  4. sql.append("WHERE c.xxx_id <> '' AND c.status = 1 AND c.is_private = 1 AND c.delete = 0 AND c.xxx_id = :oldId ");
  5.  
  6. Query query = getEntityManager().createNativeQuery(sql.toString());
  7. query.setParameter("newId", newId);
  8. query.setParameter("oldId", oldId);
  9.  
  10. query.executeUpdate();
  11.  
  12. }
  13.  
  14. WARN : org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1265, SQLState: 01000
  15. ERROR: org.hibernate.engine.jdbc.spi.SqlExceptionHelper - data truncated for primary key column: <card_id>
Add Comment
Please, Sign In to add comment