Não consigo acessar pelo terminal do MySQL nenhuma base de dados criada através do Workbench. É exibida a seguinte mensagem "ERROR 1049 <42000>: Unknown database 'lojavirtualDB' ". Alguém sabe o que devo fazer?

Resolvido! http://www.arquivodecodigos.net/dicas/mysql-criando-uma-base-de-dados-mysql-usando-o-mysqladmin-1569.html

[MySQL] "Unknown database"

A base de dados lojavirtualDB está criada.

Estou tentando configurar pela primeira vez o Hibernate. Abaixo persistence.xml

<?xml version="1.0" encoding="UTF-8"?> org.hibernate.ejb.HibernatePersistence entities.Produto

A classe que grava no banco.

package testes;

import javax.persistence.EntityManager;

import javax.persistence.EntityManagerFactory;

import javax.persistence.Persistence;

import entities.Produto;

public class TestaInsereProduto {

public static void main(String[] args) {
	
	EntityManagerFactory factory = Persistence.createEntityManagerFactory("lojavirtualDB");
	EntityManager em = factory.createEntityManager();
	
	Produto p = new Produto();
	p.setNome("camiseta");
	p.setPreco(12.23);
	
	em.getTransaction().begin();
	
	em.persist(p);
	
	em.getTransaction().commit();
}

}

E a exceção lançada no Console.

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'lojavirtualdb’

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

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

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

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

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

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

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

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

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1717)

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

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2389)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2422)

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

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

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

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

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

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

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

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

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

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

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.(SessionFactoryImpl.java:495)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1741)

at org.hibernate.ejb.EntityManagerFactoryImpl.(EntityManagerFactoryImpl.java:93)

at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905)

at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:890)

at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)

at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)

at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47)

at testes.TestaInsereProduto.main(TestaInsereProduto.java:18)

2 Respostas

Topicos relacionados