严重: ORA-00001: 违反唯一约束条件 (SYSMAN.SYS_C005168)

[2Tu]

注解 entity hibernate oracle 违反唯一约束条件 (SYSMAN.SYS_C0051
严重: Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)

Caused by: java.sql.BatchUpdateException: ORA-00001: 违反唯一约束条件 (SYSMAN.SYS_C005168)

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 95 more

ENTITY java
@Entity
@Table(name="ISM_USER_BASE")
public class UserBase implements Serializable {
@Id
@GeneratedValue(strategy= GenerationType.AUTO)

请问这个该怎么设置？
oracle不支持IDENTITY，如果我将此属性去掉也会报这个错。
求解。

[2Tu]

非常感谢

[zyfcf1414]

答案
@Id
@GeneratedValue(strategy= GenerationType.AUTO)
改成
@Id
@GeneratedValue(strategy= GenerationType.SEQUENCE)

oracle不支持IDENTITY，使用AUTO需要其它的配置

[2Tu]

分太少了?
*/
@Id
@GeneratedValue(strategy= GenerationType.SEQUENCE)
public long getUserid() {
return userid;
}

[zjhlsf]

@Id
@GeneratedValue(generator="seq_id",strategy=GenerationType.SEQUENCE)
@SequenceGenerator(name="seq_id",sequenceName="seq_exam_item_id")
private Integer id;

[jiang_19870903]

将
@Id
@GeneratedValue(strategy= GenerationType.AUTO)
改成
@Id
@GeneratedValue(strategy= GenerationType.SEQUENCE)

IDENTITY可以使用在mysql里

如果想在生成语句时候区别自动生成的信息可以添加
@SequenceGenerator(name="seq_id",sequenceName="seq_type_id")

@GeneratedValue(generator="seq_id",strategy=GenerationType.SEQUENCE)