Hi *,
We are using Hibernate version 3.2.0.ga with Hibernate Annotations 3.2.1.ga with
The database I'm using is Oracle9i.

All the tables in the database have ID of long type. We also have corresponding HIbernate Domain objects that are based on the database schema.

Now, we are trying to use Oracle Sequences to retieve and assign the sequence Ids to the tables (primary key).

For some reason, eventhough hibernate is retieving Oracle Sequence Id (database native), it is using Hibernate generated sequence id. We badly want to use the Oracle (native) sequence Id rather than HIbernate Generated Sequence Ids.

As you can see this is happening despite using "strategy = GenerationType.SEQUENCE" in annotations.

The annotations we are using are as follows

= = = = = = = = = = = = DB TABLE NAME is EMPLOYEE = = = = = = = = = = = = = = = = =
:
@Entity
@Table(name = "EMPLOYEE")
@javax.persistence.SequenceGenerator(name = "EMPLOYEE_STORE", sequenceName = "EMPLOYEE_SEQ")


:
:

@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "EMPLOYEE_STORE")
public Long getId() {
return this.id;
}
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

Any clues on why hibernate is using wrong "Identifier generation strategy" (use hilo strategy instead of seqhilo strategy).

Any help is much appreciate.

Hi,

In the SequenceGenerator annotation, try adding the following:


In my opinion the allocationSize is the important one.

Cheers,

Andy

Thanks Andy. That worked like a charm.

However, I'm unsure if this is a bug or 'use-it-the-right-way' thing :-). Any case, it solved my problem. Are there any pointers that are worth reading on this area?

I came across this, that looks similar to my problem...
http://jira.jboss.com/jira/browse/EJBTHREE-597

Theit solution is to use "org.hibernate.annotations" rather than "javax.persistence."
That is use:
-------------------------------- WORK-AROUND??? --------------------------------
@org.hibernate.annotations.GenericGenerator(name="Question_id_sequence", strategy = "sequence",
parameters = { @Parameter(name="sequence", value="S_QUESTION") } )
-------------------------------- FOR --------------------------------
@javax.persistence.SequenceGenerator(name = "Question_id_sequence", sequenceName = "S_QUESTION")

this is how it is supposed to work, I agree allocationSize should have a better default...