I have an autowired jpa repository object working. However, I need to use it to add rows into the database from multiple threads. Though, after passing it to another thread, it fails. Code structure However, doing a dbRepository.save() from a thread safe class, I get error cause: java.lang.IllegalStateExcepti…
Tag: spring-data-jpa
In which cases does JpaRepository automatically create the query without you having to use @Query annotation
I am following a Udemy tutorial in Spring boot. There’s a part where @Query wasn’t used for a user-created method in the repository interface. It works, but I want to understand when JpaRepository takes care of the creation of query. In the User class below, @Table wasn’t used. findByEmail(S…
How use generic entity name in JPQL
I have three tables with same column name and types, what changes is just the table name. Example: | TABLE1 | TABLE2 | TABLE3 | | —— | —— | ——- | | ID | ID | ID | | NAME | NAME | NAME | | FOO | FOO | FOO | | BAR | BAR | BAR |
Spring Find by unique properties
Given 1 relational table Doctor_ID Client_ID 2 2 2 3 2 4 3 5 4 2 4 3 And I want all the occurrences where client_id is not equals to 3, ignoring the same doctor_id. In this example, I would only get the 4th row… Doctor_ID Client_ID 3 5 How could I achieve something like that? Answer This query with
Spring repository saveAll inserting duplicate rows for mapped entity
I am trying to insert a list of entities which have one to one relation to another entity. It is possible that the one to one mapped object would be same for many parent entity. I am expecting that the same child entity is referred in foreign keys of parent, but actually duplicate rows are getting created. He…
Spring repository: HQL using constructor doens’t parse NULL values
I’ve a Spring Repository with this HQL query: PupillaryDistanceDTO is a POJO annotated with @AllArgsConstructor(Lombok); unfortunately those null values I want to pass to the constructor are creating some troubles: Removing those null and replacing with some table’s columns, it works. Is there a w…
Spring Data JPA: FindBy on Join Column
I have setup two entities like below in a one-to-one mapping and I am trying to query on the joincolumn like below in my repository: In my BRepository.java, I am trying to do this: I get the following error: No property a found for type B! Did you mean ‘aId’? Is this not the right way to query on …
JPA generated column name doesnt have underscore (column name mismatch)
I have a composite FK which acts as a composite PK. A part of this composite key is Fk to users table and the files are as follows: Users Unit looks like below: UsersUnitPK: UsersUnit: User: I get run time exception as follows: Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: “LKUNIT1_”.…
querydsl: java.lang.NoSuchFieldError: TREATED_PATH
springboot version is 2.51, java vsersion 1.8 it will crash in selectFrom(), erro info: java.lang.NoSuchFieldError: TREATED_PATH how to resolve it,i cant find a way in web there is my code there is dependency BmsPost.java Answer You have mixed versions of querydsl. I guess you are having querydsl-core version…
How to ignore a field from DB [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question I have a list of persons in DB everyone having a CV field which is a MultiPart File in Spring…