我正在使用hibernate 3,oracle 10g。我有一張桌子:主題。定義在這里CREATE TABLE SUBJECT ( SUBJECT_ID NUMBER (10), FNAME VARCHAR2(30) not null, LNAME VARCHAR2(30) not null, EMAILADR VARCHAR2 (40), BIRTHDT DATE not null, constraint pk_sub primary key(subject_id) USING INDEX TABLESPACE data_index ) ;插入新主題時,sub_seq用于創(chuàng)建主題ID,定義在此處create sequence sub_seq MINVALUE 1 MAXVALUE 999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 100 NOCYCLE ;Subject類是這樣的:@Entity@Table(name="ktbs.syn_subject")public class Subject { @Id @Column(name="subject_id") @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="SUB_SEQ") @SequenceGenerator(name="SUB_SEQ", sequenceName = "SUB_SEQ") private long subjectId; private String fname; private String lname; private String emailadr; private Date birthdt;}在主題表中,數(shù)據(jù)庫中有4555個主題由excel的plsql腳本加載,并且sub_sequence運行良好。主題ID的范圍是1--4555。但是,當我使用休眠模式從應用程序中添加主題時,序列號跳至255050。運行幾天后,休眠模式生成的主題ID如下所示:270079270078270077270076270075270074270073270072270071270070270069270068270067270066270065270064270063270062270061270060270059270058270057270056270055270054270053270052270051270050265057265056265055265054265053265052265051265050260059260058260057260056260055260054260053260052260051260050255067255066255065255064255063255062255061255060255059255058255057255056255055255054255053255052255051255050455545544553....1差距很大:4555至255051、255067至260051、265057至270051這是浪費,不是期望的行為。有誰知道為什么會這樣,并且很熱要解決它謝謝
- 3 回答
- 0 關注
- 728 瀏覽
添加回答
舉報
0/150
提交
取消