[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] ORA-00942: table or view does not exist
|
Thanks a lot for your answers, Andrei and Gordon
Andrei Ilitchev wrote:
>
> 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
>>
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
>
--
View this message in context: http://www.nabble.com/ORA-00942%3A-table-or-view-does-not-exist-tp20420321p20487168.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.