Re: cayenne - transactions - mysql

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Jan 18 2006 - 11:05:39 EST

  • Next message: Mike Kienenberger: "Re: Dynamic Data Maps"

    Cayenne interacts with DB over JDBC, so MySQL is no special in that
    respect ... if the driver and the underlying DB supports transactions
    (I have no idea which version does and to what extent), you don't
    have to do anything special in Cayenne.

    > 2) How to set up the cayenne-modeller to create tables of type
    > InnoDB and not MyIsam?

    Cayenne does not specifically uses MyISAM. It relies on MySQL to use
    whatever it thinks is the default (which happens to be MyISAM). So
    one way to get InnoDB is to change the default on MySQL side. Here is
    a snip from /etc/my.cnf:

    [mysqld]
    ...
    default_table_type = InnoDB

    Andrus

    On Jan 18, 2006, at 10:57 AM, Zvonimir Spajic wrote:

    > Hello,
    >
    > 1) How cayenne supports transactions on MySql?
    >
    > 2) How to set up the cayenne-modeller to create tables of type
    > InnoDB and not MyIsam?
    >
    > 3) Which cayenne information are important in this context of
    > transactions (with MySQL-Server)?
    >
    > Thanks for help
    >
    > Zvonimir Spajic
    >
    >



    This archive was generated by hypermail 2.0.0 : Wed Jan 18 2006 - 11:10:41 EST