Yes that’s why I want to move to something based on

ResquestPredicate

See my proposal at the end of my last comment

That’s a what we use to define various chainable predicates

Like

GET(”/foo”).and(contentType(APPLICATION_JSON).and(header(”FooHeader=aaa”))

Much more flexible and indeed we avoid to “pollute”

String

with that

I will try to get that working tomorrow

@orangy Done https://jira.spring.io/browse/SPR-15126

See the DSL proposal at the end of https://jira.spring.io/browse/SPR-15065?focusedCommentId=134722&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-134722

Maybe not the final syntax but you will get the idea

Yep, pretty much the same as in #ktor 🙂

Thanks for your feedbacks @orangy

speaking of which. I'm being working with @sdeleuze porting some of the KotlinPrimavera features to Spring Framework

Guys, do you know any kotlin-friendly lightweight mappers from DB query results to DTOs?

You mean like Exposed or Requery ? Or just the JDBC to DTO part ?

Last time that I tried MyBatis wasn't bad at all

I would like to write native queries and have the library automatically map parameter object => parameters and result set => DTO list

now I use this function for the first part

fun <T : SQLQuery> T.setParametersObject(query: Any) = apply {
    query.javaClass.kotlin.memberProperties.forEach {
        setParameter(it.name, it.get(query))
    }
}

Just checked Exposed, Requery and MyBatis, all look quite complicated

We use JPA repositories a lot, and I wouldn’t like to add an extra powerful ORM

My issue with Requery is that it is not possible to use real POJOs

For Spring + Exposed, see https://spring.io/blog/2016/03/20/a-geospatial-messenger-with-kotlin-spring-boot-and-postgresql

My main issue here is that Exposed seems not a project very well supported, even if they really helped with

@Transactional

support

QuerySQL support is not here yet

You can have a look to https://github.com/sdeleuze/geospatial-messenger/tree/spring-data-jdbc-repository

That’s a branch based on Spring Data JDBC but again nto a first class supported library

Maye we could see how far we can go with Spring JDBC extensions @dh44t is about to contribute

See the simple approach I took here: https://github.com/sdeleuze/geospatial-messenger/blob/spring-data-jdbc-repository/src/main/kotlin/io/spring/messenger/repository/MessageRepository.kt

I believe #relational-sql could be a better place to ask

Hey guys. Where can I find a decent kotlin + spring boot example? I need to setup a new project and want to try kotlin for it