When SQLException "Sequence is not found" occurs, it doesn't show name of sequence.

Particularly, I have found this line in Hibernate source code:
this.sequenceName = PropertiesHelper.getString(SEQUENCE, params, "hibernate_sequence");

Hibernate tries to find sequence "hibernate_sequence" which of couse doesn't exist in my database. It would be better if Hibernate figured out exact name of sequence.

Hibernate version: 3.0.5

Mapping documents:

The generated SQL (show_sql=true):
select hibernate_sequence.nextVal from dual

You can put the sequence name in the hbm file itself to ask hibernate to use the sequence name given by you , which exists in your adtabase

If you have Hibernate generate the schema for you, there will be a sequence called "hibernate_sequence", assuming you're using sequence-based IDs and you don't override this default name.

In any case, you can debug problems like this by turning on SQL logging as described in the reference doc.

Hi asolntsev,

If you have to use definited sequences in Hibernate just do so.

<id
name="id"
column="KONTO_ID"
type="java.lang.Long"
unsaved-value="null"
>
<generator class="native"> <!-- native is the generator -->
<!-- parameter-name:= sequence -->
<!-- Sequence definition in Oracle "BS_KONTO_SEQ" -->
<param name="sequence">BS_KONTO_SEQ</param>
</generator>
</id>


let try !