Could not save your changes:msg: ORA-02289: sequence does not exist
Could not save your changes:msg: ORA-02289: sequence does not exist
- Subject: Could not save your changes:msg: ORA-02289: sequence does not exist
- From: Serge Smadja <email@hidden>
- Date: Thu, 28 Nov 2002 21:39:38 +0100
Another beginner's question I guess. I am currently modeling a database
with Power AMC Designer 8. We will build an Intranet application on
top of it that will allow to read and write data from/into this
database (unfortunately not with WebObjects). But before, being able to
use the Intranet app itself to do that, I'd like to use D2W to write
some sample data into the db instead of writing a long SQL script.
Anyway, each time I try to insert a record I get this error :
Could not save your changes:
EvaluateExpression failed: : Next exception:SQL State:42000 -- error
code:
2289 -- msg: ORA-02289: sequence does not exist
I guess something is wrong with the way Power AMC 8 generates sequences
or the way WebObjects expects sequences to be (I compared the generated
SQL script with the one generated by EOModeler). Btw, is there a data
modeler that does it right ?
Anyway, here is the excerpt of the script generated by Power AMC 8 :
drop table SITE cascade constraints
/
drop sequence S_SITE
/
create sequence S_SITE
/
/*==============================================================*/
/* Table : SITE */
/*==============================================================*/
create table SITE (
ID_SITE NUMBER not null,
SIRET VARCHAR2(50) not null,
...
constraint PK_SITE primary key (ID_SITE),
constraint AK_SIRET_SITE unique (SIRET)
)
/
Thanks for your help
My wish : Find those common mistakes documented in the tutorials.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.