Discussoes de Programacao e Tecnologia

[RESOLVIDO] Database desconhecida MySQL

4 respostas
javamysql
L
LeonardoMP

Olá pessoal

Sou inicante em java e estou tentando criar uma conexão com mysql, usando o hibernate porém quando executo o teste aparece no console que minha database é desconhecida, e sim, já verifiquei se o nome está correto

Erro

nov 17, 2017 3:05:01 AM org.hibernate.annotations.common.Version 

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

nov 17, 2017 3:05:01 AM org.hibernate.Version logVersion

INFO: HHH000412: Hibernate Core {4.2.3.Final}

nov 17, 2017 3:05:01 AM org.hibernate.cfg.Environment 

INFO: HHH000206: hibernate.properties not found

nov 17, 2017 3:05:01 AM org.hibernate.cfg.Environment buildBytecodeProvider

INFO: HHH000021: Bytecode provider name : javassist

nov 17, 2017 3:05:01 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

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

nov 17, 2017 3:05:01 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

INFO: HHH000115: Hibernate connection pool size: 20

nov 17, 2017 3:05:01 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

INFO: HHH000006: Autocommit mode: true

nov 17, 2017 3:05:01 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

INFO: HHH000401: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost/pedidovenda]

nov 17, 2017 3:05:01 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

INFO: HHH000046: Connection properties: {user=root, password=****, autocommit=true, release_mode=auto}

nov 17, 2017 3:05:02 AM org.hibernate.engine.jdbc.internal.JdbcServicesImpl configure

WARN: HHH000342: Could not obtain connection to query metadata : Unknown database 'pedidovenda’

nov 17, 2017 3:05:02 AM org.hibernate.dialect.Dialect 

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

nov 17, 2017 3:05:02 AM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation

INFO: HHH000422: Disabling contextual LOB creation as connection was null

nov 17, 2017 3:05:02 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService

INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory

nov 17, 2017 3:05:02 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory 

INFO: HHH000397: Using ASTQueryTranslatorFactory

nov 17, 2017 3:05:02 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

WARN: SQL Error: 1049, SQLState: 42000

nov 17, 2017 3:05:02 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

ERROR: Unknown database 'pedidovenda’

Exception in thread “main” javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Could not open connection

at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)

at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)

at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1397)

at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:62)

at Teste.main(Teste.java:16)

Caused by: org.hibernate.exception.SQLGrammarException: Could not open connection

at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)

at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)

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)

… 1 more

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'pedidovenda’

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

at com.mysql.jdbc.Util.getInstance(Util.java:381)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:718)

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)

at org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:204)

at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)

at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)

… 6 more

persistence.xml

<?xml version="1.0" encoding="UTF-8"?> 

<persistence-unit name="PedidoPU">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    
    <properties>
       <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost/pedidovenda"/>
       <property name="javax.persistence.jdbc.user" value="root"/>
       <property name="javax.persistence.jdbc.password" value="root"/>
       <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
       
       <property name="hibernate.show_sql" value="true"/>
       <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
    </properties>
 </persistence-unit>

a classe de teste:

import javax.persistence.EntityManager;

import javax.persistence.EntityManagerFactory;

import javax.persistence.EntityTransaction;

import javax.persistence.Persistence;

import com.gestao.pedidovenda.model.Cliente;
import com.gestao.pedidovenda.model.TipoPessoa;

public class Teste {

public static void main(String[] args){
	EntityManagerFactory factory = Persistence.createEntityManagerFactory("PedidoPU");
	EntityManager manager = factory.createEntityManager();
	
	EntityTransaction trx = manager.getTransaction();
	trx.begin();
	
	Cliente cliente = new Cliente();
	cliente.setNome("Joao das Neves");
	cliente.setEmail("[email removido]");
	cliente.setDocumentoReceitaFederal("[CPF removido]");
	cliente.setTipo(TipoPessoa.FISICA);
	
	manager.persist(cliente);
	
	trx.commit();
}

}

Sei que é um erro simples, mas ta dando bastante dor de cabeça
Se alguém puder ajudar, agradeço desde já!

Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

4 Respostas

M
McGMS

Voce criou a database pedidovenda?

L
LeonardoMP

Criei sim!

M
McGMS

Quais são os Jars que você está usando no seu projeto?. Pode estar faltando algum.

L
LeonardoMP

jars

as dependencias:

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.gestao</groupId>
<artifactId>PedidoVenda</artifactId>
<version>1.0.0-SNAPSHOT</version>
<packaging>war</packaging>

<properties>
	<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>

<dependencies>
	<!-- Núcleo do Hibernate -->
	<dependency>
		<groupId>org.hibernate</groupId>
		<artifactId>hibernate-core</artifactId>
		<version>4.2.3.Final</version>
		<scope>compile</scope>
	</dependency>

	<!-- Implementação do EntityManager da JPA -->
	<dependency>
		<groupId>org.hibernate</groupId>
		<artifactId>hibernate-entitymanager</artifactId>
		<version>4.2.3.Final</version>
		<scope>compile</scope>
	</dependency>

	<!-- Driver JDBC do MySQL -->
	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>5.1.6</version>
		<scope>compile</scope>
	</dependency>

	<!-- PrimeFaces (biblioteca de componentes) -->
	<dependency>
		<groupId>org.primefaces</groupId>
		<artifactId>primefaces</artifactId>
		<version>6.0</version>
		<scope>compile</scope>
	</dependency>

	<!-- Mojarra (implementação do JSF) -->
	<dependency>
		<groupId>org.glassfish</groupId>
		<artifactId>javax.faces</artifactId>
		<version>2.1.21</version>
		<scope>compile</scope>
	</dependency>

    <dependency>
        <groupId>org.jboss.weld.servlet</groupId>
        <artifactId>weld-servlet</artifactId>
        <version>1.1.10.Final</version>
        <scope>compile</scope>
    </dependency>


</dependencies>

<build>
	<finalName>PedidoVenda</finalName>
	<plugins>
		<plugin>
			<artifactId>maven-compiler-plugin</artifactId>
			<version>3.0</version>
			<configuration>
				<source>1.7</source>
				<target>1.7</target>
			</configuration>
		</plugin>
	</plugins>
</build>

<repositories>
	<repository>
		<id>prime-repo</id>
		<name>PrimeFaces Maven Repository</name>
		<url>http://repository.primefaces.org</url>
		<layout>default</layout>
	</repository>
</repositories>
Criado 17 de novembro de 2017
Ultima resposta 17 de nov. de 2017
Respostas 4
Participantes 2

Topicos relacionados

Email não é enviado quando está rodando no servidor OPENSHIFT 6 respostas Erro ao popular combobox (RESOLVIDO) 3 respostas Datepicker com Java Script não funciona Resolvido 1 respostas Iniciar mysql 11 respostas Enviar dados pro BD - SERVLET 1 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 SQL: Uma abordagem para bancos de dados Oracle Por Eduardo Goncalves — Casa do Codigo