Não consigo criar as tabelas usando o hibernate

Assuntos Gerais
#1

Olá, estou tendo dificuldade para conseguir fazer o Hibernate gerar as tabelas no banco de dados, será que alguém poderia me ajudar?

Não sei se é o erro, mais aparece assim quando compilo:

2012-12-10 21:07:46,203[HH:mm:ss] INFO [Version] Hibernate Annotations 3.4.0.GA
2012-12-10 21:07:46,234[HH:mm:ss] INFO [Environment] Hibernate 3.3.2.GA
2012-12-10 21:07:46,234[HH:mm:ss] INFO [Environment] loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=com.mysql.jdbc.Driver, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.format_sql=true, hibernate.query.substitutions=yes ‘Y’, no ‘N’, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=root, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:mysql://localhost/sapatos, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=true, hibernate.connection.password=, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
2012-12-10 21:07:46,250[HH:mm:ss] INFO [Environment] using java.io streams to persist binary types
2012-12-10 21:07:46,250[HH:mm:ss] INFO [Environment] Bytecode provider name : javassist
2012-12-10 21:07:46,250[HH:mm:ss] INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
2012-12-10 21:07:46,359[HH:mm:ss] INFO [Version] Hibernate Commons Annotations 3.1.0.GA
2012-12-10 21:07:46,406[HH:mm:ss] INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLMyISAMDialect
2012-12-10 21:07:46,515[HH:mm:ss] INFO [AnnotationBinder] Binding entity from annotated class: br.com.sapatos.sapatos.model.Produto
2012-12-10 21:07:46,578[HH:mm:ss] INFO [EntityBinder] Bind entity br.com.sapatos.sapatos.model.Produto on table Produto
2012-12-10 21:07:46,625[HH:mm:ss] INFO [AnnotationConfiguration] Hibernate Validator not found: ignoring
2012-12-10 21:07:46,687[HH:mm:ss] INFO [SchemaExport] Running hbm2ddl schema export
2012-12-10 21:07:46,703[HH:mm:ss] INFO [SchemaExport] exporting generated schema to database
2012-12-10 21:07:46,703[HH:mm:ss] INFO [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)
2012-12-10 21:07:46,703[HH:mm:ss] INFO [DriverManagerConnectionProvider] Hibernate connection pool size: 1
2012-12-10 21:07:46,703[HH:mm:ss] INFO [DriverManagerConnectionProvider] autocommit mode: false
2012-12-10 21:07:46,718[HH:mm:ss] INFO [DriverManagerConnectionProvider] using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/sapatos
2012-12-10 21:07:46,718[HH:mm:ss] INFO [DriverManagerConnectionProvider] connection properties: {user=root, password=}

drop table if exists Produto

create table Produto (
    codigo_barras bigint not null,
    codigo_produto bigint,
    codigo_verificador char(1) not null,
    cor varchar(255),
    marca varchar(255),
    modelo varchar(255),
    preco double precision not null,
    tamanho integer not null,
    tipo varchar(255),
    primary key (codigo_barras)
) type=MyISAM

2012-12-10 21:07:47,109[HH:mm:ss] ERROR [SchemaExport] Unsuccessful: create table Produto (codigo_barras bigint not null, codigo_produto bigint, codigo_verificador char(1) not null, cor varchar(255), marca varchar(255), modelo varchar(255), preco double precision not null, tamanho integer not null, tipo varchar(255), primary key (codigo_barras)) type=MyISAM
2012-12-10 21:07:47,109[HH:mm:ss] ERROR [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=MyISAM’ at line 1
2012-12-10 21:07:47,109[HH:mm:ss] INFO [SchemaExport] schema export complete
2012-12-10 21:07:47,109[HH:mm:ss] INFO [DriverManagerConnectionProvider] cleaning up connection pool: jdbc:mysql://localhost/sapatos

#2

Aparentemente o dialeto do banco está configurado errado.

Eu nunca usei o banco mysql, entretanto pelo que eu pesquisei existem dois modos que você pode usar, innodb e myisam. Sendo que o dialeto para cada modo muda. Você checou isto?

#3

Muito obrigado Wagner Francisco, ajudou bastante!

#4