Tag: spring-boot-jpa

Two bidirectional association at the same entity – Column cannot be null

java mysql one-to-many spring-boot-jpa spring-data-jpa

I have a scenario where I have a relationship between two tables. One being the step and the other being to know who is the next step. select * from cpo_workflow_step_control; Step entity: Step_Control My problem is, when I try to save a Step, with a Step_Control associated, JPA tries to save everything and i…

One to One relationship mapping JPA SpringBoot implementation error: ids for this class must be manually assigned before calling save()

java jpa one-to-one spring-boot spring-boot-jpa

I am trying to understand the JPA Spring Boot implementation for One-to-One mapping classes and was hoping if anyone could provide me a clear picture. One to One mapping Scenario: Table foo and Table childfoo Foo has the columns foo_id,foo_name, foo_place childfoo has the columnd foo_id(foreignkey of foo tabl…

Convert to DTO from join selection

java jpa spring-boot-jpa

I have these two tables And I am using this query to get the results So far this is the only way I could retrieve the results and actually use them later. To use them I am using this code currently But using it that way seems odd to me. Is there a better way to directly map the result

why does spring throw me an exception about bad sql code?

java spring spring-boot spring-boot-jpa

Im working in an app that has a spring boot server. the thing is that i have a query, not auto generated one, that throws me a bad sql exception and i cant seem to find out why. Also im using MySQL as a database this is my repository code : The one with the @Query annotation throws me: Can