All Questions
46 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
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 ...
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
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
1
vote
0
answers
734
views
How to call an Oracle PL-SQL procedure which has a custom defined complex Object type as OUTPUT parameter from Java Spring boot application
From Spring boot application I am trying to call Oracle Procedure with multiple IN and OUT parameters. One of the OUT parameters is of nested custom Object type. I'm looking for a way to call the ...
- 21
0
votes
0
answers
275
views
Stored Procedure Fast in Oracle SQLdeveloper, But Slow in Java Spring Boot
I have several stored procedures, doing a simple insert or update, that runs almost instantly when ran from Oracle SQLdeveloper, but when calling the same stored procedures from a Spring Boot ...
- 91
2
votes
2
answers
1k
views
Error while calling stored procedure in Postgres using Spring boot JPA
I have created a stored procedure in Postgres
CREATE OR REPLACE PROCEDURE reset_disabled()
LANGUAGE plpgsql
AS $$
DECLARE
BEGIN
UPDATE regional_price_info
SET ...
- 303
0
votes
0
answers
569
views
calling mysql stored procedure (without parameter and return) from java spring boot webserver
i've created a mysql stored procedure with SP name: spAssignPairNo
my stored procedure doesn't take any parameters and doesn't return any result.
the SP will make data update to Picking_Item table ...
2
votes
2
answers
3k
views
Spring Data JPA app calling Oracle package procedure rises PLS-00201 error
I'm trying to make a simple Spring Boot application (using STS 4) that returns some data from an Oracle 19c database. My application uses an annotation-based configuration and accesses only the schema ...
1
vote
1
answer
2k
views
fixing Mysql Delimiter syntax error in testcontainers init script
I want to test a stored procedure with testcontainers. So I am initializing my container with an SQL script containing the definition of the stored procedure but I am getting this syntax error
java....
- 337
0
votes
0
answers
2k
views
Calling postgres stored procedure from spring boot
I want to execute postgres stored procedure from my spring boot app.
CREATE OR REPLACE FUNCTION procedure_name() RETURNS void language plpgsql
as
$$
BEGIN
// logic implementation is doing manipulation ...
- 1
2
votes
2
answers
7k
views
Call Oracle StoredProcedure with multiple output parameters
I have this special case. I have an Oracle stored-procedure that doesn't receive IN parameters but returns 4 OUT parameters.
My entity class is this ...
@Entity
@Table(name = "TABLE_NAME&...
- 419
2
votes
1
answer
470
views
@NamedStoredProcedureQuery is not working for the simple procedure call in JPA Java
I am getting an error : Attempt to set a parameter name that does not occur in the SQL: i_reorg_id . It does not make sense to me as there is i_reorg_id in the SQL.
Procedure is:
create or replace ...
