Hibernate - Query returns null for all fields in entity while the same query returns perfectly from db

Question

Hibernate - Query returns null for all fields in Entity

Long fooId = 39;    
Query query = getCurrentSession().createQuery("from FooEntity where deleted IS FALSE AND id=:fooId" );
query.setParameter( "fooId", fooId );
FooEntity fooEntity = ( FooEntity ) query.uniqueResult();

Inspecting the FooEntity the following result is shown

(id=null, name=null, deleted=null)

While the same query returns perfect result from db

select * from foo where deleted IS FALSE AND id=39
(id, name, deleted) => (39, 'Bar', false)

It has to be noted that this occurs in random cases only. Most of the time hibernate returns perfect result.

Arumoy Chakraborty · Accepted Answer · 2018-06-07 06:33:19Z

3

Please try to log or sysout the value in the next line.

For me and the OP the issue was same, just Java Debugger was not showing the value. The value was there all the time.

answered Jun 7, 2018 at 6:33

Arumoy Chakraborty

772 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dmytro Chasovskyi Over a year ago

Is there any way to resolve this? Is it a bug into debugger or Hibernate-related?

Arumoy Chakraborty Over a year ago

Not that I know of. This issue isn't very consistent. I have debugged the same code many times over since the issue, and it never occurred again. I'd suggest you kill the IDE and the associated JVM threads and try again, since that's the only thing changed between multiple debug sessions for me. Also please comment back if you find this issue consistent across JVM processes somehow.

gabor.harsanyi · Accepted Answer · 2015-02-12 12:40:31Z

2

might be a concurrent problem (when we've had same behavior we noticed a shared session between threads)

Shared entity or session between threads or shared entity between sessions could cause this kind of issue

answered Feb 12, 2015 at 12:40

gabor.harsanyi

5992 silver badges14 bronze badges

2 Comments

Vishnu G S Over a year ago

@Cache( usage = CacheConcurrencyStrategy.READ_WRITE ) this annotation on Entity has any effect?

gabor.harsanyi Over a year ago

it means you also use secondary cache, right? what kind of cache? yes, READ_WRITE is the safest but it's only the concurrency strategy, in case of using secondary cache you also have to think about the transactional strategy if it is a distributed cache and the transaction isolation, e.g. you've just created the item and it cannot be seen at that point from another, etc etc ... There are lot of places where things can go wrong, you specified just a piece of information

Collectives™ on Stack Overflow

Hibernate - Query returns null for all fields in entity while the same query returns perfectly from db

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related