All Questions
Tagged with spring-mybatis mybatis-sql
13 questions
0
votes
0
answers
88
views
MyBatis Mapping Xml Issue
I was writing this project and I have this problem about the mapping. I am doing something wrong but I cannot find it. I've also checked the document of MyBatis but I couldn't find any update info.
I'...
1
vote
0
answers
59
views
Mybatis - nested lazy loaded result property is already exist on result map issue
I’m plan to upgrade the spring from 4 to 5
Due to which I need to upgrade mybatis from 2 to 3.5.11
While upgrading mybatis , I’m facing this issue which is something unclear to me.
I’m getting below ...
- 33
0
votes
1
answer
368
views
Mybatis, pass muliple list as parametres
String loadCandies(@Param("id") String id, @Param("varietyList") List varietyList, @Param("errorCode") List errorCodes)
How can I achieve this in mybatis xml, as for a ...
- 19
0
votes
1
answer
337
views
how to directly add ENUM in Mybatis IN query ,with no params
i directly have to check ENUM in where condition ,
<if test="params.fileTypes != null and !params.fileTypes.isEmpty()">
AND
RTRIM(INTH.IF_FILETYPE) IN
<...
- 31
1
vote
1
answer
768
views
MyBatis dynamically including script
I am trying to dynamically include select query based on some input parameters.
The following is what I am trying to achieve.
<sql id="query1">
SELECT * from
table_1
WHERE a = #{...
- 83
1
vote
0
answers
506
views
How to populate values to Map of a POJO in MyBatis
I have a Java class that looks like this.
class Student {
private String studeID;
private String UUID;
private Map<String,Object> attributes;
}
And I have SQL to get students as ...
- 3,520
0
votes
1
answer
1k
views
Mybatis returningHashMap
I am new to MyBatis. Could anyone help me to resolve this. Thank you.
I created a table named "CodeValue" with columns like "Code","Value" etc. I am retrieving the ...
- 175
2
votes
1
answer
703
views
Mybatis Insert PK manually
I am trying to single insert data into table with assigned PK. Manually assiging PK.
XML file
<insert id = "insertStd" parameterType = "com.org.springboot.dao.StudentEntity" ...
0
votes
1
answer
382
views
Dynamic query execution in mybatis/xml file
I have a spring boot application code from controller to dao in which I execute queries in mybatis/xml files. I want to pass the entire query as a variable to the dao and then it should get executed ...
4
votes
3
answers
6k
views
How to solve indexOutOfBounds error in MyBatis selectForUpdate?
I use postgreSQL. Here is my request in a myBatisMapper:
<select id="findByStatusAndIdentityAndPrvCode" parameterType="java.lang.String" resultMap="Request">
...
- 533
0
votes
0
answers
289
views
Mybatis to map automatically to support dot
<select id="findAll" resultType="com.pojo.Pod">
select
a.id,
a.name,
a.create_date,
a.user_name as 'user.name'
a.user_phone as 'user.phone'
from t_pod a
</select>
configuration
...
- 155
1
vote
1
answer
1k
views
Getting Map<Long, List<Object>> using MyBatis
Here is my method, I need to get a Map<Long, List<CMBill>>:
@Mapper
public interface CMBillMapper {
@MapKey("groupId")
Map<Long, List<CMBill>> ...
- 533
0
votes
0
answers
815
views
Unable to insert the batch in sql via MyBatis
I've recently started learning to use MyBatis and I am stuck up in one scenario. I am not able to insert the list of Reason object in sql by using MyBatis. I am having below ReasonMapper.xml file but ...
- 11