How to Return DTOs from Native Queries with Spring Data JPA

Thank you very much

Thanks man you save my lots of time ❤

If I use namednativequery with custom DTO using sqlresultsetmapping. Is it possible to perform pagination for that?

Thanks my friend, just what I needed

kkk, mais uma vez precisei assistir esse vídeo.

YOU ARE AMAZING!!!!! THANKS!!!!!

I was getting this ConverterNotFoundException, searched alot about this but didn't find anything specific. Found this video which is extremely helpful

Superb video !! Thanks a lot. This helped me a lot.

A good tutorial that makes things clear and simple. It helped me to solve a problem. One thing: in the repository definition of the query I had to use (@Param("id") Long id) instead of (Long id) to make it work. 👍

wao I did save a lot of time just doing the first scenario, making an interface for getting the data.
thanks a lot

sorry, i fail with field id data type bigint sqlserver -> data type java Long. Exception: Could not locate appropriate constructor on class: xxxDto

GOD LEVEL TOUTORIAL

This tutorial is super concise and accurate. It accurately answered the questions most likely to be asked by fresh learners like me..

That's too much code.
Just use " select new MyPojo( a.col1, a.col2... ) from Table a"

Amazing! Thank u so much!

Thanks alot sir, you saved my day

Thank you, so much sir.

Hello, Can you please make a tuto or blog on - how to do the scalar projection? Got few lines in tour blog but not details implementation, I am talking about the object[ ] way to implement DTO

@Thorben Can I export these Repos as a Jar and use them in different projects?

p.first_name as firstName. But what would be the alias for a nested object? For example, address.street as {what?} (assuming that PlayerName references Address)?

This is the good things, but I didn't get how it works, I need to try it in ide. Maybe in next video if is possible to show how it works in IDE with real coding for better understanding 🤔

Muito Obrigado pela aula.

Good content but it's complex. JPA can execute with native query to return the entity class. Then I can map the enity class to the dto.

I love your content :)

Hi, Thorben, ich mag deine Videos sehr und habe normal auch kein Problem, diese in englischer Sprache zu hören, aber manchmal wäre es auch cool sie zusätzlich in deutsch anschauen zu können. vll. denkst du mal darüber nach auch deutsche Untertitel einzubauen. Mach Weiter so!