Issue: retrieving data with JBOSS

Hibernate ORM
2

Try to activate the following log appenders:

log4j.logger.org.hibernate.SQL=debug

log4j.logger.org.hibernate.type.descriptor.sql.BasicBinder=trace
log4j.logger.org.hibernate.type.descriptor.sql.BasicExtractor=trace

Then, in the log you can see what data is fetched:

17:08:41,511 DEBUG SQL:92 - 
    select
        stays0_.person as person8_4_0_,
        stays0_.id as id1_4_0_,
        stays0_.id as id1_4_1_,
        stays0_.authoriser as authoris2_4_1_,
        stays0_.comments as comments3_4_1_,
        stays0_.endDate as endDate4_4_1_,
        stays0_.oldperson as oldperso7_4_1_,
        stays0_.person as person8_4_1_,
        stays0_.startDate as startDat5_4_1_,
        stays0_.veryoldperson as veryoldp9_4_1_,
        stays0_.vessel as vessel6_4_1_,
        person1_.id as id1_2_2_,
        person1_.companyName as companyN2_2_2_,
        person1_.firstName as firstNam3_2_2_,
        person1_.lastName as lastName4_2_2_ 
    from
        Stay stays0_ 
    left outer join
        Person person1_ 
            on stays0_.veryoldperson=person1_.id 
    where
        stays0_.person=?
17:08:41,511 TRACE BasicBinder:65 - binding parameter [1] as [INTEGER] - [1]
17:08:41,514 TRACE BasicExtractor:61 - extracted value ([id1_4_1_] : [INTEGER]) - [2]
17:08:41,514 TRACE BasicExtractor:51 - extracted value ([id1_2_2_] : [INTEGER]) - [null]
17:08:41,515 TRACE BasicExtractor:61 - extracted value ([authoris2_4_1_] : [VARCHAR]) - [Blah]
17:08:41,515 TRACE BasicExtractor:61 - extracted value ([comments3_4_1_] : [VARCHAR]) - [Blah]
17:08:41,516 TRACE BasicExtractor:61 - extracted value ([endDate4_4_1_] : [TIMESTAMP]) - [2018-03-21 17:08:41.183]
17:08:41,517 TRACE BasicExtractor:51 - extracted value ([oldperso7_4_1_] : [INTEGER]) - [null]
17:08:41,517 TRACE BasicExtractor:61 - extracted value ([person8_4_1_] : [INTEGER]) - [1]
17:08:41,517 TRACE BasicExtractor:61 - extracted value ([startDat5_4_1_] : [TIMESTAMP]) - [2018-03-21 17:08:41.183]
17:08:41,518 TRACE BasicExtractor:51 - extracted value ([veryoldp9_4_1_] : [INTEGER]) - [null]
17:08:41,518 TRACE BasicExtractor:61 - extracted value ([vessel6_4_1_] : [VARCHAR]) - [A380]
17:08:41,519 TRACE BasicExtractor:61 - extracted value ([person8_4_0_] : [INTEGER]) - [1]
17:08:41,519 TRACE BasicExtractor:61 - extracted value ([id1_4_0_] : [INTEGER]) - [2]

If yiou don’t see that, it means you are connecting to a database schema that has no data.