All Questions
Tagged with stored-procedures java
1,264 questions
0
votes
0
answers
75
views
StoredProcedureQuery does not end
We are trying to call a PL/SQL Procedure that runs in a Oracle Database. The complete PL/SQL procedure runs for 10-12 minutes.
With SpringBoot 3.x with Java 21, we use Hibernate to call this Stored ...
0
votes
1
answer
48
views
How to debug a SP response in Quarkus using EntityManager
Good afternoon, I am currently building a microservice that executes the call of an SP (Stored Procedure) in Quarkus using EntityManager and StoredProcedureQuery, the issue is that I am experiencing ...
- 813
0
votes
0
answers
58
views
Problem with stored procedure that not save my rows
I do a stored procedue in my db, I have more of 1 row if I run stored procedure in mysql workbench, but if I try to debug my programm result set is empty
I tried debug, but rs is empty. This is my ...
-1
votes
1
answer
45
views
Multiple tables as output parameters in Procedure using hibernate
CREATE OR REPLACE PACKAGE BODY Pkg_name
IS
PROCEDURE proceure_Name (
Id IN Long,
startDate IN DATE,
EndDate IN DATE,
Table1 OUT Table1_Name%ROWTYPE,
Table2 OUT ...
1
vote
0
answers
30
views
Calling stored procedure with Hibernate which multiple type of outputs
I have a stored procedure from my DBA team. Here is the stored procedure, and temp table created. All I want to know here, how to map the temp table to the output value while calling the procedure in ...
- 11
0
votes
0
answers
172
views
Stored Procedure Returning Null in MyBatis with Spring Boot Integration
I'm encountering an issue where a stored procedure returns null when called through MyBatis in a Spring Boot application, despite working correctly in isolation. I'm seeking help to resolve this ...
0
votes
0
answers
45
views
Stored procedure is returning an empty result in Java with JPA
I'm trying to call a stored procedure in the same way I did for other stored procedure, but now I'm having some troubles because it returns a cursor in addition. The return is an empty Map<String, ...
1
vote
0
answers
60
views
Procedure Call is giving value in dbeaver but not from code call
Hi I am executing a stored procedure I am getting its result when I run it from dbeaver with my desired parameters correctly, whereas for the same procedure I am getting null resultant when I try to ...
- 197
0
votes
0
answers
97
views
geeting error sql udf datashare not enabled while calling redshift procedure from java using Namedparameter
i am trying to call redshift stored procedure which contain multiple temporary table operation . but calling proc getting error "sql udf data share not enabled " redshift exception.
i am ...
- 1
0
votes
1
answer
123
views
CallableStatement for DB2 StoredProcedure throws BadSqlGrammarException - Descriptor index not valid (10>9)
Stored Procedure:
CALL STORED_PROCEDURE_PROCESS_ONE_TIME(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Stored Procedure Variables:
d Stored_Procedure_Process_One_Time_...
d pi
d xterm ...
- 49
1
vote
0
answers
303
views
How to call a stored procedure from Spring Data JPA and map the result to a custom object without having a corresponding entity?
Question:
I'm working on a Spring Boot project where I need to call a stored procedure from my database using Spring Data JPA. The stored procedure returns a result set that I want to map to a custom ...
0
votes
0
answers
208
views
Can I pass the stored procedure name as a parameter in spring jdbc? I want to ensure that there is no SQL injection as my procedure name is user input
I am using Spring JDBC and I want to call a stored procedure which will have only 1 String argument.
My problem is that the stored procedure name is a user input.
How to avoid SQL injection while ...
1
vote
1
answer
423
views
Running stored procedure without waiting for it to finish
So I have this stored procedure that I run from my Spring boot application. It works and life is good.
Now I want to run it asynchronously. Just launch the process and not leave the consumer waiting ...
- 195
0
votes
1
answer
513
views
I am trying to return an Array Of Objects from Oracle stored procedure in Java. Need some advice on fetching individual objects from the array
0
I am trying to return array of an object from an Oracle stored procedure call in Java.
I have created one OBJECT type at DB. This is having 5 attributes
Created a TABLE type of the object.( as I ...
- 1
1
vote
0
answers
145
views
java.lang.NegativeArraySizeException while calling a stored procedure
I am calling a stored procedure using spring data jpa
@Query(value = "DECLARE "
+ "p_transaction_header schema.transaction_header_rec \\:= NULL; "
+ "...
- 434