On Fri, May 25, 2007 at 10:57:44AM -0400, Rom Bre wrote:
> On 5/24/07, Matt S Trout <[EMAIL PROTECTED]> 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/
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
