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:

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

Click Here to Keep Reading

Kokeile Premiumia

Nauti 14 päivää ilmaiseksi

Tilaa Premium

Jaksot(112)

Unlocking Your First Coding Job: The Realities and Solutions

Episode Summary In this episode, Trevor Page delves into the challenges aspiring software developers face when trying to land their first job. Drawing from his 15 years of programming experience and 1...

23 Elo 202437min

Alex almost quit coding forever while in this Bootcamp

Summary To reach out and connect with Alex, here's her LinkedIn profile: https://www.linkedin.com/in/alex-mamolo-2a1b57222/ In this episode, Trevor interviews Alex, who shares her journey from being a...

4 Touko 202449min

From Struggling University Comp Sci Grad to Employed Coder - Tony Edmonds

To reach out and connect with Tony: https://www.linkedin.com/in/edmonds-tony/ Takeaways - Negotiate your salary and consider the market conditions in your area. - Remote work opportunities are availab...

28 Maalis 20241h 3min

From Backpacking Instructor to Coder in 5 Months - Jeff Podmayer

Summary If you want to connect/reach out to Jeff, here's his LinkedIn profile: https://www.linkedin.com/in/jeffpodmayer/ In this episode, Trevor interviews Jeff, who made a transition from b...

21 Maalis 20241h 18min

From the Fashion Industry to Full-Stack Coder - Kevin Gallaccio

Summary In this episode, Trevor interviews Kevin, who made a career transition from fashion to technology. Kevin shares how his interest in Microsoft Excel and his curiosity about technology led him...

11 Maalis 202454min

The Coding Apocalypse: Is the End of Software Jobs Near?

This thought-provoking video delves deep into a highly controversial topic: Are coding jobs disappearing? As we stand on the brink of unprecedented technological advancements, what does the future hol...

3 Elo 202330min

EP59 - From Stone Mason to Software Developer in 8 Months

In this episode we'll talk to Ethan, who is a recent graduate from the Coders Campus Bootcamp and managed to land a job within two months of starting the search. Ethan and I talk about how, from a you...

31 Touko 202256min

EP58 - From Electrical Technician to Software Developer in 8 Months

In this episode we'll talk to Dustin, who is a recent graduate from the Coders Campus Bootcamp and managed to land a job within two months of starting the search. Dustin and I talk about his prior co...

4 Touko 202256min

Kaikki yhdessä sovelluksessa

Kuuntele kaikki suosikkipodcastisi ja -äänikirjasi yhdessä paikassa.

Sinulle valikoitua sisältöä

Podme-sovelluksessa kokoat suosikkisi helposti omaan kirjastoosi. Saat meiltä myös kuuntelusuosituksia!

Jatka kuuntelua koska tahansa

Voit jatkaa siitä mihin jäit, myös offline-tilassa.

Premium

9,99 €/kk

Kaikki premium-podcastit
Ei mainoksia
Ei sitoutumista, peruuta koska tahansa

Aloita 14 päivän kokeilu

Premium

13,99 €/kk

Kaikki premium-podcastit
Ei mainoksia
Ei sitoutumista, peruuta koska tahansa
Yksi lisäkäyttäjä

Kokeile 14 päivää maksutta

Suosittua kategoriassa Liike-elämä ja talous

bakkari-tarinoita-tapahtumien-takahuoneista

Tarinat ja äänet, joita rakastat kuunnella

Kuuntele kaikki suosikkipodcastisi ja -äänikirjasi

Lue lisää