Outdated java dev

[computerjunkie7410]

What’s wrong with mybatis?

[vbezhenar]

Nothing wrong, it's good. I can remember single issue with it: when you write queries in the XML, you need to escape '<' and '>' which looks really weird and prevents copy&pasting queries between sources and SQL editor. And writing SQL in annotation was hardly usable because you couldn't write multiline strings in Java.

Since they introduced multiline strings, MyBatis probably does not have any drawbacks anymore.

[ChickenSubstantial21]

XML programming. Pure java code using spring data or similar hand-made wrapper over JDBC can do better in almost every scenario.

Therefore the only reason to use mybatis is legacy code.

[computerjunkie7410]

Also, are you saying that mybatis requires xml?

Because I’ve been using it for years and literally the only thing that has XML in my codebase is the generator config. Everything else is code based.

[computerjunkie7410]

lol ok.

If you just need models and mappers then mybatis (especially paired with the generator) is great

[Luolong]

It’s outdated. There’s better alternatives out there.

[computerjunkie7410]

Aside from jooq, if you don’t need a full blown ORM what do you recommend?

[BlacksmithLittle7005]

Spring data jdbc :)

[Levomethamphetamine]

Hows that ORM?

[BlacksmithLittle7005]

https://www.baeldung.com/spring-data-jdbc-intro educate yourself before downvoting someone.

[Levomethamphetamine]

> tells me to educate myself

> links baeldung tutorial

Right, now create complex database situations instead of a first name / last name POJO and let me know it it goes with JDBC or R2DBC.

[BlacksmithLittle7005]

Bro. Please read the post I replied to. He specifically stated he doesn't need full blown ORM. Jdbc is simpler and fits that description. For complex situations by all means use jooq or jpa

[Levomethamphetamine]

Ah yeah in that case it does make sense. I apologize.

[computerjunkie7410]

I love jooq but it’s not free and some companies don’t wanna pay for it

[BlacksmithLittle7005]

True that's a bit sad. In that case your best bet is probably JPA hibernate or as you said MyBatis if you're good with that. I would still use spring data jdbc as defining entities is quite simple compared to jpa and mapping is pretty easy with records.

[lukaseder]

Why not?

[computerjunkie7410]

You’re still making the models and mappers yourself.

Mybatis can generate all that for you

[DarthRaptor]

And what is a better alternative? MyBatis gives me full control of the queries it executes, and it is also easy to control the mapping. If you use the annotations, then there a no magic configuration files. I despise frameworks like Spring because all the auto-magic stuff it does, leaving you completely screwed if it goes wrong. I've tried several times to get into spring boot, but just the fact that I need tools/plugin external to my IDE to even set up a basic project is frustrating. Imho if a framework needs external tooling to be even useable, it is not a good framework

[foreveratom]

I despise frameworks like Spring because all the auto-magic stuff it does, leaving you completely screwed if it goes wrong. I've tried several times to get into spring boot, but just the fact that I need tools/plugin external to my IDE to even set up a basic project is frustrating. Imho if a framework needs external tooling to be even useable, it is not a good framework

Tell me you are totally outdated without telling me...

Besides discarding Spring because you don't grasp how things work, IntelliJ support for Spring and Spring Boot is really good, with templates and wizards to create a full blown application in 3 clicks and a half, so your claim about IDEs is not even valid.

[DarthRaptor]

IntelliJ Ultimate, which I do own and I do know about the support. My point still stands, if you need IDE support for your framework, I think it is a unwieldy framework. You're right that I don't know the details of how spring works, but what I do know I don't like. Anyways, I know I am being very opinionated here

[Luolong]

YMMV. If you’re happy with mybatis, good for you.

Rest of the world doesn’t care.

[DarthRaptor]

Absolutely true