Skip to main content

[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.



Back to the top