#1645: Oracle sequence not being used
--------------------------+-------------------------------------------------
Reporter: tchakkapark | Owner: romanb
Type: defect | Status: new
Priority: blocker | Milestone: 1.0.4
Component: Record | Version: 1.1-DEV
Resolution: | Keywords: oracle sequence
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
--------------------------+-------------------------------------------------
Old description:
> Using Symfony 1.1, sfDoctrinePlugin with 1.1 libraries from latest SVN (I
> update it every day).
>
> I have the following definition in my schema:
>
> {{{
> EVENT_ATTENDEES:
> tableName: EVENT_ATTENDEES
> columns:
> group_id:
> notnull: true
> type: integer(12)
> event_attendee_id:
> notnull: true
> type: integer(12)
> primary: true
> sequence: event_attendee_id
> }}}
>
> In my database, I have a sequence defined called event_attendee_id, and
> it's currently at 98682. However, when I create an object and save it:
>
> {{{
> $register = new EVENT_ATTENDEES();
> $register->group_id = $contact["group_id"];
> $register->save();
> }}}
>
> It actually sets the $register->event_attendee_id to 1, 2, 3, etc in
> normal sequence. I'm unsure where it's getting the values from, but it
> needs to use the event_attendee_id sequence.
>
> In oracle, to get this sequence, you do a:
>
> {{{
>
> SQL> select event_attendee_id.nextval FROM dual;
>
> NEXTVAL
> ----------
> 98682
> }}}
>
> NEXTVAL contains the next sequence number. To create sequences in Oracle,
> one would do the following
>
> {{{
> CREATE SEQUENCE EVENT_ATTENDEE_ID MINVALUE 1 MAXVALUE
> 999999999999999999999999999 INCREMENT BY 1
> }}}
New description:
Using Symfony 1.1, sfDoctrinePlugin with 1.1 libraries from latest SVN (I
update it every day).
I have the following definition in my schema:
{{{
EVENT_ATTENDEES:
tableName: EVENT_ATTENDEES
columns:
group_id:
notnull: true
type: integer(12)
event_attendee_id:
notnull: true
type: integer(12)
primary: true
sequence: event_attendee_id
}}}
In my database, I have a sequence defined called event_attendee_id, and
it's currently at 98682. However, when I create an object and save it:
{{{
$register = new EVENT_ATTENDEES();
$register->group_id = $contact["group_id"];
$register->save();
}}}
It actually sets the $register->event_attendee_id to 1, 2, 3, etc in
normal sequence. I'm unsure where it's getting the values from, but it
needs to use the event_attendee_id sequence.
In oracle, to get this sequence, you do a:
{{{
SQL> select event_attendee_id.nextval FROM dual;
NEXTVAL
----------
98682
SQL> select event_attendee_id.nextval FROM dual;
NEXTVAL
----------
98683
}}}
The NEXTVAL column contains the next sequence number. "Dual" is a dummy
table of sorts that is common on all installations of Oracle where one can
run any kind of Oracle function against for an output.
To create sequences in Oracle, one would do the following
{{{
CREATE SEQUENCE EVENT_ATTENDEE_ID MINVALUE 1 MAXVALUE
999999999999999999999999999 INCREMENT BY 1
}}}
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1645#comment:3>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" 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.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
