All Questions
27 questions
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
169
views
MyBatis select returning String, string, cursor
I have a stored procedure that returns a string(return_code), String(return_msg), cursor(p_out_refcursor).
The application is using annotation based
@Select("{ call SAMPLES.INSERT_T_SAMPLE ( &...
- 1
1
vote
0
answers
909
views
Calling Oracle Stored Procedure (using MyBatis) with Custom Object Input Parameter
My goal here is to successfully call the stored procedure while passing in the memberDetails which is a custom oracle object as seen in the screenshot, however it is complaining that the the column ...
- 21
0
votes
1
answer
587
views
Integration testing with MyBatis, H2 and Oracle procedures
I have a stored Oracle procedure that I call like so:
CALL MY_PROC(
p_arg => #{arg, jdbcType=INTEGER, mode=IN},
p_var => #{var, jdbcType=VARCHAR, mode=IN},
...
- 793
1
vote
0
answers
484
views
My resultMap does not work when I use annotations rather than mapper xml
I have a module in my project that is using ibatis Annotations. I need to use a storede procedure in this module that returns one string value and one resultMap(array).
<resultMap id="...
1
vote
1
answer
1k
views
How to Call Stored Procedures from SQL using MyBatis
I've got a working program in Java which is using SQLServer as DB. I know how to use the 'normal' way of using MyBatis like:
<select id="getAllWeapons" resultType="String" parameterType="Map">
...
- 17.6k
0
votes
1
answer
1k
views
Doing bulk updates with MyBatis and Oracle stored procedures
Working on a legacy solution that uses MyBatis and Oracle's stored procedures for bulk database updates. Current version of Mapper looks similar to this
@Mapper
public interface MyMapper {
void ...
- 1,591
0
votes
1
answer
1k
views
Oracle nested table as input argument to stored procedure with Mybatis
I need to call an Oracle Stored Procedure that has an input argument with a nested table type, using Mybatis.
I cannot find any documentation or example concerning this particular usage of MyBatis.
...
- 10.7k
0
votes
1
answer
2k
views
Pass Array of POJO items to a stored procedure using mybatis?
I have the following java class :
public class item implements Serializable {
private long id;
private String name;
public long getUuid() {
return id;
}
...
0
votes
1
answer
2k
views
Sending a list of java objects to an SQL stored procedure via mybatis?
I've asked this question before - didn't really end up with a working solution, and that might have been somewhat my own problem for not really knowing at the time, what the hell I wanted to do.
...
- 1,016
0
votes
0
answers
302
views
Pass a list of POJO items to a stored procedure via myBatis?
This is probably a dumb question - and I did google it quite a bit, and didn't find really anything that (I personally) was able to get working - I think I need a little bit more guidance.
I have the ...
- 1,016
5
votes
2
answers
12k
views
Call stored procedure in MyBatis with multiples IN OUT parameters and annotations
I'm calling a stored procedure in Oracle who receive 7 parameters and return 5, I'm just interested in two parameters.
This is me MyBatis Select
@Select(value = "{CALL prc_ultimo_nombramiento(" +
...
- 533
0
votes
2
answers
1k
views
MyBatis Springs Oracle Stored Procedure
I have been working on Spring application where I am working with MyBatis:
Consider I am having a Oracle Stored Procedure:
CREATE OR REPLACE PROCEDURE getDBUSERByUserId(
p_userid IN DBUSER....
- 13
1
vote
1
answer
2k
views
Sending empty list to stored procedure
I have created a custom Type in oracle as below.
create or replace TYPE "ABC_OBJECT" AS OBJECT (
ticket_no VARCHAR2(50),
);
create or replace TYPE "ABC_OBJECT_LIST" IS TABLE OF ABC_OBJECT;
...
- 552
2
votes
1
answer
1k
views
sql server 2008 stored procedure multiple selects in mybatis
I have a problem about stored procedure multiple selects in mybatis.
Two select statements in stored_procedure.sql
USE cellar;
GO
alter PROCEDURE findAll_sp
AS
SELECT * FROM wine ORDER BY name; //...
- 29