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)

EP41 - 5 Tips on Landing an Entry Level Programming Job

EP41 - 5 Tips on Landing an Entry Level Programming Job

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

16 Syys 201915min

EP40 - The Document Object Model (DOM)

EP40 - The Document Object Model (DOM)

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

4 Syys 201813min

EP39 - Arrays in JavaScript

EP39 - Arrays in JavaScript

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

27 Elo 201842min

EP38 - JavaScript's Built in Objects

EP38 - JavaScript's Built in Objects

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

20 Elo 201823min

EP37 - Null vs Undefined in JavaScript

EP37 - Null vs Undefined in JavaScript

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

14 Elo 201813min

EP36 - Objects in JavaScript

EP36 - Objects in JavaScript

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

6 Elo 201820min

EP35 - JavaScript TypeOf Keyword

EP35 - JavaScript TypeOf Keyword

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

30 Heinä 201814min

EP 34 - Getting and Showing Data from Users

EP 34 - Getting and Showing Data from Users

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

23 Heinä 201813min

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