Query using Hibernate does not bring record

Question

I’m trying to query the HSQLDB database using Hibernate but I’m not succeeding.

When I do:

session.get(Usuario.class, new Integer(1));

The query is made because it shows the query mounted by Hibernate. But it does not bring any record, even if it exists in the database.

Mounted query compares the log ID I need with a question mark (?).

This is the assembled query:

select usuario0_.ID as ID1_0_0_, usuario0_.NOME as NOME2_0_0_,
       usuario0_.EMAIL as EMAIL3_0_0_, usuario0_.SENHA as SENHA4_0_0_
from USUARIOS usuario0_ where usuario0_.ID=?

Below are some images that may be needed:

FILE LOCATION

HIBERNATE CONFIGURATION

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
    <session-factory>
        <!-- Database connection settings -->
        <property name="connection.driver">org.hsqldb.jdbcDriver</property>
        <property name="connection.url">jdbc:hsqldb:EcoChat</property>
        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.HSQLDialect</property>

        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

        <!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">update</property>

        <!-- Mapping files -->
        <mapping resource="ecochat/dao/modelos/usuario/mapeamento/usuario.hbm.xml" />
    </session-factory>
</hibernate-configuration>

USER MAPPING

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="ecochat.entidades.modelos.Usuario" table="USUARIOS">
        <id name="id" type="int" column="ID">
            <generator class="native" />
        </id>

        <property name="nome">
            <column name="NOME" />
        </property>
        <property name="email">
            <column name="EMAIL" />
        </property>
        <property name="senha">
            <column name="SENHA" />
        </property>
    </class>
</hibernate-mapping>

PLACE OF TROUBLE

public static void main(String[] args) {
        try {
            //UIJanelaServidorCentralChat.getInstance();
            Configuration config = new Configuration();
            config.configure("ecochat\\hibernate\\configuracoes\\hibernate.cfg.xml");
            Logger.getLogger("org.hibernate").setLevel(Level.OFF);

            SessionFactory factory = config.buildSessionFactory();

            Session session = factory.openSession();
            session.getTransaction().begin();
            Usuario usuario = (Usuario) session.get(Usuario.class, new Integer(2));
            System.out.println(usuario.getNome());
        } catch(HibernateException exception){
             exception.printStackTrace();
        } catch (Exception e) {
            System.err.println("Ops! " + e.getMessage() + "\n");
        }
    }

CONSULTATION MOUNTED BY HIBERNATE

select usuario0_.ID as ID1_0_0_, usuario0_.NOME as NOME2_0_0_, usuario0_.EMAIL as EMAIL3_0_0_, usuario0_.SENHA as SENHA4_0_0_ from USUARIOS usuario0_ where usuario0_.ID=?.

BANK ENTRY

I am new to programming and do not know exactly how to use Hibernate and if it is correct what I am doing, if you can please give me some tip how to improve I thank.

Answer 1

The problem was solved as follows:

When I set up the hibernate.config.xml I used in the url line: <property name="connection.url">jdbc:hsqldb:EcoChat</property>that configuration.

But it was creating a banco de dados called EcoChatin raiz of my project. See in the image:

Thus, the database that was being accessed was the one at the root, but what I was inserting records using the hsqldb was another bank, located in another folder, see in the image:

That way, I would consult a bank, but actually I would like to be accessing another.

To solve the problem, I changed the configuration shown above: <property name="connection.url">jdbc:hsqldb:EcoChat</property>

for: <property name="connection.url">jdbc:hsqldb:file:Bibliotecas/hsqldb/data/EcoChat</property>

So I can retrieve the information located in the innermost bank.