Re: Oracle PK Sequence not working with D2W
Re: Oracle PK Sequence not working with D2W
- Subject: Re: Oracle PK Sequence not working with D2W
- From: arturo <email@hidden>
- Date: Tue, 27 Jan 2004 17:26:41 -0500
The sequence has to be named exactly the way EOF expects.
Use the SQL button in EOModeler to see what it wants to name the sequence.
Then you should be able to (in sqlplus) alter sequence rename a to b.
----- Original Message -----
From: "Franck Leveneur" <email@hidden>
To: <email@hidden>
Sent: Tuesday, January 27, 2004 3:37 PM
Subject: Oracle PK Sequence not working with D2W
> Hi,
>
> OSX 10.3.2
> XCode 1.1
> Java (probably 1.4.1 since it comes with 10.3 I believe).
> WO 5.2.1
> Oracle 9i
>
> I create a simple table:
>
> Create table testing.patb_Cbo (
> patb_cbo int not null,
> cbo varchar2(10) not null,
> telephone varchar2(20) not null,
> constraint PK_patb_cbo primary key (patb_CBOID)
> )
> (this create table statement works. Maybe there is a typo somewhere but
> I did not check when typing the statement in the email).
>
> I also created a sequence in Oracle:
> Create Sequence Testing.patbCBO Increment by 1 Start with 1
>
> The following works:
> Insert into Testing.patb_CBO values (testing.patbcbo.nextval, 'a','310')
>
>
> I then use Emodeler on MacoSX. select the tables I want to use.
> Save the Model. patbCBOID is a NSNumber, value Class is a Number. The
> Key icon is there.
> the diamond is not selected.
>
> Compile and run the app works fine.
> When try to insert a new record I get an error.
>
> Could not save your changes:
> EvaluateExpression failed: : Next exception:SQL State:42000 -- error
> code: 2289 -- msg: ORA-02289: sequence does not exist
>
> What am I doing wrong?
> FYI, I'm using D2W.
> _______________________________________________
> 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.
_______________________________________________
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.