Discussoes de Programacao e Tecnologia

Problema ao tentar gerar tabela a partir de entity com JPA

26 respostas
JhowTroMundo
JhowTroMundo

Boa tarde, galera.

Estou começando a estudar JPA com uma apostila da K19, mas estou tendo problemas logo no primeiro exercício.

Não estou conseguindo gerar uma tabela a partir da Entity.

persistence.xml:

<?xml version="1.0" encoding="UTF-8"?>
<persistence 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"
 	version="1.0">

	<persistence-unit name="livraria" transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<class>com.livraria.entidades.Editora</class>
		<properties>
			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
			<property name="hibernate.hbm2dll.auto" value="create"/>
			<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
			<property name="javax.persistence.jdbc.user" value="root"/>
			<property name="javax.persistence.jdbc.password" value="root"/>
			<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/livraria"/>
			<property name="hibernate.show_sql" value="true"/>  
            <property name="hibernate.format_sql" value="true"/> 
		</properties>
	</persistence-unit>
	
</persistence>

Entity:

package com.livraria.entidades;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;

@Entity(name="editora")
public class Editora {
	@Id
	@GeneratedValue
	private Long id;
	private String nome;
	private String email;
	
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public String getNome() {
		return nome;
	}
	public void setNome(String nome) {
		this.nome = nome;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
}

main:

package com.livraria.entidades;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;


public class GeraTabelas {
	public static void main(String[] args){
		EntityManagerFactory factory = Persistence.createEntityManagerFactory("livraria");
		
		EntityManager manager = factory.createEntityManager();
		
		Editora editora = new Editora();
		editora.setEmail("email");
		editora.setNome("Nome editora");
		
		manager.persist(editora);
		
		factory.close();
		System.out.println("ok");
		
	}
}

log:

0 [main] INFO  org.hibernate.annotations.common.Version - HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
13 [main] INFO  org.hibernate.Version - HHH000412: Hibernate Core {4.1.3.Final}
17 [main] INFO  org.hibernate.cfg.Environment - HHH000206: hibernate.properties not found
19 [main] INFO  org.hibernate.cfg.Environment - HHH000021: Bytecode provider name : javassist
650 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000402: Using Hibernate built-in connection pool (not for production use!)
659 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000115: Hibernate connection pool size: 20
660 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000006: Autocommit mode: true
660 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000401: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/livraria]
660 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000046: Connection properties: {user=root, password=****, autocommit=true, release_mode=auto}
975 [main] INFO  org.hibernate.dialect.Dialect - HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
1014 [main] INFO  org.hibernate.engine.transaction.internal.TransactionFactoryInitiator - HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
1028 [main] INFO  org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
Mai 25, 2012 12:22:46 PM org.hibernate.validator.util.Version <clinit>
INFO: Hibernate Validator 4.1.0.Final
Mai 25, 2012 12:22:46 PM org.hibernate.validator.engine.resolver.DefaultTraversableResolver detectJPA
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
Mai 25, 2012 12:22:46 PM org.hibernate.validator.engine.resolver.DefaultTraversableResolver detectJPA
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
1699 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000030: Cleaning up connection pool [jdbc:mysql://localhost:3306/livraria]

Ja tentei varias soluções apontadas em alguns tópicos mas nenhuma funcionou.

alguem consegue visualizar o problema?

Obrigado!

Alura Sistemas operacionais: entenda seu conceito e suas funções Descubra o que são sistemas operacionais, suas funções e tipos. Aprenda tudo de forma clara e objetiva. Não perca tempo!

26 Respostas

tmvolpato
tmvolpato

poste o log inteiro

porque essa parte que você postou é apenas INFO e não erro

Att

JhowTroMundo
JhowTroMundo

tmvolpato:
poste o log inteiro

porque essa parte que você postou é apenas INFO e não erro

Att

Esse é o log inteiro.

Não há erro mesmo. Antes houvesse!!

tmvolpato
tmvolpato

troque create para update

Testa ai

JhowTroMundo
JhowTroMundo

tmvolpato:
troque create para update

Testa ai

Já tentei validade, update, create. Mesma coisa.

tmvolpato
tmvolpato

já sei o que é

eu não costumo fazer desse jeito

Você tem uma classe gerar tabela, se eu nao me engano o nome tem que ser igual ao passado nessa classe

preciso ver aqui

tmvolpato
tmvolpato

não adianta eu mostrar codigo diferente do seu

entao vai um link que vai te ajuda

http://www.java2s.com/Code/Java/JPA/CreateEntityManagerFactory.htm

JhowTroMundo
JhowTroMundo

tmvolpato:
já sei o que é

eu não costumo fazer desse jeito

Você tem uma classe gerar tabela, se eu nao me engano o nome tem que ser igual ao passado nessa classe

preciso ver aqui

Cara, nao entendi o que vc quis dizer aqui.

tmvolpato:
não adianta eu mostrar codigo diferente do seu

entao vai um link que vai te ajuda

http://www.java2s.com/Code/Java/JPA/CreateEntityManagerFactory.htm

Eu observei o código e vi que a maior diferença é que ele usa transação, mas isso só na inclusão do Professor, e nao na criação da tabela.

As vezes adianta sim me mostrar um codigo diferente. Eu posso pegar a ideia.

Valeu pela ajuda cara, mas poderia me enviar o o jeito que você faz?

fabiozanardi
fabiozanardi

você não especificou o tipo de auto incremento no id, tente mudar esse pedaço do codigo de sua entidade:

@Id  
    @GeneratedValue  
    private Long id;

@Id  
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Long id;
JhowTroMundo
JhowTroMundo

fabiozanardi:
você não especificou o tipo de auto incremento no id, tente mudar esse pedaço do codigo de sua entidade:

@Id  
    @GeneratedValue  
    private Long id;

@Id  
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Long id;

Acho que quando a estratégia não é especificada a padrão do banco é usada, no caso o auto incremento do MySQL.
Mas o problema não se trata da inclusão em si, e sim dageração da tabela a partir da entidade.

Li em algum lugar que a versão do hibernate que eu estava usando (4.x) está cheia de bugs, incluindo isso de não gerar a tabela.
Então fiz o downgrade pra versão 3.5.

Executei o mesmo código e agora, pelo menos, ocorre um erro:

Exception in thread "main" javax.persistence.PersistenceException: No Persistence provider for EntityManager named livraria
	at javax.persistence.Persistence.createEntityManagerFactory(Unknown Source)
	at javax.persistence.Persistence.createEntityManagerFactory(Unknown Source)
	at com.livraria.entidades.GeraTabelas.main(GeraTabelas.java:10)

O que seria esse “Persistence provider”?

Vou descobrir.

Obrigado pelas dicas.

fabiozanardi
fabiozanardi

seu persistence.xml está em uma pasta chamada META-INF/ dentro do classpath?

JhowTroMundo
JhowTroMundo

fabiozanardi:
seu persistence.xml está em uma pasta chamada META-INF/ dentro do classpath?

Cara, tá dentro de WebContent/WEB-INF/classes/META-INF

fabiozanardi
fabiozanardi

não deve ficar ai, coloque dentro da pasta que tem seus .class da aplicação, ai é para dar certo, se estiver usando o eclipse para testar, crie 1 pasta chamada META-INF dentro do src/ e jogue o persistence la dentro, veja se da certo

JhowTroMundo
JhowTroMundo

src/META-INF/persistence.xml

Só o problema que persiste kkk

Nao faço ideia do que pode estar acontecendo.

fabiozanardi
fabiozanardi

zipa seu projeto e manda no meu email, vou tentar rodar aqui

[email removido]

JhowTroMundo
JhowTroMundo

fabiozanardi:
zipa seu projeto e manda no meu email, vou tentar rodar aqui

[email removido]

Enviado.

Valeu, fabio!

fabiozanardi
fabiozanardi

está faltando o JAR jar hibernate-persistence-manager, coloca ele na pasta de libs e testa novamente

fabiozanardi
fabiozanardi

O problema é realmente os jars necessários da aplicação, coloque todos na pasta de libs do seu projeto, e adicione os jars do hibernate, dom4j, etc no classpath do eclise, o projeto vai rodar normalmente

se nao der certo da 1 toque

abraço

fabiozanardi
fabiozanardi

ups, esqueci de postar os jars necessários do hibernate:

hibernate-jpa-2.0-api-1.0.1.Final.jar
hibernate3.jar
jta-1.1jar

e as depencencias deles,

fabiozanardi
fabiozanardi

deu certo?

JhowTroMundo
JhowTroMundo

Cara, ainda não consegui testar.
Apareceram outras tretas pra resolver aqui e tive de parar de estudar.
Mais tarde eu adiciono esses jars ai e te dou um feedback.
Valeu mesmo pela boa vontade!

JhowTroMundo
JhowTroMundo

Todos os jars estão no classpath, menos o hibernate-persistence-manager que não consigo encontrar em lugar nenhum. Não venho como hibernate e não acho pra baixar. To sendo muito noob?

fabiozanardi
fabiozanardi

ele fica dentro do pacote hibernate3.jar, tem alguma coisa que está fazendo com que sua app não encontre os jars

JhowTroMundo
JhowTroMundo

Entendi.

Criei um projeto JSE e baixei a API logback.

O resultado do log foi o seguinte:

11:53:16.559 [main] INFO  o.hibernate.cfg.annotations.Version - Hibernate Annotations 3.5.1-Final
11:53:16.591 [main] INFO  org.hibernate.cfg.Environment - Hibernate 3.5.1-Final
11:53:16.593 [main] INFO  org.hibernate.cfg.Environment - hibernate.properties not found
11:53:16.599 [main] INFO  org.hibernate.cfg.Environment - Bytecode provider name : javassist
11:53:16.605 [main] INFO  org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
11:53:16.749 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [uuid] -> [class org.hibernate.id.UUIDHexGenerator]
11:53:16.754 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [hilo] -> [class org.hibernate.id.TableHiLoGenerator]
11:53:16.755 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [assigned] -> [class org.hibernate.id.Assigned]
11:53:16.758 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [identity] -> [class org.hibernate.id.IdentityGenerator]
11:53:16.759 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [select] -> [class org.hibernate.id.SelectGenerator]
11:53:16.762 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [sequence] -> [class org.hibernate.id.SequenceGenerator]
11:53:16.763 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [seqhilo] -> [class org.hibernate.id.SequenceHiLoGenerator]
11:53:16.765 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [increment] -> [class org.hibernate.id.IncrementGenerator]
11:53:16.766 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [foreign] -> [class org.hibernate.id.ForeignGenerator]
11:53:16.767 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [guid] -> [class org.hibernate.id.GUIDGenerator]
11:53:16.768 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [uuid.hex] -> [class org.hibernate.id.UUIDHexGenerator]
11:53:16.769 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [sequence-identity] -> [class org.hibernate.id.SequenceIdentityGenerator]
11:53:16.771 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [enhanced-sequence] -> [class org.hibernate.id.enhanced.SequenceStyleGenerator]
11:53:16.775 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [enhanced-table] -> [class org.hibernate.id.enhanced.TableGenerator]
11:53:16.786 [main] INFO  o.h.annotations.common.Version - Hibernate Commons Annotations 3.2.0.Final
11:53:16.797 [main] INFO  org.hibernate.ejb.Version - Hibernate EntityManager 3.4.0.GA
11:53:16.797 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [uuid] -> [class org.hibernate.id.UUIDHexGenerator]
11:53:16.798 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [hilo] -> [class org.hibernate.id.TableHiLoGenerator]
11:53:16.798 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [assigned] -> [class org.hibernate.id.Assigned]
11:53:16.798 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [identity] -> [class org.hibernate.id.IdentityGenerator]
11:53:16.798 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [select] -> [class org.hibernate.id.SelectGenerator]
11:53:16.798 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [sequence] -> [class org.hibernate.id.SequenceGenerator]
11:53:16.798 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [seqhilo] -> [class org.hibernate.id.SequenceHiLoGenerator]
11:53:16.798 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [increment] -> [class org.hibernate.id.IncrementGenerator]
11:53:16.798 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [foreign] -> [class org.hibernate.id.ForeignGenerator]
11:53:16.799 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [guid] -> [class org.hibernate.id.GUIDGenerator]
11:53:16.799 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [uuid.hex] -> [class org.hibernate.id.UUIDHexGenerator]
11:53:16.799 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [sequence-identity] -> [class org.hibernate.id.SequenceIdentityGenerator]
11:53:16.799 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [enhanced-sequence] -> [class org.hibernate.id.enhanced.SequenceStyleGenerator]
11:53:16.800 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Registering IdentifierGenerator strategy [enhanced-table] -> [class org.hibernate.id.enhanced.TableGenerator]
11:53:16.828 [main] DEBUG org.hibernate.ejb.Ejb3Configuration - Look up for persistence unit: livraria
11:53:16.929 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to resolve system-id [http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd]
11:53:17.018 [main] DEBUG org.hibernate.ejb.Ejb3Configuration - Detect class: true; detect hbm: true
11:53:17.034 [main] DEBUG o.h.ejb.packaging.AbstractJarVisitor - Searching mapped entities in jar/par: file:/C:/Users/jrosendo/Documents/Personal/Eclipse/workspace/JPA/bin/
11:53:17.036 [main] DEBUG o.h.ejb.packaging.AbstractJarVisitor - Filtering: com.livraria.entidades.Editora
11:53:17.078 [main] DEBUG o.h.ejb.packaging.AbstractJarVisitor - Java element filter matched for com.livraria.entidades.Editora
11:53:17.080 [main] DEBUG o.h.ejb.packaging.AbstractJarVisitor - Filtering: com.livraria.entidades.GeraTabelas
11:53:17.105 [main] DEBUG org.hibernate.ejb.Ejb3Configuration - Detect class: true; detect hbm: true
11:53:17.105 [main] DEBUG org.hibernate.ejb.Ejb3Configuration - Creating Factory: livraria
11:53:17.119 [main] DEBUG o.h.cfg.AnnotationConfiguration - Execute first pass mapping processing
11:53:17.170 [main] DEBUG o.h.cfg.AnnotationConfiguration - Process hbm files
11:53:17.171 [main] DEBUG o.h.cfg.AnnotationConfiguration - Process annotated classes
11:53:17.176 [main] INFO  org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: com.livraria.entidades.Editora
11:53:17.212 [main] DEBUG org.hibernate.cfg.Ejb3Column - Binding column: Ejb3DiscriminatorColumn{logicalColumnName'DTYPE', discriminatorTypeName='string'}
11:53:17.215 [main] DEBUG org.hibernate.cfg.AnnotationBinder - no value specified for 'javax.persistence.sharedCache.mode'; using UNSPECIFIED
11:53:17.232 [main] DEBUG o.h.cfg.annotations.EntityBinder - Import with entity name editora
11:53:17.238 [main] INFO  o.h.cfg.annotations.EntityBinder - Bind entity com.livraria.entidades.Editora on table editora
11:53:17.308 [main] DEBUG org.hibernate.cfg.Ejb3Column - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(editora), mappingColumn=id, insertable=true, updatable=true, unique=false}
11:53:17.314 [main] DEBUG o.h.cfg.annotations.PropertyBinder - binding property id with lazy=false
11:53:17.317 [main] DEBUG o.h.c.annotations.SimpleValueBinder - building SimpleValue for id
11:53:17.320 [main] DEBUG o.h.cfg.annotations.PropertyBinder - Building property id
11:53:17.325 [main] DEBUG org.hibernate.cfg.Ejb3Column - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(editora), mappingColumn=email, insertable=true, updatable=true, unique=false}
11:53:17.325 [main] DEBUG o.h.cfg.annotations.PropertyBinder - binding property email with lazy=false
11:53:17.325 [main] DEBUG o.h.c.annotations.SimpleValueBinder - building SimpleValue for email
11:53:17.325 [main] DEBUG o.h.cfg.annotations.PropertyBinder - Building property email
11:53:17.326 [main] DEBUG org.hibernate.cfg.Ejb3Column - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(editora), mappingColumn=nome, insertable=true, updatable=true, unique=false}
11:53:17.326 [main] DEBUG o.h.cfg.annotations.PropertyBinder - binding property nome with lazy=false
11:53:17.326 [main] DEBUG o.h.c.annotations.SimpleValueBinder - building SimpleValue for nome
11:53:17.326 [main] DEBUG o.h.cfg.annotations.PropertyBinder - Building property nome
11:53:17.332 [main] DEBUG o.h.c.annotations.SimpleValueBinder - setting SimpleValue typeName for id
11:53:17.332 [main] DEBUG o.h.c.annotations.SimpleValueBinder - setting SimpleValue typeName for email
11:53:17.332 [main] DEBUG o.h.c.annotations.SimpleValueBinder - setting SimpleValue typeName for nome
11:53:17.333 [main] DEBUG o.h.cfg.AnnotationConfiguration - processing fk mappings (*ToOne and JoinedSubclass)
11:53:17.335 [main] DEBUG org.hibernate.cfg.Configuration - processing extends queue
11:53:17.335 [main] DEBUG org.hibernate.cfg.Configuration - processing collection mappings
11:53:17.335 [main] DEBUG org.hibernate.cfg.Configuration - processing native query and ResultSetMapping mappings
11:53:17.335 [main] DEBUG org.hibernate.cfg.Configuration - processing association property references
11:53:17.335 [main] DEBUG org.hibernate.cfg.Configuration - processing foreign key constraints
11:53:17.337 [main] INFO  o.h.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
11:53:17.360 [main] DEBUG org.hibernate.ejb.util.NamingHelper - No JNDI name configured for binding Ejb3Configuration
11:53:17.363 [main] DEBUG o.h.cfg.AnnotationConfiguration - Legacy Validator not present in classpath, ignoring event listener registration
11:53:17.369 [main] DEBUG o.h.c.s.HibernateSearchEventListenerRegister - Search not present in classpath, ignoring event listener registration.
11:53:17.369 [main] INFO  o.h.c.s.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
11:53:17.369 [main] DEBUG org.hibernate.cfg.Configuration - Preparing to build session factory with filters : {}
11:53:17.369 [main] DEBUG o.h.cfg.AnnotationConfiguration - Execute first pass mapping processing
11:53:17.369 [main] DEBUG o.h.cfg.AnnotationConfiguration - Process hbm files
11:53:17.369 [main] DEBUG o.h.cfg.AnnotationConfiguration - Process annotated classes
11:53:17.369 [main] DEBUG o.h.cfg.AnnotationConfiguration - processing fk mappings (*ToOne and JoinedSubclass)
11:53:17.369 [main] DEBUG org.hibernate.cfg.Configuration - processing extends queue
11:53:17.370 [main] DEBUG org.hibernate.cfg.Configuration - processing collection mappings
11:53:17.370 [main] DEBUG org.hibernate.cfg.Configuration - processing native query and ResultSetMapping mappings
11:53:17.370 [main] DEBUG org.hibernate.cfg.Configuration - processing association property references
11:53:17.370 [main] DEBUG org.hibernate.cfg.Configuration - processing foreign key constraints
11:53:17.430 [main] WARN  o.h.c.UserSuppliedConnectionProvider - No connection properties specified - the user must supply JDBC connections
11:53:17.455 [main] INFO  org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
11:53:17.459 [main] INFO  o.h.engine.jdbc.JdbcSupportLoader - Disabling contextual LOB creation as connection was null
11:53:17.460 [main] INFO  o.h.t.TransactionFactoryFactory - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
11:53:17.462 [main] INFO  o.h.t.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
11:53:17.462 [main] INFO  org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
11:53:17.462 [main] INFO  org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
11:53:17.462 [main] INFO  org.hibernate.cfg.SettingsFactory - Scrollable result sets: disabled
11:53:17.462 [main] DEBUG org.hibernate.cfg.SettingsFactory - Wrap result sets: disabled
11:53:17.462 [main] INFO  org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
11:53:17.462 [main] INFO  org.hibernate.cfg.SettingsFactory - Connection release mode: auto
11:53:17.463 [main] INFO  org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
11:53:17.463 [main] INFO  org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
11:53:17.463 [main] INFO  org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
11:53:17.463 [main] INFO  org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
11:53:17.463 [main] INFO  org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
11:53:17.463 [main] INFO  org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
11:53:17.465 [main] INFO  o.h.h.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
11:53:17.465 [main] INFO  org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
11:53:17.465 [main] INFO  org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: enabled
11:53:17.465 [main] INFO  org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
11:53:17.466 [main] INFO  org.hibernate.cfg.SettingsFactory - Query cache: disabled
11:53:17.466 [main] INFO  org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
11:53:17.466 [main] INFO  org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
11:53:17.466 [main] INFO  org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
11:53:17.470 [main] INFO  org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
11:53:17.471 [main] INFO  org.hibernate.cfg.SettingsFactory - Statistics: disabled
11:53:17.471 [main] INFO  org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
11:53:17.471 [main] INFO  org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
11:53:17.471 [main] INFO  org.hibernate.cfg.SettingsFactory - Named query checking : enabled
11:53:17.471 [main] INFO  org.hibernate.cfg.SettingsFactory - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
11:53:17.511 [main] INFO  o.hibernate.impl.SessionFactoryImpl - building session factory
11:53:17.520 [main] DEBUG o.hibernate.impl.SessionFactoryImpl - Session factory constructed with filter configurations : {}
11:53:17.520 [main] DEBUG o.hibernate.impl.SessionFactoryImpl - instantiating session factory with properties: {java.vendor=Oracle Corporation, sun.java.launcher=SUN_STANDARD, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, hibernate.ejb.discard_pc_on_close=false, hibernate.transaction.flush_before_completion=false, os.name=Windows 7, sun.boot.class.path=C:\Program Files\Java\jre7\lib\resources.jar;C:\Program Files\Java\jre7\lib\rt.jar;C:\Program Files\Java\jre7\lib\sunrsasign.jar;C:\Program Files\Java\jre7\lib\jsse.jar;C:\Program Files\Java\jre7\lib\jce.jar;C:\Program Files\Java\jre7\lib\charsets.jar;C:\Program Files\Java\jre7\lib\jfr.jar;C:\Program Files\Java\jre7\classes, user.country.format=BR, sun.desktop=windows, java.vm.specification.vendor=Oracle Corporation, java.runtime.version=1.7.0_04-b22, hibernate.connection.autocommit=true, javax.persistence.jdbc.user=root, user.name=jrosendo, user.language.format=pt, hibernate.connection.release_mode=auto, hibernate.hbm2dll.auto=update, user.language=en, sun.boot.library.path=C:\Program Files\Java\jre7\bin, java.version=1.7.0_04, user.timezone=America/Sao_Paulo, sun.arch.data.model=64, java.endorsed.dirs=C:\Program Files\Java\jre7\lib\endorsed, sun.cpu.isalist=amd64, sun.jnu.encoding=Cp1252, file.encoding.pkg=sun.io, file.separator=\, java.specification.name=Java Platform API Specification, hibernate.format_sql=true, java.class.version=51.0, user.country=US, java.home=C:\Program Files\Java\jre7, java.vm.info=mixed mode, os.version=6.1, hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, hibernate.query.jpaql_strict_compliance=true, path.separator=;, java.vm.version=23.0-b21, javax.persistence.jdbc.url=jdbc:mysql://localhost:3306/livraria, user.variant=, java.awt.printerjob=sun.awt.windows.WPrinterJob, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, user.script=, user.home=C:\Users\jrosendo, java.specification.vendor=Oracle Corporation, java.library.path=C:\Program Files\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Java\jdk1.7.0_04\bin;C:\Program Files (x86)\TortoiseSVN\bin;., java.vendor.url=http://java.oracle.com/, java.vm.vendor=Oracle Corporation, hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect, java.runtime.name=Java(TM) SE Runtime Environment, sun.java.command=com.livraria.entidades.GeraTabelas, java.class.path=C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\bin;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\antlr-2.7.7.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\commons-collections-3.1.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\dom4j-2.0.0-ALPHA-2.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\hibernate-entitymanager-3.4.0.GA.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\hibernate-jpa-2.0-api-1.0.0.Final.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\hibernate3.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\javassist-3.9.0.GA.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\jboss-logging-3.1.0.GA.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\jboss-transaction-api_1.1_spec-1.0.0.Final.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\jta-1.1.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\log4j-1.2.16.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\mysql-connector-java-5.1.20-bin.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\cglib-2.2.2.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\logback-access-1.0.3.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\logback-classic-1.0.3.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\logback-core-1.0.3.jar;C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA\lib\slf4j-api-1.6.0.jar, hibernate.bytecode.use_reflection_optimizer=false, java.vm.specification.name=Java Virtual Machine Specification, java.vm.specification.version=1.7, sun.cpu.endian=little, javax.persistence.jdbc.driver=com.mysql.jdbc.Driver, sun.os.patch.level=Service Pack 1, java.io.tmpdir=C:\Users\jrosendo\AppData\Local\Temp\, java.vendor.url.bug=http://bugreport.sun.com/bugreport/, os.arch=amd64, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.ext.dirs=C:\Program Files\Java\jre7\lib\ext;C:\Windows\Sun\Java\lib\ext, javax.persistence.jdbc.password=root, user.dir=C:\Users\jrosendo\Documents\Personal\Eclipse\workspace\JPA, line.separator=
, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding=Cp1252, hibernate.use_identifier_rollback=false, java.specification.version=1.7, hibernate.show_sql=true}
11:53:17.522 [main] DEBUG o.h.i.f.DefaultIdentifierGeneratorFactory - Setting dialect [org.hibernate.dialect.MySQLInnoDBDialect]
11:53:17.647 [main] DEBUG o.h.p.entity.AbstractEntityPersister - Static SQL for entity: com.livraria.entidades.Editora
11:53:17.647 [main] DEBUG o.h.p.entity.AbstractEntityPersister -  Version select: select id from editora where id =?
11:53:17.647 [main] DEBUG o.h.p.entity.AbstractEntityPersister -  Snapshot select: select editora_.id, editora_.email as email0_, editora_.nome as nome0_ from editora editora_ where editora_.id=?
11:53:17.647 [main] DEBUG o.h.p.entity.AbstractEntityPersister -  Insert 0: insert into editora (email, nome, id) values (?, ?, ?)
11:53:17.647 [main] DEBUG o.h.p.entity.AbstractEntityPersister -  Update 0: update editora set email=?, nome=? where id=?
11:53:17.647 [main] DEBUG o.h.p.entity.AbstractEntityPersister -  Delete 0: delete from editora where id=?
11:53:17.647 [main] DEBUG o.h.p.entity.AbstractEntityPersister -  Identity insert: insert into editora (email, nome) values (?, ?)
11:53:17.668 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for entity com.livraria.entidades.Editora [NONE]: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=?
11:53:17.668 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for entity com.livraria.entidades.Editora [READ]: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=?
11:53:17.669 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for entity com.livraria.entidades.Editora [UPGRADE]: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=? for update
11:53:17.669 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for entity com.livraria.entidades.Editora [UPGRADE_NOWAIT]: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=? for update
11:53:17.669 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for entity com.livraria.entidades.Editora [FORCE]: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=? for update
11:53:17.669 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for entity com.livraria.entidades.Editora [PESSIMISTIC_READ]: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=? lock in share mode
11:53:17.670 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for entity com.livraria.entidades.Editora [PESSIMISTIC_WRITE]: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=? for update
11:53:17.670 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for entity com.livraria.entidades.Editora [PESSIMISTIC_FORCE_INCREMENT]: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=? for update
11:53:17.678 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for action ACTION_MERGE on entity com.livraria.entidades.Editora: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=?
11:53:17.678 [main] DEBUG o.h.loader.entity.EntityLoader - Static select for action ACTION_REFRESH on entity com.livraria.entidades.Editora: select editora0_.id as id0_0_, editora0_.email as email0_0_, editora0_.nome as nome0_0_ from editora editora0_ where editora0_.id=?
11:53:17.682 [main] DEBUG o.h.impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
11:53:17.683 [main] DEBUG o.h.impl.SessionFactoryObjectFactory - registered: 858580c33793efd2013793efd5f00000 (unnamed)
11:53:17.683 [main] INFO  o.h.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
11:53:17.683 [main] DEBUG o.hibernate.impl.SessionFactoryImpl - instantiated session factory
11:53:17.683 [main] DEBUG o.hibernate.impl.SessionFactoryImpl - Checking 0 named HQL queries
11:53:17.683 [main] DEBUG o.hibernate.impl.SessionFactoryImpl - Checking 0 named SQL queries
11:53:17.729 [main] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: [telefone removido]
11:53:17.748 [main] DEBUG o.h.e.def.AbstractSaveEventListener - delaying identity-insert due to no transaction in progress
11:53:17.750 [main] INFO  o.hibernate.impl.SessionFactoryImpl - closing

Dá pra perceber que agora ele tá dando o insert, mas quando olho a base a tabela não existe.

cosen
cosen

JhowTroMundo:
Boa tarde, galera.

Estou começando a estudar JPA com uma apostila da K19, mas estou tendo problemas logo no primeiro exercício.

Não estou conseguindo gerar uma tabela a partir da Entity.

persistence.xml:

<?xml version="1.0" encoding="UTF-8"?>
<persistence 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"
 	version="1.0">

	<persistence-unit name="livraria" transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<class>com.livraria.entidades.Editora</class>
		<properties>
			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
			<property name="hibernate.hbm2dll.auto" value="create"/>
			<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
			<property name="javax.persistence.jdbc.user" value="root"/>
			<property name="javax.persistence.jdbc.password" value="root"/>
			<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/livraria"/>
			<property name="hibernate.show_sql" value="true"/>  
            <property name="hibernate.format_sql" value="true"/> 
		</properties>
	</persistence-unit>
	
</persistence>

Entity:

package com.livraria.entidades;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;

@Entity(name="editora")
public class Editora {
	@Id
	@GeneratedValue
	private Long id;
	private String nome;
	private String email;
	
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public String getNome() {
		return nome;
	}
	public void setNome(String nome) {
		this.nome = nome;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
}

main:

package com.livraria.entidades;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;


public class GeraTabelas {
	public static void main(String[] args){
		EntityManagerFactory factory = Persistence.createEntityManagerFactory("livraria");
		
		EntityManager manager = factory.createEntityManager();
		
		Editora editora = new Editora();
		editora.setEmail("email");
		editora.setNome("Nome editora");
		
		manager.persist(editora);
		
		factory.close();
		System.out.println("ok");
		
	}
}

log:

0 [main] INFO  org.hibernate.annotations.common.Version - HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
13 [main] INFO  org.hibernate.Version - HHH000412: Hibernate Core {4.1.3.Final}
17 [main] INFO  org.hibernate.cfg.Environment - HHH000206: hibernate.properties not found
19 [main] INFO  org.hibernate.cfg.Environment - HHH000021: Bytecode provider name : javassist
650 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000402: Using Hibernate built-in connection pool (not for production use!)
659 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000115: Hibernate connection pool size: 20
660 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000006: Autocommit mode: true
660 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000401: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/livraria]
660 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000046: Connection properties: {user=root, password=****, autocommit=true, release_mode=auto}
975 [main] INFO  org.hibernate.dialect.Dialect - HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
1014 [main] INFO  org.hibernate.engine.transaction.internal.TransactionFactoryInitiator - HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
1028 [main] INFO  org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
Mai 25, 2012 12:22:46 PM org.hibernate.validator.util.Version <clinit>
INFO: Hibernate Validator 4.1.0.Final
Mai 25, 2012 12:22:46 PM org.hibernate.validator.engine.resolver.DefaultTraversableResolver detectJPA
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
Mai 25, 2012 12:22:46 PM org.hibernate.validator.engine.resolver.DefaultTraversableResolver detectJPA
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
1699 [main] INFO  org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl - HHH000030: Cleaning up connection pool [jdbc:mysql://localhost:3306/livraria]

Ja tentei varias soluções apontadas em alguns tópicos mas nenhuma funcionou.

alguem consegue visualizar o problema?

Obrigado!

Eae JhowTroMundo!

Cara, no seu persistence.xml, você escreveu “hibernate.hbm2dll.auto”.

Esse é um erro comum, o correto é “hibernate.hbm2ddl.auto”.

Acredito que o resto está correto.

Vou acrescentar um comentário na próxima versão da apostila da k19 para destacar esse erro.

Eu sempre falo na aula, mas ainda não registrei na apostila.

flw,
Rafael Cosentino

gabriel.coelho
gabriel.coelho

Poutz…Rafael Cosentino, obrigado. Erro banal.

J
jjander.cunha

Faz assim na sua classe

@Entity()

@Table(name=“editora”)

public class Editora {
Criado 25 de maio de 2012
Ultima resposta 13 de mai. de 2014
Respostas 26
Participantes 6

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
Casa do Codigo Casa do Codigo — Livros de tecnologia Livros de programacao, infraestrutura e inovacao
Lumina Lumina: a IA que te traz resultados Prompts prontos por especialistas. Resolva seus problemas de verdade.
Fiap Graduacao em Tecnologia — FIAP Analise e Desenvolvimento de Sistemas, Engenharia de Software e mais