Hi I've downloaded moviefun and altered it to use mysql just adding the dictionary reference in persistence.xml
<?xml version="1.0" encoding="UTF-8"?> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd";> <persistence-unit name="movie-unit"> <jta-data-source>movieDatabase</jta-data-source> <non-jta-data-source>movieDatabaseUnmanaged</non-jta-data-source> <class>org.superbiz.moviefun.Movie</class> <properties> * <property name="openjpa.jdbc.DBDictionary" value="org.apache.openjpa.jdbc.sql.MySQLDictionary"/>* <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/> </properties> </persistence-unit> </persistence> then I've got, while running setup SEVERE: Servlet.service() for servlet [jsp] in context with path [/POC_TomEE] threw exception [javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is: <openjpa-2.2.0-r422266:1244990 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: unexpected token: ENGINE {stmnt -784895282 *CREATE TABLE Movie (id BIGINT NOT NULL, director VARCHAR(255), genre VARCHAR(255), rating INTEGER, title VARCHAR(255), year INTEGER, PRIMARY KEY (id)) ENGINE = innodb*} [code=-5581, state=42581]] with root cause org.apache.openjpa.lib.jdbc.ReportingSQLException: unexpected token: ENGINE {stmnt -784895282 CREATE TABLE Movie (id BIGINT NOT NULL, director VARCHAR(255), genre VARCHAR(255), rating INTEGER, title VARCHAR(255), year INTEGER, PRIMARY KEY (id)) ENGINE = innodb} [code=-5581, state=42581] although, the query above seems to work perfectly in mysql mysql> *CREATE TABLE Movie (id BIGINT NOT NULL, director VARCHAR(255), genre VARCHAR(255), rating INTEGER, title VARCHAR(255), year INTEGER, PRIMARY KEY (id)) ENGINE = innodb;* Query OK, 0 rows affected (0.41 sec) am I missing something? TIA Leo
