title: Hibernate JPA create table type=InnoDB Problem
body: <p>I have an EJB Project deployed on JBoss with some entity classes.</p>
  
  <p>As soon as I deploy the EJB Jboss gives me this exception:</p>
  
  <pre><code>create table service_db (id integer not null auto_increment, ipAddress varchar(255),      
  primary key (id)) type=InnoDB
  Unsuccessful: create table service_db (id integer not null auto_increment, 
  ipAddress varchar(255), primary key (id)) type=InnoDB
  2011-08-17 11:38:59,997 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=InnoDB' at line 1....
  </code></pre>
  
  <p>Shouldn't it be <strong>engine=InnoDB</strong> instead of type? I tried to execute this statement in mysql without luck (same error). If I remove or replace type with engine it is working.</p>
  
  <p>My question is, who can I change that?</p>
  
  <p>Here is my persistance.xml (in case it is important)</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;persistence version="1.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_1_0.xsd"&gt;
  &lt;persistence-unit name="default"&gt;
  
      &lt;jta-data-source&gt;java:/DUMMY_DS&lt;/jta-data-source&gt;
      &lt;properties&gt;
          &lt;property name="hibernate.hbm2ddl.auto" value="create" /&gt;
          &lt;property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect" /&gt;
      &lt;/properties&gt;
  
  &lt;/persistence-unit&gt;
  </code></pre>
  
  <p></p>
  
  <p>and in case the datasource xml file is important:</p>
  
  <pre><code>&lt;datasources&gt;
   &lt;local-tx-datasource&gt;
    &lt;jndi-name&gt;DUMMY_DS&lt;/jndi-name&gt;
  
     &lt;connection-url&gt;jdbc:mysql://localhost/cargosoft&lt;/connection-url&gt;
     &lt;driver-class&gt;com.mysql.jdbc.Driver&lt;/driver-class&gt;
     &lt;user-name&gt;hauke&lt;/user-name&gt;
     &lt;password&gt;******&lt;/password&gt;
     &lt;min-pool-size&gt;5&lt;/min-pool-size&gt;
     &lt;max-pool-size&gt;20&lt;/max-pool-size&gt;
     &lt;idle-timeout-minutes&gt;10&lt;/idle-timeout-minutes&gt;
     &lt;exception-sorter-class-name&gt;org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter&lt;/exception-sorter-class-name&gt;     
     &lt;valid-connection-checker-class-name&gt;org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker&lt;/valid-connection-checker-class-name&gt;
    &lt;/local-tx-datasource&gt;
  &lt;/datasources&gt;
  </code></pre>
  
  <p>Thanks for your help.</p>
  
  <p>Hauke</p>