Stack Overflow
Stack Overflow

Questions tagged [simplejdbccall]

Use this tag for questions about the Spring JDBC SimpleJdbcCall class of multi-threaded, reusable objects representing a call to a stored procedure or a stored function.

37 questions
5
votes
2 answers

Getting ERROR: cursor "" does not exist

Im trying to use SimpleJdbcCall from spring.jdbc calling function that return a cursor and im getting following error: org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{? = call…
Herm Heyfe
  • 51
  • 1
  • 3
3
votes
1 answer

SimpleJdbcCall stored procedure call fails after first call

I am using JdbcTemplate to make a call to a stored procedure in as400. I know that the schema and procedure exist and I'm using the correct spelling etc. The first time the application starts the call works as expected and gives no error. Subsequent…
wonza
  • 302
  • 1
  • 4
  • 15
1
vote
0 answers

How to call Oracle function (via SimpleJdbcCall) which return custom type TABLE_NAME%rowtype

I am trying to use a function simpleJdbcCall to call Oracle function which return custom type Oracle function: function getOneRowFromTbale( applicationId in integer ) return table_name%rowtype; After call: public VerificationRequest…
Almir Abrarov
  • 21
  • 4
1
vote
1 answer

Spring - SimpleJdbcCall - Unable to locate the corresponding parameter value for '***' within the parameter values provided

I have the code below. Basically I'm trying to retrieve data from procedure to the Spring project. I got two out parameter which are Struct and Array which makes the process complicated. But for the inOut Array parameter i have Unable to locate the…
shizof
  • 11
  • 1
1
vote
0 answers

jdbcTemplate not returning data from stored procedure

I am trying to call my Teradata stored procedure using simpleJDBCcall but I always get ZERO result though data is available in my table. I tried to debug but no luck. here is my stored procedure. is there any thing I am doing wrong here? REPLACE…
user1591156
  • 1,945
  • 4
  • 18
  • 31
1
vote
0 answers

How to handle a clob return when calling a stored proc using SimpleJdbcCall

I am calling a stored proc, which returns around 20 fields. One of those is a clob. I am using Spring Jdbc, and just cannot handle the clob value. Any operation on the clob, throws closed connection error. The clob contains a large chunk of xml…
Amjad Riaz
  • 11
  • 1
1
vote
0 answers

SimpleJdbcCall - How to extract table parameter from stored procedure in package

This is my situation: I am trying to call a procedure (which has been declared within a PL/SQL package) with two parameters: PROCEDURE p_process_docs ( p_cod IN NUMBER, p_doc_t OUT O_DOC_T ) O_DOC_T is defined as following: create or replace…
MangaPowerZero
  • 58
  • 5
1
vote
1 answer

springboot manually commit after each call to Stored Procedure

I have a springboot application that needs to iterate over a large number of records and call a stored procedure which inserts some data in a table for each record read. we cannot use BatchUpdate because it is taking a long time to process thousands…
daoud175
  • 106
  • 1
  • 18
1
vote
2 answers

Permanent ORA-06550 error, calling stored function from java application using jdbc

i'm trying to call several stored functions from my java app, but whatever function i call i got the same error. For example, given this function: function insert_value (input_name varchar2) return number; I'm trying to call it using: …
Zhaled Asufian
  • 87
  • 1
  • 1
  • 9
1
vote
1 answer

Mockito for SimpleJdbcCall with Spring JdbcTemplate

I tried multiple way to execute the store procedure in my Junit test case to test against the out values but unfortunately nothing is working. My Test case: public class DataTest { @Mock private static DataSource ds; @InjectMocks …
Hitesh Kumar
  • 512
  • 1
  • 8
  • 27
1
vote
0 answers

How to extract data from a Spring Boot SimpleJdbcCall object?

I am trying to use Java with Spring Boot to get the output of a stored procedure in a database. I want the method getBillInformation to return an ArrayList object. I thought the SimpleJdbcCall.returningResultSet() method would do…
OnlyDean
  • 1,025
  • 1
  • 13
  • 25
1
vote
1 answer

Catching RAISE_APPLICATION_ERROR with springframework SimpleJdbcCall

I have a PL/SQL procedure where I call RAISE_APPLICATION_ERROR (-20001, 'Illegal id'); if something goes bad. This seems to work, because the procedure quits and throws the error when it should. I call this procedure…
Somaiah Kumbera
  • 7,063
  • 4
  • 43
  • 44
1
vote
1 answer

calling stored proc in jdbc template which returns multiple rows

If I am calling stored proc Using Jdbc template which returns multiple rows of Data. For Example Stored Procedure returns 200 records based on some business rules. How to iterate and process those 1 at a time, can we use Custom row mapper for…
Uday
  • 21
  • 4
1
vote
1 answer

Simplejdbccall Stored Procedure withNamedBinding true

I want to execute stored procedure with dynamic parameters with SimpleJdbcCall. In total I have 6 optional parameters in SQL server SP, out of them I must be able to pass any or none. My SP executes fine as expected in MS Studio. But not by…
MalarMani
  • 11
  • 3
1
vote
1 answer

Can we call Stored procedure as webhook(just fire and terminate)

I am using JAVA as my backend code and SQL server as my database server and i am calling a Stored procedure and it's very huge sp so i am breaking it into 3 sp's and calling it. but i just want to trigger one sp and it should continue it's task…
shridhar
  • 79
  • 1
  • 12
1
2 3