Help: SQL Server and AUTO_PK_SUPPORT/auto_pk_for_table

From: Claudio Rosati (claudio.rosat..csys.it)
Date: Thu Oct 21 2004 - 03:43:08 EDT

  • Next message: Adrian Popa: "BUG #CAY-194 closed?"

    Hello all,
     
    I'm working with an SQL Server DB. The tables I've reversed with Cayenne
    Modeler have their PK that I think is auto-generated (auto-incremented:
    DbVisualizer say me their type is "int identity").
     
    First time I've created a new mapped object i had a Cayenne exception
    related to a lack of auto_pk_for_table procedure.
     
    Then, after diving the documentation, I've used the Modeler to create
    AUTO_PK_SUPPORT table and the auto_pk_for_table procedure.
     
    Now the eception is the following (translated from italian):
     
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
    JDBC][SQLServer] Impoossible to insert an explicit value for the Identity
    column of the 'trx_bundle' table when IDENTITY_INSERT is OFF.
     
    Why? What it means? How to solve it without change the tables?
     
    Thanks in advance
     
    Claudio
     
     

             Multimedia <http://www.acsys.it/> Division
            

    Claudio Rosati
    Project Manager Advanced Computer Systems S.p.A.
    via Della Bufalotta 378
    00139 Roma, RM
    Italy
    claudio.rosat..csys.it
    tel:
    fax: +39 06 8709 0516
    +39 06 8720 1502
            

     <https://www.plaxo.com/add_me?u=4295038861&v0=140354&k0=586510396> Add me
    to your address book... <http://www.plaxo.com/signature> Want a signature
    like this?
     


    logo_acs_new_small.gif

    This archive was generated by hypermail 2.0.0 : Thu Oct 21 2004 - 03:43:13 EDT