Erro na persistencia com hibernate

junokim76 · Agosto 23, 2018, 12:55pm

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 server’s 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 isn’t 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 !

Mike · Agosto 23, 2018, 12:59pm

Ola,

Posta o seu arquivo hibernate.cfg.xml

junokim76 · Agosto 23, 2018, 1:17pm

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 · Agosto 23, 2018, 1:31pm

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 · Agosto 23, 2018, 1:47pm

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 server’s 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 isn’t 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 · Agosto 23, 2018, 1:55pm

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 · Agosto 23, 2018, 2:11pm

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 · Agosto 23, 2018, 2:13pm

Ok

Ve isso

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

junokim76 · Agosto 23, 2018, 2:15pm

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]

Erro na persistencia com hibernate

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI