Check out this bug, see if it has anything to do with you: https://trac.cakephp.org/ticket/4181
Which CakePHP version you're using? Please, make a backup from your code, and try pulling from [email protected]:cakephp.git to see if this problem is solved with latest devel version. []s Dérico Filho On Oct 16, 10:48 am, Xanax <[email protected]> wrote: > Good morning everyone, > > I'm using CakePHP with Oracle and sequences (i can't use triggers > because it's forbidden in my company...) > > I CAN'T add record to my database through my CakePHP app. > > I respected all naming conventions. > > I have a table name "PROJET", his ID is a"number" type, not null. > I've created a sequence called "PROJET_ID_SEQ' AND 'PROJETS_ID_SEQ'. > I've launch "select PROJET_ID_SEQ.nextval from dual" and "select > PROJET_ID_SEQ.nextval from dual" because if you lauch a "select > PROJET_ID_SEQ.currval from dual" ORACLE crashes saying you must do a > nextval at the first time... > > Plus i added : > var $sequence = 'PROJETS_ID_SEQ'; > in my projet sequence to be more explicit... > > Then i try to add a new project > When i launch the debug from the dbo_oracle.php and i display > "$model->sequence", it shows up : > > PROJETS_ID_SEQ > > So it's looks fine... BUT it doesn't work at all. He seems that > Cakephp doesn't use this sequence so i have this error : > SQL Error: ORA-01400: cannot insert NULL into > ("PLAN_TEST"."PROJETS"."ID") > > Do you have any idea of what i am missing please ? > > Thank you very much for any help because i am relly getting mad about > this! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
