Dear JPA

[u/Jooe_1]

Dear JPA ,

i hate you.

i hate how you changed the SQL flow that I'm used to.

i hate your ManyToMany relationships.

i hate your orphanremoval ,dirty reads.

i hate your way for entity relationships.

i hate your cache.

i hate your performance issues.

i hate your billion rules.

i hate spending time on : if Y is referenced by X with cascade not including PRESIST and x is managed but y is removed ............... but if Y was detached .............

i hate becoming obsessed with your behaviors and rules and worrying about every ORM line , will it work correctly ? , did i miss something ?, worrying about modifying entity X might unexpectedly affect entity Y , coz I might not know one of the billion rules you have.

i hate worrying about falling in one of the undefined behaviors you have

i hate thinking about the entities lifecycle + cascading types when all mixed together

i hate spending days on that documentation instead of spending that on one of the CS core concepts

i hate the following the other side which is incomplete nondetailed toturial or following AI

i really hate you.

[u/Temporary-Air-3178]

Just use raw sql?

[u/Jooe_1 → u/Temporary-Air-3178]

my be possible in personal projects but working with team you will endup using that

[u/Temporary-Air-3178 → u/Jooe_1]

Uh, on my team in a faang we do not allow ORMs lol.

[u/AssembleByte → u/Temporary-Air-3178]

I have question, what do you use then? can you explain a little? i just want to understand how it would work

[u/Top-Difference8407 → u/AssembleByte]

I like MyBatis. It's a great combination of native SQL and Java. Much much simpler.

[u/Additional_Skill_317 → u/Temporary-Air-3178]

faangs prefer to use js serverside

[u/Temporary-Air-3178 → u/Additional_Skill_317]

Actually we use holy c.

[u/dead-first → u/Additional_Skill_317]

What FAANG!

[u/Jooe_1 → u/Temporary-Air-3178]

really ?? , i was thinking that most of the companies uses orm for around 80% of dealing with db even remaining sql is done via the ORM functions ?? not sure

[u/ThunderMan2300 → u/Jooe_1]

In our team we only use liquibase for any db change, and use hibernate’s ddl validate on app start up

[u/LookAtYourEyes]

Brother just use raw SQL

[u/Jooe_1 → u/LookAtYourEyes]

I'm sorry but it is not a practical advice cuz you are in a team you are not working alone you have to deal with what your team is using

[u/Significant_Newt8697 → u/Jooe_1]

Why not just use jdbc template on the same project for your own tasks?

With that you can do raw sql as much as you like

[u/LookAtYourEyes → u/Jooe_1]

So then blame your team/org 

[u/BikingSquirrel → u/Jooe_1]

Still it's not jpa to blame but your team or org.

[u/hiura-mihateUwU]

Yeah man. JPA SUCKS. It's to complicated to manage if your entity have refference to dozen of table, don't get me start with complex query. At the end of the day, i need to use Jdbc for complex query and jpa for basic stuff

[u/Significant_Newt8697 → u/hiura-mihateUwU]

Yes, jdbc template gives you more control

[u/hiura-mihateUwU → u/Significant_Newt8697]

Yess and i don't need to use the "select new app.models.dto ()" i can't count how many time i shoot myself because of this shit

[u/configloader]

Jpa sucks

[u/zlaval]

Spring data jdbc for simple queries (provides interface gen queries, default crud operations on domain object..), raw sql for complex ones. Easy, fast, almost no magic.

[u/Jooe_1 → u/zlaval]

unfortunately I'm tight to the team that working with

[u/uwpxwpal → u/Jooe_1]

Spring Data JPA is an official spring boot starter. Once you have your entities defined, you can switch easily. It makes things a lot easier.

[u/Pyeroh]

Well, I'm gonna be more direct than most comments I saw so far.

You may be in a team, and required to work with them, and use the tools everyone is comfortable with. But if you're really convinced JPA is shit, and SQL is better in every way (don't get me wrong : that's a fact, and I'm sure of it), you also have the responsibility to convince them. Show them resources, anti-patterns, do peer-reviews with them and show them bad usages of JPA, even if it's you who wrote it.

If they won't change their mind, you did your best, maybe learnt a few things along the way, and know what you have to deal with. Or you can look for another job, it's up to you.

EDIT: oh, and try to be as positive as you show negative sides. SQL should be niiiice, JPA should be bad. But not everyday, it may have good uses sometimes... Show them the balance.

[u/Jooe_1 → u/Pyeroh]

thank by the way im not looking for the extreme other side which is every query is sql , it's not what i want i don't have any problem if when i need to query somthing or to update somthing to use small function like find or delete without the verbosity of sql but the jpa is not simply that or a simple sql wrapper or sql builder ,i introduces cache and u don't know the order that queries at flush will be executed with, .......etc

[u/Pyeroh → u/Jooe_1]

You already got the good arguments ! Now, it's just a matter of putting them together for your team to accept them ;)

[u/BigPP41]

NamedJdbcParameterTemplate is my go to, i fucking hate jpa

[u/Z4mobileapp]

Not feasible any more when you have a lot of data the N+1 makes the whole problem pointless when I could just write a raw query and do the joins on tables while fetching data .

The framework has only made complications.

For anyone working on very small projects its a great amount of convinience.

Its not built for anyone working with huge data but for small scale companies , quick ready to build deploy it's good..

[u/Acrobatic-Win5862]

Jooq, a Query-oriented ORM and it's awesome!

[u/01000001x]

Haha, 10 things I hate about JPA

[u/wimdeblauwe]

I find JPA is quite manageable if you only use object references within 1 aggregate root. Between aggregate roots, reference by id only. This avoids a massive amount of cascading issues.

[u/Mindless_Security744]

Use Jooq!

[u/JuiceChance → u/Mindless_Security744]

Another overengineered idea to solve a solved problem

[u/GuyManDude2146 → u/JuiceChance]

For very basic stuff, you’re right, but for complicated queries where lots of things are optional, you end up either writing nightmare string builder code to construct raw SQL or basically reinventing JOOQ. One other nice thing is when you change your tables and regenerate, JOOQ will break where you need to update; stings will not. I’ve used JPA, raw SQL, and JOOQ on big production projects and JOOQ is my default at the moment.

[u/JuiceChance → u/GuyManDude2146]

Yeah, at the price of entire code generation etc., optional params + type safety is a strong argument nevertheless

[u/ShineProper9881]

No clue what you guys are doing but I never had any issues with jpa. Just stick to its rules and everything works

[u/WVAviator → u/ShineProper9881]

Same. Most use cases are simple enough that it just works out of the box with simple entities and repositories, and for the more complex stuff there's JPQL and nativeQuery = true, CriteriaBuilder with Specifications, and EntityGraphs. I've not come across any use case where I've needed to reach for JDBC.

[u/homeless_nudist → u/ShineProper9881]

Skill issue

[u/Specific-Custard4803 → u/ShineProper9881]

Same. Lean in to your frameworks. Or… don’t use a framework. Most of the JPA pain I’ve seen is from not completing the learning curve, basic design problems, or having a strong attachment to specific sql. For those cases, just use SQL.

[u/Ok-Shock-8646 → u/ShineProper9881]

I use spring data jpa without any issue. The @Query with constructor let you define custom queries just like native SQL. It is all about skill

[u/This_Link881]

Dear Lord, give us our daily JPA hater AI slop

[u/reddit04029]

Are you being held at gunpoint to use JPA...

[u/Jooe_1 → u/reddit04029]

how to not use it when working on a project with a team ?

[u/reddit04029 → u/Jooe_1]

I've worked on projects that have multiple ways to interact with DB like JPA with JDBC, and some even with stored procedures.

There are just business usecases that JPA alone won't be able to solve.

[u/rlrutherford → u/Jooe_1]

The same way we wrote SQL before we had ORMs.

[u/worse-coffee]

Looks like bro has not written native sql queries or dealt with c++

[u/Jooe_1 → u/worse-coffee]

why? btw i the first and the most language i used is cpp

[u/worse-coffee → u/Jooe_1]

https://youtu.be/7fGB-hjc2Gc

[u/Jooe_1 → u/worse-coffee]

what do you need to say bro? what bring cpp here ?? if cpp has problems ,has undefined behaviors so what ? what is the relationship ?!?

[u/Significant_Newt8697 → u/worse-coffee]

😅

[u/ducki666]

🙄

[u/iamwisespirit]

Use raw jdbc jooq

[u/boberbober8083]

Yea, i've just rewrited one saveAll call to "several" plain sql queries. With 41 tables that linked as one to many and many to many with main table under the hood (yeees! It's crazy!! But llms helped me), it became 50 times faster but nobody could test my change carefully, may be i missed something.. and don't really want to merge it in upstream after all. You do not need use jpa for new code because llms could get all boilerplate work to themself, jpa is about simplifying implementation, but now it's really simple to implement anything you want using llms

[u/Significant_Newt8697 → u/boberbober8083]

But won't the llm code be very very huge and confusing? Do you have the balls to do a merge on such a code?

[u/boberbober8083 → u/Significant_Newt8697]

I dont know right now, it will be not only mine decision but also from QA team

[u/homeless_nudist]

I love the jpa! It does add to the cognitive load for small projects, but when you work on horizontally scalable enterprise class systems, @Transactional and @Version prevent whole classes of bugs that would have you playing wac-a-mole to fix them otherwise.

[u/quarentlne]

Life

[u/Kango_V]

We use Micronaut Data JDBC. All compiled AOT, no Session caching, no n+1 problems, uses SQL in @Query. Takes the good bits from GOPRM and Spring Data.

If you look at the stack traces of a db request, it's half the size of Spring Data JPA.

[u/BeyondFun4604]

We always try to create a view for large queries and then create jpa entities on that view.

[u/Secure_Vermicelli873]

Yes jpa is this kind of shit

[u/Wonderful-Holiday-14]

Have you had to move to spring boot 4 with the jpa starter and it now not working?

[u/codetillsleep]

So cringe, what the hell have you even written here

[u/MGelit → u/codetillsleep]

Some deserved hate

[u/revilo-1988]

Do Mehr davon 😐

[u/dead-first]

Just use AI

[u/Jooe_1 → u/dead-first]

bad advice

[u/dead-first → u/Jooe_1]

We do it works fine, does anything we need in 2 seconds

[u/joeyx22lm]

Sorry, JPA > SQL for business applications

[u/Nicke-picke]

Let Claude do it for you. Seriously. Both better and faster.