how to use oracle sequence in hibernate?

Question

i am trying to access the below sql to generate the next sequence number. i am getting QuerySyntaxException caused by dual is not mapped.

sql = Select sequence_caseid.NEXTVAL from DUAL

public Long generate(Session session)
    throws DataRetrievalFailureException, SQLDataException {
    Long result = null;
    Query<?> query = (Query) session.createQuery(sql);
    result = new Long(query.getFirstResult());
    return result;
}

bean definition for generators

<bean id="generatorVoucherId" class="com.sample.OracleSequenceGenerator">
        <constructor-arg type="java.lang.String"><value>${logger.name}</value></constructor-arg>
        <property name="generatorName"><value>sequence_caseid</value></property>
</bean>

i dont have an hbm.xml for this dual. Do i need one? if so how to create one? i have multiple sequence generators in oracle like this, can i make one for all of it?

Christian Beikov · Accepted Answer · 2021-03-12 11:07:17Z

1

You need to use the createNativeQuery method to execute SQL.

answered Mar 12, 2021 at 11:07

Christian Beikov

16.6k2 gold badges36 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to use oracle sequence in hibernate?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related