Fixing Duplicate Data from Hibernate Queries
How to Program with Java Podcast15 Sep 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

Episoder(112)

EP25 - JavaScript Data Types

EP25 - JavaScript Data Types

Checkout the show notes of today's episode via http://coderscampus.com/25 Also, I've started a brand new "lifetime membership" deal for Coders Campus, you can check out the details of this new offer v...

28 Jul 201727min

EP23 - JavaScript Variables

EP23 - JavaScript Variables

Show notes for this episode are available via http://coderscampus.com/23 Also, don't forget about the sweet deal I have over at http://coderscampus.com/deal - you help support the show when you join o...

14 Jul 201715min

EP22 - What's New in Spring 5 with John Thompson

EP22 - What's New in Spring 5 with John Thompson

You can sign up for early access to John's new course (plus a surprise bonus from me) via http://coderscampus.com/spring5

7 Jul 201739min

Coders Campus EP21 - Dynamic Typing in JavaScript

Coders Campus EP21 - Dynamic Typing in JavaScript

Don't forget to check out this sweet deal on a Coders Campus via http://coderscampus.com/deal You'll get access to over 128 hours of video tutorial content that will teach you how to become a full-st...

29 Jun 201721min

What is JavaScript?

What is JavaScript?

Don't forget to check out the special deal that we're putting on for our podcast listeners via http://coderscampus.com/deal

22 Jun 201722min

EP68 - Subscribe to my new show called the "Coders Campus Podcast"

EP68 - Subscribe to my new show called the "Coders Campus Podcast"

You can subscribe to the new show via this link: http://coderscampus.com/itunes There will be no more episodes of the How to Program with Java podcast (this podcast), all new episodes will be shared...

1 Jul 20162min

Episode 66 - Summer is here and something new is in the air

Episode 66 - Summer is here and something new is in the air

I'm happy to announce that dropping on July 1st, 2016 - a brand new podcast will be hitting the digital shelves! Although the How to Program with Java podcast will be coming to an end, I'll be launchi...

28 Jun 20165min

EP65: HTML Design & Layout

EP65: HTML Design & Layout

Okay so you know how to add some styles and CSS to your webpage, that's a great start, but what about deciding where all your text should go? What if you wanted to setup your website so that you have...

1 Des 201447min

Populært innen Business og økonomi

stopp-verden
lydartikler-fra-aftenposten
dine-penger-pengeradet
e24-podden
rss-penger-polser-og-politikk
rss-borsmorgen-okonominyhetene
pengesnakk
utbytte
livet-pa-veien-med-jan-erik-larssen
tid-er-penger-en-podcast-med-peter-warren
finansredaksjonen
pengepodden-2
morgenkaffen-med-finansavisen
rss-sunn-okonomi
stormkast-med-valebrokk-stordalen
rss-markedspuls-2
okonomiamatorene
lederpodden
liberal-halvtime
rss-politisk-preik