Oracle DB - auto-populate ID property upon inserting new record

Question

Oracle DB - auto-populate ID property upon inserting new record

justabuzz May '14

Created May '14	Last Reply Jun '15	Replies 1	Views 638	Votes 0

justabuzz 707

May '14

Hi,

I'm using Phalcon's ORM for interacting with an Oracle DB. I'm trying to set it up so that when I instantiate a new object and store it in the DB then the model object will automatically get it's ID property populated with the auto-generated ID that Oracle assigned for the new record.

I couldn't find any clear documentation about how to acheive this. Facts I managed to collect are:

Phalcon can do this, but not for all DBs. It seems that it doesn't do it with Oracle.
When Phalcon doesn't support the DB then we can acheive this by adding getSequenceName() model to the model. This method should return the name of the sequence. This is assuming that supportSequences() returns true (which it does for me).
Some DBs require putting the sequence name in quotes - https://github.com/phalcon/cphalcon/issues/2376
Not sure how this can help, but it seems related... https://stackoverflow.com/questions/21009695/working-with-oracle-sequences-in-phalcon

So, I tried to use all the above info in order to make it happen, but I have a feeling I'm missing something. Don't know what though.

Can anyone post an example of how to make this work?

Thanks! :)

skaosYan · Answer 1 · 2015-06-08T02:05:00-07:00

Hi,

Did you find any solution? I see the same issue with Phalcon 2.0.2 and Oracle 12c. Record is created in db, but ID is empty in Phalcon model after save().