I have the following problem, the thing is that I have an entity: The thing is that this back is connected to an Oracle DB, in which I already have a few registered users, but these are entered through a Mockaroo script, and when I try to save a new user through a service Rest throws me this error: Of
Tag: jpa
JPA Cast BigDecimal as string
I’m using JPA to query a database, but something strange happens. In some cases the cast works and compiles fine, but with a BigDecimal it doesn’t let me use the cast to make a LIKE with a String. Here is a part of the code that works: pesoObjetivo is a data type Double But when I try to perform t…
Upgrade to springboot 2.6.1 with querydsl jpa 5.0.0
I am trying to upgrade my springboot version from 2.3.4 to 2.6.1. I use query dsl with jpa and apt-maven-plugin. My issue is that I can’t no more generate the QClasses when I run maven compile. I noticed that I am no more able to use an older version of querydsl (previous one 4.4.0 and apt-maven-plugin …
JPA Entity for View containig joins and aliases
I have the following query using which I want to create an entity class for the columns which I am retrieving from the query. How to create an entity class from these columns and what variables are needed to take it in entity class to refer to these columns? Answer View is a virtual table based on the result-…
Does JPQL support the use of a boolean result in another expression?
I am trying to write a query to back a search API. Specifically for a flag searchDrafts – if the flag is true I have to get rows with status DRAFT and else I have to get all rows that have any status other than DRAFT. In regular SQL, the below query works fine: However, a similar thing in JPQL
Bind @param in a Jpa repository native query inside single quotations
I am looking for a way to bind a given param in a native query where the value has to be inside single quotations, like so: However, when I try to run this, it results in hibernate not being able to bind the timeThreshold value as it is provided inside the single quotations ”. Does anyone know how this …
Unable to locate Attribute with the the given name [ANumber] on this ManagedType [com.company.domain.Statistics]
I just upgraded my project to spring5 which is causing the below error for the code which was working fine with earlier spring version. The problem is JPA should map aNumber to ANumber but its not doing so its taking ANumber as ANumber rather than aNumber which is causing this issue. I see one thread for spri…
JPA Hibernate many to many IllegalStateException
I’m attempting to create a many to many relationship. I have a table ‘library_branch’ and i want to join ‘BookCopies’ which contains ‘bookId’, ‘branchId’ and ‘noOfCopies’. I have an error ErrorMvcAutoConfiguration$StaticView. I’m not sure…
Spring JPA relationships
I have some troubles with Spring JPA relationships. I have two entities: Gift and Candy. And I want user to be able to select available candy and add it to gift. How can I do that using spring jpa? I’ve already tried ‘one to many’ relationship with gift as owning side, and I got “null …
Mapping one to one relationships in Spring Boot
I am trying to map a User with a certain Table in a one to one relationship. This here is my code, id appreciate if u take a look at it: User class: The Table class: Answer You don’t mapped parent entity with child entity properly.In parent table object of CTable is currenTable and you mapped by with ta…