I apologize for having posted my question in the thread of a similar one. So I'm posting as a new topic, okay?
I'm using the H2 and JPA database to create my tables.
Testing my application, I can create the tables, insert records, list the inserted records, but I can not see it in the Console through the browser using the address localhost: 8082, which opens the window for connection to the Database .
Below is my persistence.xml, log4j.properties, the class that generates the log4j tables and output in Console:
persistence.xml
<?xml version="1.0" encoding="UTF-8" ?>
<persistence-unit name="h2_pu" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<properties>
<property name="connection.driver_class" value="org.h2.Driver" />
<property name="hibernate.connection.url" value="jdbc:h2:C:/Users/Augusto/workspace/h2database/db/bd_test" />
<property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" />
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.format_sql" value="true" />
<property name="use_sql_comments" value="true" />
</properties>
</persistence-unit>
</persistence>
My log4j:
log4j.rootCategory=INFO, CONSOLE
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%r [%t] %-5p %c - %m%n
log4j.logger.org.hibernate=ERROR
log4j.logger.org.hibernate.type=TRACE
log4j.logger.org.hibernate.tool.hbm2ddl=TRACE
My class for generating the tables:
package testes;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
public class GerarTabelas {
public static void main(String[] args) {
try {
EntityManagerFactory factory = Persistence.createEntityManagerFactory("h2_pu");
factory.close();
System.out.println("Tabelas geradas com sucesso !!!");
} catch (Exception e) {
System.out.println("Erro ao gerar as tabelas !!! Verificar as entidades !!!");
e.printStackTrace();
}
}
}
The result of the query via Java code is correct, as below:
1 - Andrea Lopes -- Obs 01
2 - Beatriz Sampaio -- Nenhuma obs
3 - Carlos Carvalho -- Obs 03
4 - Daniel Carneiro -- Obs 04
5 - Edson Rabelo -- Obs 05
6 - Fernanda Monteiro -- Obs 06
7 - Guilherme Fontes -- Obs 07
8 - Helena Gomes -- Obs 08
9 - Ivan Reis -- Obs 09
10 - Janaina Ferreira -- Décima obs
In the browser, when I connect to the database, I try to access the Client table for checks, queries, and so on. manually, using the command:
SELECT * FROM PUBLIC.BD_TEST.CLIENTE;
and getting error as below:
SELECT * FROM PUBLIC.BD_TEST.CLIENTE;
Table "BD_TEST" not found; SQL statement:
SELECT * FROM PUBLIC.BD_TEST.CLIENTE [42102-180] 42S02/42102 (Help)
What is the correct way to run this query on H2?
Thanks in advance for any help,
regards
Augusto Cesar