页面报错:
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
控制台提示:
Hibernate:
select
SEQ_BOOKBASIC_ID.nextval
from
dual
Hibernate:
insert
into
T_BOOK_BASIC
(BOOK_NO, BOOK_NAME, BOOK_CLASSIFY_NO, AUTHOR, PUBLISH, PUBLISH_TIME, PRICE, KEY_WORD, IN_TIME, BORROW_COUNT, INVENTORY_NUMBER, REMOVED, CREATE_TIME, UPDATE_TIME, OPERATE_ID, Id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
搞定了 oracle中的序列自增长出现错误,id被占用了,所以出错。
select seq_bookbasic_id.nextval from dual
序列已经是自增,但是某一个id已经被占用,所以导致了错误,在oracle中执行以上语句两次即可。
搞定了 oracle中的序列自增长出现错误,id被占用了,所以出错。
select seq_bookbasic_id.nextval from dual
序列已经是自增,但是某一个id已经被占用,所以导致了错误,在oracle中执行以上语句两次即可。
如果用了个序列,主键id就不是放个?进去,要放个序列进去