Re: auto pk support

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Mar 28 2003 - 16:12:35 EST

  • Next message: Andrus Adamchik: "Re: coonection lost after idle time"

    There is a more subtle problem involved here, than simply disabling
    autogeneration - bringing the key back to Cayenne to keep your objects
    valid. This was discussed on cayenne-devel before:

      http://www.objectstyle.org/cayenne/lists/cayenne-devel/2003/01/0017.html

    There may be some driver specific solutions (we need to fish for that, I'd
    appreciate ideas), also as mentioned here:

      http://www.objectstyle.org/cayenne/lists/cayenne-devel/2003/01/0022.html

    JDBC3 adds a standard way of doing that. Not sure how this is implemented
    across drivers tho.

    Andrus

    > I am using MySQL and have auto_increment on my table's primary key
    > field. When trying to insert a new record I am getting "Table
    > 'MYDB.AUTO_PK_SUPPORT' doesn't exist".
    >
    > I assume this is because Cayenne is trying to generate the primary key
    > for me from what I have read in the user guide. I am using the mysql
    > adapter that comes with Cayenne. Is there a way to turn that off so it
    > leaves the key generation up to MySQL?
    >
    > Jason W. Bedell, MCSE+I, JCP
    > Technology Specialist
    > P: 816.512.9255
    > M: 913.486.3833
    > F: 816.842.6494
    > jason.bedel..igitalevergreen.com
    > Digital Evergreen
    > 423 West 8th Street
    > Kansas City, MO 64105
    > Phone: 816.512.9399
    > <www.digitalevergreen.com>

    This archive was generated by hypermail 2.0.0 : Fri Mar 28 2003 - 16:12:35 EST