當我嘗試添加新記錄時出現此錯誤
Hibernate:
select
STEST_PP_DATA_SEQ.nextval
from
dual
2022-04-06 12:53:03.487 WARN 23884 --- [0.1-8082-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 2289, SQLState: 42000
2022-04-06 12:53:03.510 ERROR 23884 --- [0.1-8082-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : ORA-02289: sequence does not exist
我的課
@Data
@NoArgsConstructor
@AllArgsConstructor
@Entity(name = "TEST_PP_DATA")
@SequenceGenerator(name = "STEST_PP_DATA_SEQ", sequenceName = "STEST_PP_DATA_SEQ", initialValue = 1, allocationSize = 1)
public class TestPPData extends AuditableEntity{
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "STEST_PP_DATA_SEQ")
@Column(name = "ID", nullable = false)
這就是我向資料庫添加序列的方式
CREATE SEQUENCE STEST_PP_DATA_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1 NOCYCLE NOCACHE NOORDER
uj5u.com熱心網友回復：
可能您需要完全限定名稱。您可以嘗試以下查詢來檢索所有者：
SELECT owner, status
FROM All_Objects
WHERE object_type = 'SEQUENCE'
AND object_name = 'STEST_PP_DATA_SEQ';
然后將序列用作：
select <OWNER>.STEST_PP_DATA_SEQ.nextval
from dual;
如果第一個查詢沒有回傳任何內容或狀態與 VALID 不同，那么您的序列創建有問題。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/457263.html