Status of MySQL AUTO_INCREMENT Support?

From: Gary Affonso (glist..reywether.com)
Date: Tue Jan 18 2005 - 15:16:56 EST

  • Next message: Andreas Hjortsberg: "Cayenne and JasperReport"

    I'm evaluating Cayenne for an current project. It's a fairly large,
    existing, database that uses MySQL AUTO_INCREMENT to handle the primary key
    fields. Switching to Cayenne's "pk table" just won't work, there's a LOT of
    legacy data there I just cannot change.

    But everything else in Cayenne looks great, and I'd vastly prefer an
    alternative to Hibernate (which I'm using now) and it's constant irritations
    (XML hell, code-generation difficulties, etc.). I swear, using that product
    is like death-by-1000-irritants, particularly for bottom-up efforts.

    I read back through the Cayenne archives and it looks like support for
    database-generated PK's (such as MySQL's AUTO_INCREMENT) is slated for 1.2,
    which is now at Milestone 1 with Milestone 2 being worked on.

    So...

    A few of questions:

    1) What is the status for support of db-based PK generation in 1.2? Is it
    there?

    2) Does (or will) 1.2 come with a MySQL adaptor that directly implements
    support for native-pk generation?

    2a) Or is the plan to support the retrieval of db-generated keys in an
    architectural sense, but still leave it as an exercise for the user to
    subclass the MySQL adaptor?

    Thanks much. I'll keep dealing with Hibernate, for now, but I'm very much
    hoping Cayenne can save me soon. :-)

    - Gary

    This archive was generated by hypermail 2.0.0 : Tue Jan 18 2005 - 15:17:00 EST