All Questions
1,574
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 ...
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 ...
-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 ...
0
votes
1
answer
52
views
ERROR o.h.e.jdbc.spi.SqlExceptionHelper - ERROR: syntax error at or near ":" when using @Query
In my Postgres database, I have a table called ts_kv
id | key | json_v
——————————----------------------
UUID | Integer | json
The value of json_v is like
[{"ts":61000,"...
0
votes
1
answer
53
views
Why JPA is adding fields of subclass when dealing with superclass? How to prevent that?
I want to use a SQL function to get length of a saved blob.
I use jpa, an enity and a repository for that.
My implementation looks more or less like this:
public interface UploadRepository extends ...
0
votes
1
answer
36
views
Is there optinal stored procedure parameters support in SimpleJdbcCall of Spring framework?
So i have stored procedure in my Oracle database with default and in-database parameters:
procedure cool_procedure(
i_id in number
, i_number in varchar2
, i_check ...
0
votes
0
answers
17
views
Issue with PUT request in Spring service updating database but not reflecting changes in response
I have a method in my Spring service that is called by the controller to handle a PUT request. Essentially, this method takes the ID of the feedback and the new feedback object to perform a custom ...
0
votes
1
answer
32
views
SQL query for selecting a single role in PostgeSQL query with Pageable object
I have this Oracle query implemented as HQL and Spring Boot query which I want to migrate to PostgreSQL
@Query("select profileId from HrDepartment where profileId = :id and profileId is not ...
0
votes
0
answers
7
views
Enable data version control using RDS + Spring
My team is currently developing a solution using Spring and RDS to store/display our data in relational SQL table. What our customer want is to be able to retrieve the data that is in a particular ...
0
votes
0
answers
49
views
Generate Native Query with JOOQ and Map with Hibernate
Is it possible to generate a native query with jooq and use hibernate to do the mapping? I am generating the exact same sql that hibernate shows with print-sql: true, but am still getting org....
0
votes
0
answers
19
views
Birt throws sql error, while in designer it is ok
I have a report desing in BIRT. When i execute it with run-option in designer everything works properly. But when i try to execute it in code it throws SQL syntax error. Birt version is 4.14
As i see, ...
0
votes
0
answers
30
views
Hibernate changes UpperCamelCase to lower_snake_case when parsing values in @Column and @Table annotations
this is how entity is defined:
@Data
@Entity
@Table(name = "Recipes")
public class BoardRow {
@Id
@JsonProperty
@Column(name = "Id")
private String id;
@...
0
votes
1
answer
82
views
Table not being created with schema
Im working on a project where I have to create 2 connections, one to h2 one to s3 to upload files. The s3 is up & running & the schema is creating just fine, although when trying to do the ...