yup I've figured out.
I was starting tomcat from eclipse not taking over the original installation. [] Leo On Mon, Jun 3, 2013 at 12:21 PM, Romain Manni-Bucau <[email protected]>wrote: > 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 > > >
