[Dbix-class] trouble with oracle sequence

[Matt S Trout]

On Fri, May 25, 2007 at 10:57:44AM -0400, Rom Bre wrote:
> On 5/24/07, Matt S Trout <dbix-class at trout.me.uk> wrote:
> >
> >On Thu, May 24, 2007 at 02:50:47PM -0400, Rom Bre wrote:
> >> I'm getting the following error after attempting to insert into a table
> >> where i have setup an oracle sequence:
> >>
> >> DBIx::Class::ResultSet::create(): Can't get last insert id
> >>
> >>
> >> This is happening because dbic is attempting to do a SELECT
> >> STORE_CART_SEQ.CURRVAL FROM DUAL, without a preceding NEXTVAL.
> >>
> >>
> >> Here's the create statement:
> >>
> >> $c->model('StoreDB::Cart')->create({ session_id => $session_id });
> >>
> >>
> >> I'm under the assumption that the NEXTVAL will be handled
> >> automatically and that I don't need to specify anything in the create
> >
> >PK::Auto expects you have a trigger that does the NEXTVAL and populates
> >the
> >id during INSERT (ala e.g. postgres' SERIAL data type)
> >
> >I think you might be looking for PK::Sequence
> 
> Can you point me in the direction of PK::Sequence?  I'm unable to find
> anything in CPAN or when googling.  Unless what you mean is that I should
> create my own custom dbic component.

It's dev release only atm.

The canonical approach for the 07 series is just to add the trigger.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director    Want a managed development or deployment platform?
 Shadowcat Systems Ltd.  Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/             http://www.shadowcatsystems.co.uk/