Hi did you configure movieDatabaseUnmanaged and movieDatabase to point to the mysql database?
*Romain Manni-Bucau* *Twitter: @rmannibucau <https://twitter.com/rmannibucau>* *Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/> *LinkedIn: **http://fr.linkedin.com/in/rmannibucau* *Github: https://github.com/rmannibucau* 2013/6/3 Leonardo K. Shikida <[email protected]> > 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 >
