Hi all,
can we use javax.persistence.SequenceGenerator for the field which is not primarykey field?
I have an entity with two fields of type integer.when i use javax.persistence.SequenceGenerator for primary key field its working fine.But,when i try to use it for other field its not generating any id.
The technologies i am using are

ejb3
hibernate3.1.2
database-postgreSQL

any ideas?
thanks in advance.

I don't believe this will work but you could have your db engine handle this and tell hibernate this field is a generated field. Hibernate then will inquiry the db engine for the right value after an instance is inserted.


Farzad-

Thank you for your response.
I think i am not clear in my question so,felt like pasting my code here.
@Entity
@Table(name = "patient")
@SequenceGenerator (
name="PATIENT_ID_SEQ",
sequenceName="patient_id_sequence",
allocationSize=20
)

@Id
@Column(name = "patient_id", nullable=false, length=100)
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="PATIENT_ID_SEQ")
public Long getPatientId() {
return patientId;
}

in postgreSQL i defined patient_id column as of type serial and its not a primary key field.
with this code its generating patient ids with sequence like 1,2,3,4..........The problem is
allocation size which i have given is not working.So, i felt the sequence is getting generated by postgreSQL.I dont know what the problem is?How do i make allocation
size working?

any ideas?
thanks in advance.