Erro na persistencia com hibernate

8 respostas
hibernate
junokim76

Olá pessoal, estou fazendo uns exercícios para programação Java Web no canal do Delfino no youtube, sei que faz alguns anos, mas gostei muito da didática dele e estou seguindo a programação web2 e fazendo os exercicios da aula 68 (https://www.youtube.com/watch?v=3aPuNR0UNHg&t=387s) não estou conseguindo criar o banco através do GeraTabelas.java

package br.com.drogaria.main;

import br.com.drogaria.util.HibernateUtil;

public class GeraTabela {

public static void main(String[] args) {
	HibernateUtil.getSessionFactory();
	HibernateUtil.getSessionFactory().close();

}

}

e ao executar está dando esse erro:

ago 22, 2018 12:58:23 PM org.hibernate.Version logVersion

INFO: HHH000412: Hibernate Core {5.3.5.Final}

ago 22, 2018 12:58:23 PM org.hibernate.cfg.Environment 

INFO: HHH000206: hibernate.properties not found

ago 22, 2018 12:58:24 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager 

INFO: HCANN000001: Hibernate Commons Annotations {5.0.4.Final}

ago 22, 2018 12:58:24 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

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

ago 22, 2018 12:58:24 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/db_drogaria]

ago 22, 2018 12:58:24 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001001: Connection properties: {user=root, password=****}

ago 22, 2018 12:58:24 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001003: Autocommit mode: false

ago 22, 2018 12:58:24 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections 

INFO: HHH000115: Hibernate connection pool size: 1 (min=1)

Wed Aug 22 12:58:25 BRT 2018 WARN: Establishing SSL connection without servers identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isnt set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to false. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

ago 22, 2018 12:58:25 PM org.hibernate.dialect.Dialect 

INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect

ago 22, 2018 12:58:26 PM org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection

INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@5d5f10b2] for (non-JTA) DDL execution was not in auto-commit mode; the Connection local transaction will be committed and the Connection will be set into auto-commit mode.

ago 22, 2018 12:58:26 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop

INFO: HHH10001008: Cleaning up connection pool [jdbc:mysql://localhost:3306/db_drogaria]

Agradeço desde já a ajuda de todos !

8 Respostas

Mike

Ola,

Posta o seu arquivo hibernate.cfg.xml

junokim76

Segue o código:

<?xml version="1.0" encoding="UTF-8"?>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
	<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/db_drogaria</property>
	<property name="hibernate.connection.username">root</property>
	<property name="hibernate.connection.password">q1w2e3r4</property>
	<property name="hibernate.connection.pool_size">1</property>
	<property name="hibernate.current_session_context_class">thread</property>
	<property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
	<property name="hibernate.show_sql">true</property>
	<property name="hbm2ddl.auto">update</property>
	<property name="cache.provider_class">org.hibernate.cache.internal.NoCacheProvider</property>
	<mapping class="br.com.drogaria.domain.Fabricante" />
</session-factory>
Mike

Essas mensagens do console são normais, são apenas INFO

Não deveria ter o prefixo ‘hibernate’ antes?

<property name="hibernate.hbm2ddl.auto">update</property>
junokim76

Então … o eclipse não acusou erro, mas de qualquer forma alterei e continuou o erro:

ago 23, 2018 10:43:53 AM org.hibernate.Version logVersion

INFO: HHH000412: Hibernate Core {5.3.5.Final}

ago 23, 2018 10:43:53 AM org.hibernate.cfg.Environment 

INFO: HHH000206: hibernate.properties not found

ago 23, 2018 10:43:53 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager 

INFO: HCANN000001: Hibernate Commons Annotations {5.0.4.Final}

ago 23, 2018 10:43:54 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

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

ago 23, 2018 10:43:54 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/db_drogaria]

ago 23, 2018 10:43:54 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001001: Connection properties: {user=root, password=****}

ago 23, 2018 10:43:54 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001003: Autocommit mode: false

ago 23, 2018 10:43:54 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections 

INFO: HHH000115: Hibernate connection pool size: 1 (min=1)

Thu Aug 23 10:43:54 BRT 2018 WARN: Establishing SSL connection without servers identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isnt set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to false. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

ago 23, 2018 10:43:59 AM org.hibernate.dialect.Dialect 

INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect

ago 23, 2018 10:43:59 AM org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection

INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@5d5f10b2] for (non-JTA) DDL execution was not in auto-commit mode; the Connection local transaction will be committed and the Connection will be set into auto-commit mode.

ago 23, 2018 10:43:59 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop

INFO: HHH10001008: Cleaning up connection pool [jdbc:mysql://localhost:3306/db_drogaria]
Mike

Pra tirar essa mensagem, tenta alterar a sua propriedade assim:

<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/db_drogaria?useSSL=false</property>
junokim76

Bom a criação da tabela não foi feita, mas limpou bem o log:

ago 23, 2018 11:09:21 AM org.hibernate.Version logVersion

INFO: HHH000412: Hibernate Core {5.3.5.Final}

ago 23, 2018 11:09:21 AM org.hibernate.cfg.Environment 

INFO: HHH000206: hibernate.properties not found

ago 23, 2018 11:09:22 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager 

INFO: HCANN000001: Hibernate Commons Annotations {5.0.4.Final}

ago 23, 2018 11:09:22 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

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

ago 23, 2018 11:09:22 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/db_drogaria?useSSL=false]

ago 23, 2018 11:09:22 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001001: Connection properties: {user=root, password=****}

ago 23, 2018 11:09:22 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001003: Autocommit mode: false

ago 23, 2018 11:09:22 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections 

INFO: HHH000115: Hibernate connection pool size: 1 (min=1)

ago 23, 2018 11:09:23 AM org.hibernate.dialect.Dialect 

INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect

ago 23, 2018 11:09:24 AM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources

INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@4196c360

ago 23, 2018 11:09:24 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop

INFO: HHH10001008: Cleaning up connection pool [jdbc:mysql://localhost:3306/db_drogaria?useSSL=false]
Mike

Ok

Ve isso

<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
junokim76

Troquei, segue o log:

ago 23, 2018 11:13:04 AM org.hibernate.Version logVersion

INFO: HHH000412: Hibernate Core {5.3.5.Final}

ago 23, 2018 11:13:04 AM org.hibernate.cfg.Environment 

INFO: HHH000206: hibernate.properties not found

ago 23, 2018 11:13:05 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager 

INFO: HCANN000001: Hibernate Commons Annotations {5.0.4.Final}

ago 23, 2018 11:13:05 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

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

ago 23, 2018 11:13:05 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/db_drogaria?useSSL=false]

ago 23, 2018 11:13:05 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001001: Connection properties: {user=root, password=****}

ago 23, 2018 11:13:05 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001003: Autocommit mode: false

ago 23, 2018 11:13:05 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections 

INFO: HHH000115: Hibernate connection pool size: 1 (min=1)

ago 23, 2018 11:13:05 AM org.hibernate.dialect.Dialect 

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

ago 23, 2018 11:13:06 AM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources

INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@41005828

ago 23, 2018 11:13:06 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop

INFO: HHH10001008: Cleaning up connection pool [jdbc:mysql://localhost:3306/db_drogaria?useSSL=false]
Criado 23 de agosto de 2018
Ultima resposta 23 de ago. de 2018
Respostas 8
Participantes 2