Hi!
I use stored procedures for creating objects.
The current config is like this, using org.hibernate.dialect.Oracle10gDialect:
Code:
<class name="Event" table="EVENTS">
<id name="id" column="EVENT_ID">
<generator class="sequence"/>
</id>
<property name="date" type="timestamp" column="EVENT_DATE"/>
<property name="title"/>
<sql-insert check="none" callable="true">{call createEventHB (?, ?, ?)}</sql-insert>
</class>
Now when doing a session.save(newEventObject), two DB calls are made:
Code:
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: {call createEventHB (?, ?, ?)}
How to make only the second call and let the stored procedure to generate an ID value?
I tried to set generator class="identity", but it complains that it is not supported by the dialect.
Is there a way with Hibernate v3.6.0 to do this?
Regards,
David
Login
FAQ
Search
