All Questions
18,648
questions
1
vote
1
answer
24
views
How to convert a row from a table to ENUM in JOOQ?
JOOQ does not convert rows from a table to enum
I tried different conversion methods, but they either didn't do anything, or they displayed errors, I tried to add codegen jooq, but I can't do it, I ...
- 23
-2
votes
0
answers
39
views
is there a way to store unschematised datas in sql database [closed]
mysql : 5.6 java : 11
Am in need of an mechanism to store unschematised data in my db. the case is as follows.
Objective :
To get all user from a 3rd party app and store it in db.
Problem facing :
...
-2
votes
1
answer
35
views
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: USE
I have a query that is trying to grab a number of details from a list of defects:
String useIndexPrimary = "USE INDEX (PRIMARY)";
TypedQuery<Defect> query = getEntityManager()....
- 3,121
0
votes
0
answers
27
views
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'track_SEQ'
Getting this error after upgrading spring to 3.1.5 version & java 17 from 2.x with & java 8.
DB connection is okay and all queries are executed as expected except for repository.save() query
...
- 1
1
vote
0
answers
39
views
How to use case_() in JOOQ? [duplicate]
I get an error(java.lang.IllegalArgumentException: Cannot interpret argument of type class org.org.impl.CompareCondition as Field: id_ml_model_value = null) when using case_() in jooq, I think it's ...
- 23
-1
votes
0
answers
20
views
Hibernate performs redundant DB call to fetch child entity data along with parent during refresh event which is already fetched
I am using Hibernate 5.6.15. Hibernate performing Cascade Refresh of the associated child entities and then use LEFT OUTER JOIN on the parent entity with same child entities and fetch them again
I ...
-3
votes
0
answers
53
views
Is it necessary to use 'name!=null and name. trime()!=' 'when writing SQL statements using mybatis? [closed]
Is it necessary to use name!=null and name.trim()!='' when writing SQL statements using MyBatis?
When writing code for the company, I found that others only wrote a null judgement.
I am a beginner in ...
- 7
-2
votes
0
answers
29
views
Building database management app, what language? [closed]
I work into administration and as a beginner programmer I wanted to build a database management application. For the choice of the language, What languages do I need? and why? am currently learning ...
-1
votes
0
answers
42
views
Java Criteria Api subquery from function result
I need to translate sql query to Java Criteria Api
SQL:
select *
from users u
where exists (select 1 from unnest(u.roles) as user_role where textregexeq(user_role, 'some regexp'))
And I'm stuck with ...
- 41
0
votes
0
answers
26
views
UPSERT native SQL query for Collection as @Param of JPA Repository method
I need to iterate over collection of Enteties and apply UPSERT for each element atomically. As i see it - just need to send this collection into SQL query by SpEL.
I know, what i can iterate over ...
0
votes
0
answers
53
views
How to use binding variables in an Oracle query? [duplicate]
I have an Oracle query written using binding variables:
SELECT
t.id ID,
t.name NAME,
sum(CASE WHEN t.BE_VALIDTO IS NULL AND t.DATE >= :StartDate AND t.DATE <= :EndDate and t.TYPE in (...
- 1
-1
votes
1
answer
48
views
In a JSP file use a form to call a method in a java file to create and then download a a csv file for the user [duplicate]
Having a hard time figuring out how to get my JSP file to trigger a method in my java while using a form. The method sends a query to a db, I want to take the result set from that query and turn in ...
- 31
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 ...
-1
votes
0
answers
21
views
Hibernate HQL query validation error for join-fetch with conditional logic
I'm encountering an issue with a Hibernate HQL query where I'm trying to use conditional logic within a join fetch clause. Here's my query and entity setup:
I have two entities LovMst and LovVal with ...
- 147
0
votes
1
answer
60
views
JPA entity ID field with a SQL Server 2022 Sequence
I am trying to connect my Spring Boot service to a SQL Server 2022 database, but I am having issues with a sequence:
public class SomeEntity {
@Id
@SequenceGenerator(name = "some_seq"...
- 55