java - Hibernate/Oracle 序列不工作

Question

我正在使用 hibernate 和 oracle DB 尝试使用序列将自动 ID 插入到表中。该序列确实存在于数据库中，但 hibernate 似乎无法找到它。

以下是所有相关信息:

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".SLF4J: Defaulting to no-operation (NOP) logger implementationSLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.org.hibernate.exception.SQLGrammarException: could not get next sequence value    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)        ....Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist        ....    ... 12 more

I know it says "Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist" but I can access the sequence on the database:

Table:

CREATE TABLE Property(
  id INT,
  address VARCHAR2(50),
  town VARCHAR2(50),
    postCode VARCHAR2(50),
    purchasePrice INT
);

顺序:

create sequence property_seq start with 1 increment by 1 nomaxvalue; 

映射 xml:

<class name="com.rental.model.property.Property" table="PROPERTY">
    <meta attribute="class-description"> This class contains the property detail. </meta>
    <id name="id" type="integer" column="id">
        <generator class="sequence"/>
    </id>
    <property name="address" column="ADDRESS" type="string" />
    <property name="town" column="TOWN" type="string" />
    <property name="postCode" column="POSTCODE" type="string" />
    <property name="purchasePrice" column="PURCHASEPRICE" type="integer" />
</class>

注释:

@Id
@SequenceGenerator(name="property_seq", sequenceName="property_seq", allocationSize=1, initialValue=1) 
@GeneratedValue (strategy = GenerationType.SEQUENCE, generator="property_seq")
public int getId() {
    return id;
}

Answer 1

为什么同时使用 xml 和 @Annotation ？也许 xml 定义胜过注释，并且 Hibernate 正在检索默认序列而不是您的 property_seq。
尝试删除 xml 映射并检查它是否有效。