Oracle sequences and JPA

[Mateusz Moroz]

Hello,

I'm new to JavaRanch and I have a problem with saving object to database through EJB. I have a table, that has fields:
ID (where value is normally generated from sequence) and
YEAR_SEQ_NUMBER (which is sequence-generated value - every year its initial value is reset).

The problem is, that while the field ID works fine, the system does not give the value to YEAR_SEQ_NUMBER saying:

 cannot insert NULL into ("KURK"."KURK_POL_KS"."YEAR_SEQ_NUMBER") 

The way I'm trying to map:

@Column(name="YEAR_SEQ_NUMBER")
@GeneratedValue(generator="kurkPksiegYearSeq")
@SequenceGenerator(name="kurkPksiegYearSeq", sequenceName="KURK_PKSIEG_YEAR_SEQ", allocationSize=1)
private Long yearSeqNumber;

I tried to put also the @Id annotation but the server claimed

Class [com.curly.total.entities.KurkPolKs] has two @GeneratedValues: for fields [KURK_POL_KS.ID] and [KURK_POL_KS.YEAR_SEQ_NUMBER]. Only one is allowed.

Is it possible to give number to id automatically from a sequence, so it corresponds to:

insert into .... values (ID_SEQ.NEXTVAL, KURK_PKSIEG_YEAR_SEQ.NEXTVAL)

?

Regards

[Mateusz Moroz]

I solved the problem by writing a before insert trigger, that fills the field:

SELECT KURK_PKSIEG_YEAR_SEQ.NEXTVAL INTO :NEW.YEAR_SEQ_NUMBER FROM DUAL;

Although this is not elegant solution.

[Paul Sturrock]

Its also not a solution you should need. Which JPA implementation are you using?

[Mateusz Moroz]

I am using EJB 3.0, so to make my question concrete, let's talk in the dialect of EJB3