Discussoes de Programacao e Tecnologia

Problema com conexão com o banco de dados MYSQL

6 respostas Resolvido
jsfjpatomcatjavahibernate
A
alexmcsilva

Boa noite

Estou seguindo um curso de Java da algaworks e estou tendo dificuldades com a conexão com o banco de dados mysql. Estou usando o Tomcat como servidor de aplicação. Se alguém puder me ajudar ficarei muito grato! Segue o que foi gerado pelo console:

nov 15, 2017 11:12:10 PM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
nov 15, 2017 11:12:10 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.2.3.Final}
nov 15, 2017 11:12:10 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
nov 15, 2017 11:12:10 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
nov 15, 2017 11:12:11 PM org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator initiateService
WARN: HHH000181: No appropriate connection provider encountered, assuming application will be supplying connections
Exception in thread "main" javax.persistence.PersistenceException: [PersistenceUnit: SiscadiacPU] Unable to build EntityManagerFactory
	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:924)
	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:899)
	at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:59)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47)
	at sistemawebiac.com.controle.Main.main(Main.java:12)
Caused by: org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.MySQL5.7Dialect
	at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.constructDialect(DialectFactoryImpl.java:76)
	at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:64)
	at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:174)
	at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:75)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:159)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131)
	at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1797)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1755)
	at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96)
	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914)
	... 5 more
Caused by: org.hibernate.service.classloading.spi.ClassLoadingException: Unable to load class [org.hibernate.dialect.MySQL5.7Dialect]
	at org.hibernate.service.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:149)
	at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.constructDialect(DialectFactoryImpl.java:73)
	... 14 more
Caused by: java.lang.ClassNotFoundException: Could not load requested class : org.hibernate.dialect.MySQL5.7Dialect
	at org.hibernate.service.classloading.internal.ClassLoaderServiceImpl$AggregatedClassLoader.findClass(ClassLoaderServiceImpl.java:296)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:348)
	at org.hibernate.service.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:146)
	... 15 more
Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

6 Respostas

D
deFreitas 1 like

Olha se voce importou o driver do MYSQL e se importou procura no google outra classe de dialeto porque essa que voce ta usando nao existe

Caused by: java.lang.ClassNotFoundException: Could not load requested class : org.hibernate.dialect.MySQL5.7Dialect
A
alexmcsilva

Boa noite deFreitas

Obrigado pela ajuda, alterei aqui e foi gerado isso pelo console. Você sabe o que pode ser?

nov 18, 2017 9:59:46 PM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
nov 18, 2017 9:59:46 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.2.3.Final}
nov 18, 2017 9:59:46 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
nov 18, 2017 9:59:46 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
nov 18, 2017 9:59:46 PM org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator initiateService
WARN: HHH000181: No appropriate connection provider encountered, assuming application will be supplying connections
nov 18, 2017 9:59:46 PM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
nov 18, 2017 9:59:46 PM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000422: Disabling contextual LOB creation as connection was null
nov 18, 2017 9:59:46 PM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
nov 18, 2017 9:59:46 PM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
nov 18, 2017 9:59:47 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000228: Running hbm2ddl schema update
nov 18, 2017 9:59:47 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000102: Fetching database metadata
nov 18, 2017 9:59:47 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
ERROR: HHH000299: Could not complete schema update
java.lang.UnsupportedOperationException: The application must supply JDBC connections
	at org.hibernate.service.jdbc.connections.internal.UserSuppliedConnectionProviderImpl.getConnection(UserSuppliedConnectionProviderImpl.java:62)
	at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:194)
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:505)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1769)
	at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96)
	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914)
	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:899)
	at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:59)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47)
	at sistemawebiac.com.controle.Main.main(Main.java:12)

Exception in thread "main" java.lang.UnsupportedOperationException: The application must supply JDBC connections
	at org.hibernate.service.jdbc.connections.internal.UserSuppliedConnectionProviderImpl.getConnection(UserSuppliedConnectionProviderImpl.java:62)
	at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)
	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)
	at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1426)
	at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:59)
	at sistemawebiac.com.controle.Main.main(Main.java:16)
D
deFreitas

Aparentemente voce nao está passando a URL de conexao corretamente, da uma verificacada no seu persistence.xml.

deveria ser algo assim

<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mags</property>

Posta seu persistence.xml

A
alexmcsilva

Segue o 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="SiscadiacPU" transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		
		<properties>
		    <property name="javax.persistance.jdbc.url" value="jdbc:mysql://localhost/dbsiscadiac"/>
			<property name="javax.persistance.jdbc.user" value="root" />
			<property name="javax.persistance.jdbc.password" value="E5S6T7I1"/>
			<property name="javax.persistance.jdbc.driver" value="com.mysql.jdbc.Driver"/>
			
			<!--Metodo de atualizacao -->
			<property name="hibernate.hbm2ddl.auto" value = "update"/>
			<property name="hibernate.show_sql"  value = "true"/>
			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>
			<property name="hibernate.format_sql" value="true" />	
		</properties>
	</persistence-unit>
</persistence>
D
Solucao aceita
deFreitas

Acho que eh isso mesmo, ao inves disso

<property name="javax.persistance.jdbc.url" value="jdbc:mysql://localhost/dbsiscadiac"/>
 <property name="javax.persistance.jdbc.user" value="root" />
 <property name="javax.persistance.jdbc.password" value="E5S6T7I1"/>
 <property name="javax.persistance.jdbc.driver" value="com.mysql.jdbc.Driver"/>

Use isso

<property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/dbsiscadiac"/>
<property name="hibernate.connection.username" value="root" />
<property name="hibernate.connection.password" value="E5S6T7I1"/>
<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>

Outra coisa, acredito que sua URL de conexao estava errada

jdbc:mysql://localhost/dbsiscadiac

Aho que precisa passar a porta

jdbc:mysql://localhost:3306/dbsiscadiac
A
alexmcsilva

deFreitas, muito obrigado aparentemente deu certo. Deu uma mensagem diferente aqui, aparentemente é de SQL daí eu vou quebrar a cabeça para resolver aqui.

Obs: Na minha guia problems esta aparecendo essa mensagem, eu já pesquisei e não conseguir achar o motivo de estar aparecendo isso. Você sabe o que é isso?
A mensagem é essa:

Description	Resource	Path	Location	Type
No connection specified for project. No database-specific validation will be performed.	SistemaWebIAC		 	JPA Problem
Criado 16 de novembro de 2017
Ultima resposta 19 de nov. de 2017
Respostas 6
Participantes 2

Topicos relacionados

Configuração do banco MySQL x JPA x Hibernate Resolvido 4 respostas Item Pedido - JPA Hibernate - @OneToMany - problema ao salvar itens 1 respostas Conselhos de Java para Concursos Públicos 4 respostas Hibernate + JSF Erro ao persistir objeto 1 respostas HTTP Status 500 - Não é possível criar instância para·a classe: br.com.lira.bean.EmpresaBean 7 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!
Casa do Codigo Back-end Java: Microsservicos, Spring Boot e Kubernetes Por Eduardo Felipe Zambom Santana — Casa do Codigo