Examples of org.apache.cayenne.dba.mysql.MySQLAdapter

org.apache.cayenne.dba.mysql.MySQLAdapter
ysql.com">MySQL RDBMS.
Foreign Key Constraint Handling

Foreign key constraints are supported by InnoDB engine and NOT supported by MyISAM engine. This adapter by default assumes MyISAM, so {@link org.apache.cayenne.dba.JdbcAdapter#supportsFkConstraints()} will return false.Users can manually change this by calling setSupportsFkConstraints(true) or better by using an {@link org.apache.cayenne.dba.AutoAdapter}, i.e. not entering the adapter name at all for the DataNode, letting Cayenne guess it in runtime. In the later case Cayenne will check the table_type MySQL variable to detect whether InnoDB is the default, and configure the adapter accordingly.
Sample Connection Settings
- Adapter name: org.apache.cayenne.dba.mysql.MySQLAdapter
- DB URL: jdbc:mysql://serverhostname/dbname
- Driver Class: com.mysql.jdbc.Driver
@author Andrus Adamchik

        dm.setQuotingSQLIdentifiers(true);
        entity.setDataMap(dm);
        entity.setName("name table");
 
        if(getAccessStackAdapter().getAdapter() instanceof MySQLAdapter){
            MySQLAdapter adaptMySQL = (MySQLAdapter) getAccessStackAdapter().getAdapter();             
            String str = "CREATE TABLE `name table` (`name column` CHAR NULL) ENGINE=InnoDB";            
            assertEquals(str, adaptMySQL.createTable(entity));
        }
     }

View Full Code Here

            DataMap dm = new DataMap();
            dm.setQuotingSQLIdentifiers(true);
            entity.setDataMap(dm);
            entity.setName("name table");


            MySQLAdapter adaptMySQL = (MySQLAdapter) dbAdapter;
            String str = "CREATE TABLE `name table` (`name column` CHAR NULL) ENGINE=InnoDB";
            assertEquals(str, adaptMySQL.createTable(entity));
        }
    }

View Full Code Here

            DataMap dm = new DataMap();
            dm.setQuotingSQLIdentifiers(true);
            entity.setDataMap(dm);
            entity.setName("name table");


            MySQLAdapter adaptMySQL = (MySQLAdapter) dbAdapter;
            String str = "CREATE TABLE `name table` (`name column` CHAR NULL) ENGINE=InnoDB";
            assertEquals(str, adaptMySQL.createTable(entity));
        }
    }

View Full Code Here

TOP

Related Classes of org.apache.cayenne.dba.mysql.MySQLAdapter

org.apache.cayenne.access.jdbc.JdbcEJBQLTranslatorFactory

org.apache.cayenne.access.trans.QualifierTranslator

org.apache.cayenne.access.types.ByteArrayType

org.apache.cayenne.access.types.CharType

org.apache.cayenne.dba.DefaultQuotingStrategy

org.apache.cayenne.dba.JdbcAdapterTest

org.apache.cayenne.dba.QuotingStrategy

org.apache.cayenne.map.DbAttribute

org.apache.cayenne.map.DbRelationship

java.util.List

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of org.apache.cayenne.dba.mysql.MySQLAdapter

Foreign Key Constraint Handling

Sample Connection Settings

Related Classes of org.apache.cayenne.dba.mysql.MySQLAdapter