Questions tagged [querydsl]
Querydsl is a framework which enables the construction of type-safe SQL-like queries for multiple backends including JPA, MongoDB and SQL in Java.
querydsl
2,018
questions
0
votes
0
answers
6
views
QueryDSL join(a, b) vs join(b).on(): Why does @SQLRestriction behave differently?
Intro:
I'm using QueryDSL with Hibernate in a Spring Boot project. I've noticed a difference in the way @SQLRestriction is applied when using join(a, b) versus join(b).on(). Specifically, when using ...
- 1
0
votes
0
answers
17
views
Can't use ACCESS EXCLUSIVE MODE for locking table in Spring boot app
On my project i use QueryDSL for access to Postgres db. Recently i got task to set lock on table so only one instance of app can use table (locks on rows can't be used). I tries to use in code ACCESS ...
-1
votes
0
answers
25
views
Generating Elastic search query in R shiny similar to Java
In my R shiny app, I need to fetch data from Elastic search. But for that, I need an elastic search query in query DSL json to fetch the results from Elastic Search. However similar to Java, I can't ...
0
votes
1
answer
13
views
Query DSL - Regexp inside bool
I'm using OpenSearch Dashboard to look for specific logs. I need to filter them using query DSL to get following results:
"sText": ".*task started" OR "sText":".*...
0
votes
0
answers
29
views
Why does Blaze-Persistence project count queries for pagination despite potential performance issues?
I'm using Blaze-Persistence and noticed that its offset pagination feature projects the count query as follows( concisely reduced ):
select *, (select count(*) from Entity)
from Entity e inner join ...
- 1
0
votes
0
answers
32
views
Query is not fetching the latest data from MySQL while using FOR UPDATE clauses
I have a table which locks rows as per accountId and a lock status column having values 0 and 1.
CREATE TABLE lock (
id INT(11),
accountId INT(11),
isLocked TINYINT(2),
);
The requirement is ...
0
votes
0
answers
15
views
QueryDSL Code Generates Incorrect SQL Query
I'm currently working with QueryDSL in a Java application, and I'm trying to generate a specific SQL query. However, the QueryDSL code I've written is producing a different SQL query than what I need.
...
- 31
-1
votes
0
answers
31
views
spring data jpa and queryDSL with a little complex sql
I used spring data JPA and QueryDSL to find data in the database;
Table A :
id
name
age
1
joe
20
2
jack
22
3
rose
24
Table B :
id
realtion_id
type
aid
1
13
9
1
2
13
0
2
3
13
8
3
here is an ...
- 176
0
votes
0
answers
21
views
Qclass dose not generated(non-existent Qclass) witth Springboot3 + JDK17 + Gradle
spirngboot 3.3.1 + JDK17;
Problem occurred during migration from Springboot 2.7 to 3.3
my build.gradle.kts
enter image description hereplugins {
id("java")
id("org....
- 3
-1
votes
0
answers
29
views
Querydsl get empty value in where condition
In have this kind of enumeration to manage a column value in sqlservet spring application:
public enum Status {
ON("OPEN"),
OFF("CLOSED");
I'm looking a way to retrieve ...
- 53
0
votes
0
answers
29
views
Multi data source configuration with Spring Batch, Spring Data JPA, and Querydsl
I'd like to write a batch application with Spring Batch using ChunkOrientedTasklet where I should execute multiple update queries against two different data sources(logical databases in the same ...
- 431
0
votes
0
answers
9
views
in QueryDSL DTO Conversion, cannot fetch. cannot find query? [duplicate]
I'm getting a NoClassDefFoundError when trying to convert results to a DTO in QueryDSL.
ERROR : Method threw 'java.lang.NoClassDefFoundError' exception. Cannot evaluate com.querydsl.jpa.JPASubQuery....
- 1
0
votes
0
answers
30
views
How to use leftjoin with subquery in QueryDSL?
I want to make followers list in Spring,
It works at mysql but I can't use left join with subquery.
How do I use left join with subquery in QueryDSL(I used by QueryDSL 5.0.0)?
-- original sql
select f....
- 41
0
votes
0
answers
37
views
QueryDSL 5.1 (JPA), Hibernate 6.3 and Window Functions
Context: I want to find the next and previous Entity ID, according to a search criteria and an ordering.
Hibernate is now supporting Window Functions, such as RANK, in the SELECT Clause.
Following ...
- 125
-1
votes
1
answer
25
views
Java QueryDSL: how could I retrieve a column only if in the group there is no null existing?
So I have a table (ORDERS):
ID CUSTOMER_ID LOCATION
1 11 London
2 null London
3 22 Amsterdam
4 33 Amsterdam
5 ...
- 1,418