Using something ala Spring Data JDBC with Quarkus.

[bjorntj]

Hi.

I don't like using ORMs for accessing databases, don't like that I need to fetch data from the database before doing a save, for instance.
But I really do like Quarkus, so I was wondering if it really isn't possible to have database access without using Hibernate or Panache? (without writing old fashion JDBC Java SQL code?

[luca-bassoricci]

https://quarkus.io/extensions/io.quarkiverse.jooq/quarkus-jooq/

[bjorntj]

Thx.. But I do not like JOOQ either. I would like to write the SQL myself, when it is more than standard CRUD methods, those I would like to just use.. And I know, I am a bit weird.. :)

[maxandersen]

You don't need to load data from the database to save it.

Tried to use stateless session?

[bjorntj]

No, I haven't. Maybe worth checking out.

[bjorntj]

But that does not really solve the issue where I like to write complex SQL queries myself. But might be that the Query annotation can be used.
Really like the new JdbcClient in Spring Boot for writing SQL queries.

[luca-bassoricci]

Apache commons DbUtils.
But I suppose you can use Hibernate without entities, just use stateless sessions and native queries.

[bjorntj]

Seems to be too much manually work at first glance but will check it out. Thx. :)

[KangoV]

Although Spring Data JDBC is nice, it does not support composite keys, so is pretty useless for existing databases.

[sathishk]

@bjorntj @KangoV

SQL Builder is a framework-independent, lightweight alternative to Spring JDBC Client. You can find quarkus example here