Let's look at the code first, the following is how I bind two aliases to root.createdDate at the same time, but only one will always take effect, and the last a
I have a class Health Check - as part of the class I record how many parasites are seen (enum NONE, SOME, MANY) and also the location of the parasites (enum HEA
I'm asking the question cuz all the related posts i found are not answered Error at line 21 Screenshot Hello guys I need some help with this Query, at line 21 I
I have a problem with the persistence in a java web application. We use Ninjaframework (6.8.1) which uses Guice as dependency injection framework and for persis
I have a directory in which I receive orders as XML file. I want to parse this file and then do some things with it. I can set a scheduled job to check this dir
In a project I am working on we added a secondary data source. This meant adding the entity factory and the transaction manager at the @EnableJpaRepositories. W
Hi I using spring boot jpa and I need to use mapsid. There are not so much information about that and I wonder if anyone can help me understand how to use maybe
What is the best practice for solving the number of cases of N searches? There are 3 search conditions for me. There are search conditions of A, B, and C. In th
For example i have entities @Entity public class A{ @Id Long Id; ... } @Entity public class B{ @Id Long Id; ... } @Entity @IdClass(ABId.class). public class AB{
I search to know if a user have an active subscription @Query("select case when count(u) > 0 then true else false end from User u where u.id=:userId and cur
I am trying to execute a couple of queries on different threads. There are 2 top level queries each executing on different tables at runtime. For executing the
I have this SQL: SELECT b.NAME, b.ID, hc1.CATCH_DATE, hc1.id FROM BIRD b INNER JOIN HEALTH_CHECK hc1 ON hc1.BIRD_ID = b.ID INNER JOIN (
I have a JPA entity with the following fields: @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "modified_by_user_id") private User modifiedByUser; @Conve
I have a table which has a foreign key relationship with an existing table and its child table. The parent table exists before the child table as is populated
I have implemented two entities (Department and Employee) with custom ID generator for Employee, and has a unidirectional one-to-many relationship as shown belo
I have a problem with modifying data while setting database replication Before DB replication, I get data that I want to modify using repository.findById() and
I'm trying different hibernate id generation strategies and I've noticed that it seems like hibernate ignores allocationSize. I have the following entity class:
In an effort to power an autocomplete, I resolved to map a PostgreSQL view. I followed a tutorial for this. It seems that it does not work at all : I've always
Inconsistency between hibernate and postres. Consider we have table student having 2 columns id(Primary Key) and name. Perform the following concurrent query on
I ran into an error with custom delete method in spring data jpa. Basically there's a bag which contains items, and when deleting the bag, all the items in it s