Re: [eclipselink-users] ORA-00942: table or view does not exist

["Andrei Ilitchev" <andrei.ilitchev@xxxxxxxxxx>]

By default Eclipselink uses table sequencing named SEQUENCE, which contains 
two fields SEQ_NAME (for sequence name) and SEQ_COUNT (for sequence value).
Alternatively, to use Oracle sequence:
session.getLogin().addSequence(new NativeSequence("OEBS_SEQ", allocSize));
where allocSize should be the same as INCREMENT BY parameter value of the 
sequence.

If you use many sequences that all use the same allocSize you can set them 
up with a single line of code:
session.getLogin().setDefaultSequence(new NativeSequence("", allocSize));

----- Original Message ----- 
From: "dmitryerkin" <dmitryerkin@xxxxxxxxxxxxx>
To: <eclipselink-users@xxxxxxxxxxx>
Sent: Monday, November 10, 2008 8:52 AM
Subject: [eclipselink-users] ORA-00942: table or view does not exist


> Hi
> I am trying to use the sequence:
>
> descriptor.setSequenceNumberFieldName("OEBS_VIEW.ID");
> descriptor.setSequenceNumberName("OEBS_SEQ");
>
> But I am catching this error:
>
> ORA-00942: table or view does not exist
> Error Code: 942
> Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
> bind => [50, OEBS_SEQ]
> Query: DataModifyQuery()
>
>
> What does it mean?
>
>
> Regards,
> Dmitry
> --
> View this message in context: 
> http://www.nabble.com/ORA-00942%3A-table-or-view-does-not-exist-tp20420321p20420321.html
> Sent from the EclipseLink - Users mailing list archive at Nabble.com.
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users