197 questions
2
votes
0
answers
262
views
StoredProcedureQuery with Multiple IN parameter not working after hibernate(6) and java (17) upgrade
After upgrading to Java 17 and hibernate 6, the sequence of IN parameter was changed. I was able to fix this by changing the sequence while sending the IN parameter to the procedure.
But I am ...
- 21
-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 ...
0
votes
1
answer
261
views
JAVA Spring calling a Stored Procedure expects 3 parameters when there should only be 2
my repository is as following:
@Repository
public interface StatisticsRepository extends JpaRepository<CampaignStatisticModel, Integer> {
@Procedure(value = "getCampaignStatistics&...
- 93
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
0
votes
1
answer
777
views
Stored Procedure - Snowflake - get details of all columns and rows
I am trying to get 4 column names from the table which has 10 rows and I want to loop through all rows in that table and pass those column values as parameters into some other stored procedure.
How ...
- 189
0
votes
2
answers
656
views
DB2 stored procedure to run multiple insert & update SQL statements using List array from Java application
I want to use a DB2 stored procedure to run multi insert & update SQL statements from my Java application. I have prepared below procedure that contains error.
In this implementation, I first want ...
1
vote
1
answer
1k
views
I am trying to run a SQL query inside a Javascript Snowflake Stored Procedure but it isn't working and it keeps failing to initialise
I am trying to create a Javascript Stored Procedure in Snowflake where the javascript executes a sql query. I am new to javascript and I stole all of it from an existing one that already exists (and ...
0
votes
0
answers
321
views
Db2 LUW Java SP issue
I am trying to run a Stored Procedure which has registered as an external Java Program to Db2. Whenever I call it, I keep getting the error:
SQL4304N Java stored procedure or user-defined function
&...
- 1
0
votes
0
answers
53
views
Calling pkg and Stored procedure, but it give me syntax error
I am trying to call the pkg and the procedure in java, as below:
public void rebuildIndexes() {
Query query = getEntityManager().createNativeQuery("BEGIN BFPA_ARCHIVING....
- 1
1
vote
1
answer
399
views
Oracle DB Java Stored Procedure: line starting with hash sign #
I have inherited an old Oracle 12c database, which I'm running on a local Oracle 19c server. The database contains the following Java Stored Procedure
create or replace and compile java source named ...
- 12.9k
0
votes
0
answers
750
views
Oracle21c stored procedure and ora-29540
Originally, I was trying to tie together Oracle Database (21c) with RabbitMQ, to enable more efficient microservice communication between the database and a Docker environment (Swarm mode). I found ...
- 23
1
vote
1
answer
3k
views
Exit the stored procedure and RAISE error in Snowflake stored procedure like BREAK or RAISERROR in SQL Server
I have a stored procedure which executes multiple queries and for each of those queries I have a try and catch block as shown below. If there is an error, I capture and insert into a LOG table.
...
- 189
0
votes
2
answers
493
views
calling sqlj.install_jar from jdbc?
I have a python snippet that I try to port to java. The aim is Gradle but I could not get that to work, so I figured I would start with plain JDBC. The python code looks like this:
import argparse
...
- 7,191
-1
votes
1
answer
2k
views
Spring Boot - more cleaner or elegant way to pass multiple parameters to stored procedure spring data repository
how pass multiple parameters as DTO or Entity class in arguments method of Repository interface Spring Data
i have one procedure that receive multiple parameters of type IN and i have issue with my ...
- 29
0
votes
2
answers
859
views
how to get the data out of a stored procedure when the data is a 'clob' on an IBMi using DB2?
I am accessing a IBMi running DB2 from a java JVM. I have a stored procedure that returns a CLOB
and I want to access the clob from Java.
The sql for the stored procedure is:
CREATE OR REPLACE ...
- 41