Fixing Duplicate Data from Hibernate Queries
How to Program with Java Podcast15 Syys 2014

Fixing Duplicate Data from Hibernate Queries

How to Fix Duplicate Data from Hibernate Queries

This problem was the bane of my existence when I first started using Hibernate because I had no idea where the problem was coming from.

If you're executing a query and finding that you have a bunch of duplicate records and haven't a clue why, then you're in the right place.

You see the problem is typically caused by having left joins (or optional joins) in your objects. When you have a base object, like say User and it joins to another table/object in an optional One-to-Many or optional Many-to-Many format, then you may get duplicates.

Consider this scenario… A User objects joins to the LoginHistory object, which keeps track of all the times a particularUser has logged into the system. And let's say our user has logged in many times. You'll have a situation where you have many records in the LoginHistory table.

So what happens when you run a query that joins to the LoginHistory table? Well it will return as many rows as there are entries for that User in the LoginHistory table.

So because of this, Hibernate doesn't massage the data for you, it just returns exactly what it got from the database. The ball is in your court to tell Hibernate what to do with records it has retrieved.

There are two solutions to this problem:

  1. Declare your joining object as a Set
  2. Make use of Distinct Root Entity Results Transformer

Click Here to Keep Reading

Jaksot(112)

EP33 - Importing JavaScript into HTML

EP33 - Importing JavaScript into HTML

Show notes for this episode are available via http://coderscampus.com/33 Don't forget to check out our current "deal" for coders campus available via http://coderscampus.com/deal

16 Heinä 201817min

EP32 - Debugging in JavaScript

EP32 - Debugging in JavaScript

Show notes for this episode are available via http://coderscampus.com/32 Don't forget to check out our current "deal" for coders campus available via http://coderscampus.com/deal

9 Heinä 201824min

EP31 - Functions in JavaScript

EP31 - Functions in JavaScript

Show notes for this episode are available via http://coderscampus.com/31 Don't forget to check out our current "deal" for coders campus available via http://coderscampus.com/deal

3 Heinä 201828min

EP30 - Landing the interview, a coder's guide to applying for jobs

EP30 - Landing the interview, a coder's guide to applying for jobs

Show notes are available via http://coderscampus.com/30 If you're interested in grabbing the new "Java Interview Prep Course" you can get a significant discount by joining the "pre-sale" version of th...

30 Syys 201731min

EP29 - While Loops in JavaScript

EP29 - While Loops in JavaScript

Show notes for this episode are available via http://coderscampus.com/29 Don't forget to check out our current "deal" for coders campus available via http://coderscampus.com/deal

1 Syys 201718min

EP28 - For Loops in JavaScript

EP28 - For Loops in JavaScript

Show notes for this episode can be found here: http://coderscampus.com/28 If you're interested in supporting the show, please leave a rating and review via http://coderscampus.com/itunes And if yo...

25 Elo 201721min

EP27 - Jason Kiernan - From Pharmacist to Programming Job Offer in 2 Years

EP27 - Jason Kiernan - From Pharmacist to Programming Job Offer in 2 Years

Show notes are available via http://coderscampus.com/27

11 Elo 201746min

EP26 - IF Statements in JavaScript

EP26 - IF Statements in JavaScript

Show notes for this episode can be found via http://coderscampus.com/26 Also don't forget to check out our lifetime membership to Coders Campus and get access to 130+ hours of video tutorial content...

4 Elo 201719min

Suosittua kategoriassa Liike-elämä ja talous

sijotuskasti
mimmit-sijoittaa
rss-rahapodi
herrasmieshakkerit
ostan-asuntoja-podcast
rss-sisalto-kuntoon
psykopodiaa-podcast
rss-rahamania
inderespodi
rss-startup-ministerio
taloudellinen-mielenrauha
sijoituspodi
lakicast
rss-h-asselmoilanen
rss-lahtijat
rss-uppoava-vn-laiva
rss-myynnilla-on-asiaa-kert-kenner
sijoitusovi-podcast
bakkari-tarinoita-tapahtumien-takahuoneista
rss-seuraava-potilas