How to deal with native queries and dtos in kotlin...
# springh
Hoosain Madhi
09/13/2023, 3:00 PMHow to deal with native queries and dtos in kotlin?
đź‘€ 1
e
eddMX
09/13/2023, 3:54 PMI wanted to know whats the point with this question
a
antonarhipov
09/15/2023, 10:20 AMCould you please explain, what is a “native query”?
h
Hoosain Madhi
09/15/2023, 10:26 AMFrom baeldung:
There are three basic types of JPA Queries:
Query, written in Java Persistence Query Language (JPQL) syntax
NativeQuery, written in plain SQL syntax
Criteria API Query, constructed programmatically via different methods
v
Victor Cardona
09/15/2023, 3:58 PMAre you using Spring Data JPA? You would write them exactly as you would in Java, but you could make use of multiline strings.
Copy code
@Query(
value = """select * from something where name = :name""",
nativeQuery = true
)
fun findSomethingByName(name: String): Something?a
antonarhipov
09/15/2023, 4:01 PMOK, then you’re talking about JPA. Native query or not, it doesn’t matter. Which query you would use, you still will use entities. For entities, please use usual kotlin classes, not the data classes. You might read something about JPA with data classes at Baeldung’s website and take it for granted.
Kotlin data classes are not designed to be used with JPA
If you want to learn more about the subject, I suggest this webinar recording:
152 Views