ORA-00942: table or view does not exist

[dmitryerkin]

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

[Gordon Yorke]

It means the database you are accessing does not have a sequence table
defined.  By default these settings you are applying are for table based
sequencing.  Are you attempting to use some other form of sequencing?  
Why are you using native EclipseLink metadata APIs?
--Gordon

dmitryerkin wrote:

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

_______________________________________________
eclipselink-users mailing list
eclipselink-users@...
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

[Andrei Ilitchev]

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@...>
To: <eclipselink-users@...>
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@...
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>

_______________________________________________
eclipselink-users mailing list
eclipselink-users@...
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

[dmitryerkin]

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" <[e-mail]>
To: <[e-mail]>
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
> [e-mail]
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>

_______________________________________________
eclipselink-users mailing list
[e-mail]
https://dev.eclipse.org/mailman/listinfo/eclipselink-users