ObjectNotFoundException: No row with the given identifier exists Hibernate

Question

I have the next query :

String queryString = "from Visit vis "
                    + "LEFT OUTER JOIN FETCH vis.pdv vis_pdv ";
return query.list();

After that, I get the next error when I try to access to some pdv:

nested exception is org.hibernate.ObjectNotFoundException: No row with the given identifier exists

The point is I have some corrupt data, so "Visit" has sometimes an id in "pdv" but it doesn't exist that pdv in the table "PDV". I would like to handle this in the query, so it doesn't return corrupt data. Is there any way?

Thanks

Community · Accepted Answer · 2017-05-23 12:06:30Z

1

There's a similar issue here: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: Single table query

Basically the answer is: you need to have a consistent database before Hibernate can work with the data.

I understood that you have a Visit.pvd column that is a foreign key into the PVD table but contains data that isn't reflected in PVD. That's your integrity violation. What you can do is bypassing Hibernate and collect any Visit.ids that are identifying entities that are invalid:

session.createSQLQuery("SELECT id FROM Visit "
        + "WHERE pvd NOT IN (SELECT p.id FROM pvd)").list();

This gets you a List<Object[]> that you can iterate to get the offending entities. Use that to UPDATE them to not contain invalid references (or just use a plain UPDATE with the WHERE clause I gave).

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Nov 11, 2014 at 11:02

mabi

5,3042 gold badges45 silver badges82 bronze badges

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

Comments

mady · Accepted Answer · 2014-11-11 10:22:11Z

0

In hibernate whene you use join in HQL it returns List so please cast your return satement as return

List<Object[]> query.list();

and retrun type as

List<Object[]>

and for your question try like this

select vis from Visit vis, Pdv pdv where vis.id=pdv.vis.id

this query will return

List<Visit>

edited Nov 11, 2014 at 10:22

answered Nov 11, 2014 at 10:14

mady

1191 gold badge3 silver badges12 bronze badges

2 Comments

Juanjo Over a year ago

Thanks. I don't have in Pdv a reference to Visit, just a reference in Visit to Pdv

mady Over a year ago

Sorry am not getting, you mean Visit is child table of Pdv? key of Pdv is in Visit or just reference without foreign key constraint

linkin · Accepted Answer · 2015-02-21 17:45:02Z

0

String queryString = "from Visit vis " + "LEFT OUTER JOIN FETCH vis.pdv "; return query.list();

you dont need List<Object[]> as your returning List<Visit>

List<Object[]>

is needed when you are returning multiple object from the query.

eg select v.pid,v.pname,v.pvisit from Visit v

answered Feb 21, 2015 at 17:45

linkin

311 silver badge7 bronze badges

Collectives™ on Stack Overflow

ObjectNotFoundException: No row with the given identifier exists Hibernate

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related