Generate DDL JPA com Hibernate

Assuntos Gerais
#1

Estou tentando configurar minha aplicação para criar as tabelas no banco MySQL caso nao exista, ao iniciar a aplicação, mas não esta criando nem disparando erros.

Segue o meu applicationContext do Spring

[code]<tx:annotation-driven transaction-manager=“txManager” />

&lt;bean id="txManager" class="org.springframework.orm.jpa.JpaTransactionManager"&gt;
    &lt;property name="entityManagerFactory" ref="entityManagerFactory" /&gt;
&lt;/bean&gt;

&lt;bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"&gt;
    &lt;property name="dataSource" ref="myDataSource" /&gt;
    &lt;property name="jpaVendorAdapter"&gt;
        &lt;bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"&gt;
            &lt;property name="showSql" value="${jpa.show.sql}" /&gt;
            &lt;property name="generateDdl" value="${jpa.generateDdl}" /&gt; 
        &lt;/bean&gt;
    &lt;/property&gt;
    &lt;property name="jpaProperties"&gt;
        &lt;props&gt;
            &lt;prop key="hibernate.dialect"&gt;${jpa.dialect}&lt;/prop&gt;
            &lt;prop key="hibernate.format_sql"&gt;${jpa.format_sql}&lt;/prop&gt;
        &lt;/props&gt;
    &lt;/property&gt;
&lt;/bean&gt;

&lt;bean id="myDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"&gt;
    &lt;property name="driverClassName" value="${db.driverClassName}" /&gt;
    &lt;property name="url" value="${db.url}" /&gt;
    &lt;property name="username" value="${db.username}" /&gt;
    &lt;property name="password" value="${db.password}" /&gt;
&lt;/bean&gt;

&lt;bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" /&gt;[/code]

db.driverClassName=com.mysql.jdbc.Driver db.url=jdbc:mysql://localhost/test db.username=root db.password=123456 jpa.show.sql=true jpa.format_sql=true jpa.dialect=org.hibernate.dialect.MySQLInnoDBDialect jpa.generateDdl=true

O valor de jpa.generateDdl é true.

O que esta errado na configuração, estou utilizando o MySQL 5.6

#2

Olhei o log novamente e esta dando o seguinte erro

ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table role (id integer not null auto_increment, descricao varchar(255), primary key (id)) type=InnoDB 1206 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 1207 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table usuario (id integer not null auto_increment, ativo bit not null, nome varchar(255), password varchar(20), username varchar(50), primary key (id), unique (username)) type=InnoDB 1207 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 1207 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table usuarioRole (idUsuario integer not null, idRole integer not null) type=InnoDB 1207 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 1207 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table usuarioRole add index FK3112A0C45D102DD7 (idUsuario), add constraint FK3112A0C45D102DD7 foreign key (idUsuario) references usuario (id) 1207 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Table 'test.usuariorole' doesn't exist 1208 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table usuarioRole add index FK3112A0C48FBF6351 (idRole), add constraint FK3112A0C48FBF6351 foreign key (idRole) references role (id) 1208 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Table 'test.usuariorole' doesn't exist

Como eu tiro esse type=InnoDB da execucao das querys?

#3