Discussoes de Programacao e Tecnologia

Relacionamento entre tabelas no Hibernate no MySQL

4 respostas
A
Alvinegro

Bom dia,

O hibernate não está criando o relacionamento entre as tabelas no MySql… Estranho que se eu mudo para o MsSql ele cria tudo sem problemas…
Alguma idéia do que pode estar acontecendo?

Obrigado,

Alura Análise de Dados Desenvolva hard skills técnicas e soft skills essenciais para trabalhar de forma colaborativa,...

4 Respostas

A
alots_ssa

Cara vc deu uma olhada no log gerado pelo hibernate? É que quando ocorre uma exception usando o SchemaExport ou Schemaupdate ela não imprime a exception. Da uma olhada nas coisas basicas tb, ta trocando as configuracoes de driver, url de acesso ao banco toda vez que tenta gerar para o MySQL?

Alberto

Wolf_X
Wolf_X

talves o driver do Mysql nao esteja sendo carregado no .cfg, da uma olhada ai.

A
Alvinegro

O que pode ser?!?!?

O meu cfg está assim…

<hibernate-configuration>
    <session-factory>
    
		<property name="connection.url">jdbc:mysql://192.168.0.1:3306/Academia2</property>
		<property name="connection.username">blabla</property>
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="connection.password">blabla</property>
	 	<property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
		
        <!-- Enable Hibernate's automatic session context management -->
        <property name="hibernate.bytecode.use_reflection_optimizer">false</property>
        <property name="hibernate.current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->
       <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
		
        <!-- Echo all executed SQL to stdout -->
       	<property name="hbm2ddl.auto">update</property>
        <property name="show_sql">false</property>
		
	    <property name="hibernate.generate_statistics">false</property>
	    <property name="hibernate.use_sql_comments">true</property>

		<mapping resource="br/com/ohmtech/gip/acesso/movimento/Acesso_Evento.hbm.xml"/> 
		<mapping resource="br/com/ohmtech/gip/acesso/movimento/Acesso_Grupo.hbm.xml"/> 
		<mapping resource="br/com/ohmtech/gip/acesso/movimento/Acesso_Individuo.hbm.xml"/> 
		<mapping resource="br/com/ohmtech/gip/acesso/movimento/Acesso_Ponto.hbm.xml"/> 
		<mapping resource="br/com/ohmtech/gip/acesso/movimento/Acesso_Schedule.hbm.xml"/> 
		<mapping resource="br/com/ohmtech/gip/acesso/movimento/Acesso_Transacao.hbm.xml"/> 

    </session-factory>
</hibernate-configuration>

O Log está assim…

02/10/2007 13:03:55 org.hibernate.cfg.Environment 

INFO: Hibernate 3.2.0

02/10/2007 13:03:55 org.hibernate.cfg.Environment 

INFO: hibernate.properties not found

02/10/2007 13:03:55 org.hibernate.cfg.Environment buildBytecodeProvider

INFO: Bytecode provider name : cglib

02/10/2007 13:03:55 org.hibernate.cfg.Environment 

INFO: using JDK 1.4 java.sql.Timestamp handling

02/10/2007 13:03:55 org.hibernate.cfg.Configuration configure

INFO: configuring from resource: hibernate.cfg.xml

02/10/2007 13:03:55 org.hibernate.cfg.Configuration getConfigurationInputStream

INFO: Configuration resource: hibernate.cfg.xml

02/10/2007 13:03:56 org.hibernate.cfg.Configuration addResource

INFO: Reading mappings from resource: br/com/ohmtech/gip/acesso/movimento/Acesso_Evento.hbm.xml

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

INFO: Mapping class: br.com.ohmtech.gip.acesso.movimento.Acesso_Evento -> Acesso_Eventos

02/10/2007 13:03:56 org.hibernate.cfg.Configuration addResource

INFO: Reading mappings from resource: br/com/ohmtech/gip/acesso/movimento/Acesso_Grupo.hbm.xml

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

INFO: Mapping class: br.com.ohmtech.gip.acesso.movimento.Acesso_Grupo -> Acesso_Grupos

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollection

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Grupo.schedule -> Acesso_GrupoSchedules

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollection

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Grupo.individuos -> Acesso_GrupoIndividuos

02/10/2007 13:03:56 org.hibernate.cfg.Configuration addResource

INFO: Reading mappings from resource: br/com/ohmtech/gip/acesso/movimento/Acesso_Individuo.hbm.xml

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

INFO: Mapping class: br.com.ohmtech.gip.acesso.movimento.Acesso_Individuo -> Acesso_Individuos

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollection

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Individuo.schedules -> Acesso_ScheduleIndividuo

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollection

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Individuo.grupos -> Acesso_GrupoIndividuos

02/10/2007 13:03:56 org.hibernate.cfg.Configuration addResource

INFO: Reading mappings from resource: br/com/ohmtech/gip/acesso/movimento/Acesso_Ponto.hbm.xml

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

INFO: Mapping class: br.com.ohmtech.gip.acesso.movimento.Acesso_Ponto -> Acesso_Pontos

02/10/2007 13:03:56 org.hibernate.cfg.Configuration addResource

INFO: Reading mappings from resource: br/com/ohmtech/gip/acesso/movimento/Acesso_Schedule.hbm.xml

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

INFO: Mapping class: br.com.ohmtech.gip.acesso.movimento.Acesso_Schedule -> Acesso_Schedules

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollection

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Schedule.grupos -> Acesso_GrupoSchedules

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollection

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Schedule.individuos -> Acesso_ScheduleIndividuo

02/10/2007 13:03:56 org.hibernate.cfg.Configuration addResource

INFO: Reading mappings from resource: br/com/ohmtech/gip/acesso/movimento/Acesso_Transacao.hbm.xml

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

INFO: Mapping class: br.com.ohmtech.gip.acesso.movimento.Acesso_Transacao -> Acesso_Transacoes

02/10/2007 13:03:56 org.hibernate.cfg.Configuration doConfigure

INFO: Configured SessionFactory: null

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollectionSecondPass

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Evento.transacoes -> Acesso_Transacoes

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollectionSecondPass

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Grupo.grupos -> Acesso_Grupos

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollectionSecondPass

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Individuo.transacoes -> Acesso_Transacoes

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollectionSecondPass

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Ponto.schedules -> Acesso_Schedules

02/10/2007 13:03:56 org.hibernate.cfg.HbmBinder bindCollectionSecondPass

INFO: Mapping collection: br.com.ohmtech.gip.acesso.movimento.Acesso_Ponto.transacoes -> Acesso_Transacoes

02/10/2007 13:03:56 org.hibernate.connection.DriverManagerConnectionProvider configure

INFO: Using Hibernate built-in connection pool (not for production use!)

02/10/2007 13:03:56 org.hibernate.connection.DriverManagerConnectionProvider configure

INFO: Hibernate connection pool size: 20

02/10/2007 13:03:56 org.hibernate.connection.DriverManagerConnectionProvider configure

INFO: autocommit mode: false

02/10/2007 13:03:56 org.hibernate.connection.DriverManagerConnectionProvider configure

INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://192.168.0.1:3306/Academia2

02/10/2007 13:03:56 org.hibernate.connection.DriverManagerConnectionProvider configure

INFO: connection properties: {user=egas, password=****}

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: RDBMS: MySQL, version: 5.0.21-Debian_3ubuntu1-log

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )

02/10/2007 13:03:58 org.hibernate.dialect.Dialect 

INFO: Using dialect: org.hibernate.dialect.MySQLDialect

02/10/2007 13:03:58 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory

INFO: Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory

02/10/2007 13:03:58 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup

INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Automatic flush during beforeCompletion(): disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Automatic session close at end of transaction: disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: JDBC batch size: 15

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: JDBC batch updates for versioned data: disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Scrollable result sets: enabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: JDBC3 getGeneratedKeys(): enabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Connection release mode: auto

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Maximum outer join fetch depth: 2

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Default batch fetch size: 1

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Generate SQL with comments: enabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Order SQL updates by primary key: disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory

INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory

02/10/2007 13:03:58 org.hibernate.hql.ast.ASTQueryTranslatorFactory 

INFO: Using ASTQueryTranslatorFactory

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Query language substitutions: {}

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: JPA-QL strict compliance: disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Second-level cache: enabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Query cache: disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory createCacheProvider

INFO: Cache provider: org.hibernate.cache.NoCacheProvider

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Optimize cache for minimal puts: disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Structured second-level cache entries: disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Statistics: disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Deleted entity synthetic identifier rollback: disabled

02/10/2007 13:03:58 org.hibernate.cfg.SettingsFactory buildSettings

INFO: Default entity-mode: pojo

02/10/2007 13:03:58 org.hibernate.impl.SessionFactoryImpl 

INFO: building session factory

02/10/2007 13:03:59 org.hibernate.impl.SessionFactoryObjectFactory addInstance

INFO: Not binding factory to JNDI, no JNDI name configured

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.SchemaUpdate execute

INFO: Running hbm2ddl schema update

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.SchemaUpdate execute

INFO: fetching database metadata

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.SchemaUpdate execute

INFO: updating schema

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Eventos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_GrupoIndividuos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_GrupoSchedules

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Grupos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Individuos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Pontos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_ScheduleIndividuo

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Schedules

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Transacoes

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Eventos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_GrupoIndividuos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_GrupoSchedules

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Grupos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Individuos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Pontos

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_ScheduleIndividuo

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Schedules

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

INFO: table not found: Acesso_Transacoes

02/10/2007 13:03:59 org.hibernate.tool.hbm2ddl.SchemaUpdate execute

INFO: schema update complete
A
Alvinegro

Descobri!!!

Era a porcaria do dialect …
Deve ser assim…

<property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>

falow!!!

Criado 2 de outubro de 2007
Ultima resposta 2 de out. de 2007
Respostas 4
Participantes 3

Topicos relacionados

Componente de forum 4 respostas Consultar CPF pelo nome na Receita Federal 5 respostas Pegadinhas que se fazem com os pobres estagiários 62 respostas [Resolvido] Como comparar Strings em C? 6 respostas Converter pixels para centímetros 9 respostas
Alura O que é Python? — um guia completo para iniciar nessa linguagem de programação Acesse agora o guia sobre Python e inicie sua jornada nessa linguagem de programação: o que é e para que serve, sua sintaxe e como iniciar nela!
Lumina Lumina: a IA que te traz resultados Prompts prontos por especialistas. Resolva seus problemas de verdade.