Grokbase Groups Cayenne dev May 2008
FAQ
MySQL engine = NDBCLUSTER
-------------------------

Key: CAY-1050
URL: https://issues.apache.org/cayenne/browse/CAY-1050
Project: Cayenne
Issue Type: Bug
Components: Cayenne Core Library
Environment: 3.0M3
Reporter: Borut Bolčina
Assignee: Andrus Adamchik



If I am using AutoAdapter and DbGenerator for table creation with MySQL 5 and table_type variable in MySQL is set to MyISAM, then according to http://cayenne.apache.org/doc/api/org/apache/cayenne/dba/mysql/MySQLAdapter.html I thought the CREATE TABLE string when the generator is run would cause the engine to be MyISAM or whatever the table_type is set to, but it gives me InnoDB:

INFO [28 Apr 2008 11:14:57.877] Detected and installed adapter: org.apache.cayenne.dba.mysql.MySQLAdapter
INFO [28 Apr 2008 11:14:57.884] CREATE TABLE currency_rate (country VARCHAR(255) NOT NULL, currency_code VARCHAR(255) NOT NULL, currency_name
VARCHAR(255) NOT NULL, currency_number INT NOT NULL, date DATETIME NULL, id INT NOT NULL, rate DECIMAL(19, 4) NOT NULL, PRIMARY KEY (id)) ENG
INE=InnoDB

Now, we are planning to use NDBCLUSTER table types and if this auto detection does not work, what is the way to set engine type via API?

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Search Discussions

  • Anonymous at May 8, 2008 at 9:08 am
    [ https://issues.apache.org/cayenne/browse/CAY-1050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12843#action_12843 ]

    Ari Maniatis commented on CAY-1050:
    -----------------------------------

    Adding Andrus's dev mailing list response to this task:

    ---------
    Looks like a limitation of MySQLSniffer. It does this to detect MySQL default behavior:

    ResultSet rs = statement.executeQuery("SHOW VARIABLES LIKE 'table_type'");
    if (rs.next()) {
    String tableType = rs.getString(2);
    supportFK = tableType != null && tableType.toUpperCase().equals("INNODB");
    }

    But doesn't go far enough to actually use it as a table type in 'createTable'. Shouldn't be too hard to fix.
    MySQL engine = NDBCLUSTER
    -------------------------

    Key: CAY-1050
    URL: https://issues.apache.org/cayenne/browse/CAY-1050
    Project: Cayenne
    Issue Type: Bug
    Components: Cayenne Core Library
    Environment: 3.0M3
    Reporter: Borut Bolčina
    Assignee: Andrus Adamchik

    If I am using AutoAdapter and DbGenerator for table creation with MySQL 5 and table_type variable in MySQL is set to MyISAM, then according to http://cayenne.apache.org/doc/api/org/apache/cayenne/dba/mysql/MySQLAdapter.html I thought the CREATE TABLE string when the generator is run would cause the engine to be MyISAM or whatever the table_type is set to, but it gives me InnoDB:
    INFO [28 Apr 2008 11:14:57.877] Detected and installed adapter: org.apache.cayenne.dba.mysql.MySQLAdapter
    INFO [28 Apr 2008 11:14:57.884] CREATE TABLE currency_rate (country VARCHAR(255) NOT NULL, currency_code VARCHAR(255) NOT NULL, currency_name
    VARCHAR(255) NOT NULL, currency_number INT NOT NULL, date DATETIME NULL, id INT NOT NULL, rate DECIMAL(19, 4) NOT NULL, PRIMARY KEY (id)) ENG
    INE=InnoDB
    Now, we are planning to use NDBCLUSTER table types and if this auto detection does not work, what is the way to set engine type via API?
    --
    This message is automatically generated by JIRA.
    -
    You can reply to this email to add a comment to the issue online.
  • Anonymous at May 8, 2008 at 11:02 am
    [ https://issues.apache.org/cayenne/browse/CAY-1050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Andrus Adamchik updated CAY-1050:
    ---------------------------------

    Summary: MySQLSniffer should configure created adapter to use MySQL default engine for tables (was: MySQL engine = NDBCLUSTER)
    MySQLSniffer should configure created adapter to use MySQL default engine for tables
    ------------------------------------------------------------------------------------

    Key: CAY-1050
    URL: https://issues.apache.org/cayenne/browse/CAY-1050
    Project: Cayenne
    Issue Type: Bug
    Components: Cayenne Core Library
    Environment: 3.0M3
    Reporter: Borut Bolčina
    Assignee: Andrus Adamchik
    Fix For: 3.0


    If I am using AutoAdapter and DbGenerator for table creation with MySQL 5 and table_type variable in MySQL is set to MyISAM, then according to http://cayenne.apache.org/doc/api/org/apache/cayenne/dba/mysql/MySQLAdapter.html I thought the CREATE TABLE string when the generator is run would cause the engine to be MyISAM or whatever the table_type is set to, but it gives me InnoDB:
    INFO [28 Apr 2008 11:14:57.877] Detected and installed adapter: org.apache.cayenne.dba.mysql.MySQLAdapter
    INFO [28 Apr 2008 11:14:57.884] CREATE TABLE currency_rate (country VARCHAR(255) NOT NULL, currency_code VARCHAR(255) NOT NULL, currency_name
    VARCHAR(255) NOT NULL, currency_number INT NOT NULL, date DATETIME NULL, id INT NOT NULL, rate DECIMAL(19, 4) NOT NULL, PRIMARY KEY (id)) ENG
    INE=InnoDB
    Now, we are planning to use NDBCLUSTER table types and if this auto detection does not work, what is the way to set engine type via API?
    --
    This message is automatically generated by JIRA.
    -
    You can reply to this email to add a comment to the issue online.
  • Anonymous at May 8, 2008 at 11:02 am
    [ https://issues.apache.org/cayenne/browse/CAY-1050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Andrus Adamchik closed CAY-1050.
    --------------------------------

    Resolution: Fixed
    Fix Version/s: 3.0
    MySQLSniffer should configure created adapter to use MySQL default engine for tables
    ------------------------------------------------------------------------------------

    Key: CAY-1050
    URL: https://issues.apache.org/cayenne/browse/CAY-1050
    Project: Cayenne
    Issue Type: Bug
    Components: Cayenne Core Library
    Environment: 3.0M3
    Reporter: Borut Bolčina
    Assignee: Andrus Adamchik
    Fix For: 3.0


    If I am using AutoAdapter and DbGenerator for table creation with MySQL 5 and table_type variable in MySQL is set to MyISAM, then according to http://cayenne.apache.org/doc/api/org/apache/cayenne/dba/mysql/MySQLAdapter.html I thought the CREATE TABLE string when the generator is run would cause the engine to be MyISAM or whatever the table_type is set to, but it gives me InnoDB:
    INFO [28 Apr 2008 11:14:57.877] Detected and installed adapter: org.apache.cayenne.dba.mysql.MySQLAdapter
    INFO [28 Apr 2008 11:14:57.884] CREATE TABLE currency_rate (country VARCHAR(255) NOT NULL, currency_code VARCHAR(255) NOT NULL, currency_name
    VARCHAR(255) NOT NULL, currency_number INT NOT NULL, date DATETIME NULL, id INT NOT NULL, rate DECIMAL(19, 4) NOT NULL, PRIMARY KEY (id)) ENG
    INE=InnoDB
    Now, we are planning to use NDBCLUSTER table types and if this auto detection does not work, what is the way to set engine type via API?
    --
    This message is automatically generated by JIRA.
    -
    You can reply to this email to add a comment to the issue online.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categoriescayenne
postedMay 8, '08 at 8:30a
activeMay 8, '08 at 11:02a
posts4
users1
websitecayenne.apache.org

1 user in discussion

Anonymous: 4 posts

People

Translate

site design / logo © 2022 Grokbase