I’m using myBatis with Oracle. I guess there is something similar in other DB. Actually you always can create procedures in DB, which usually is better for the future, when you have to support the project. <delete id=”deleteUnfinishedData” parameterType=”map”> {call declare begin delete from TABLE1 where id = #{valueFromMap1}; delete from TABLE2 where id = … Read more
this is an example in my project and it works fine <select id=”getObject” parameterType=”Map” resultType=”hashmap”> select * from TABL where <foreach collection=”dataMap” index=”key” item=”value” open=”” separator=” and ” close=””> #{key}=#{value} </foreach> </select>
The myBatis User Guide on Dynamic SQL has an example on how to use a foreach loop to build the query string, which works for lists and arrays. Prior to release 3.2 you had to use xml configuration to use dynamic sql, with newer versions it should also be possible to use dynamic sql in … Read more
I believe the answer is the same as is given in this question. You can use myBatis Dynamic SQL in your annotations by doing the following: @Select({“<script>”, “SELECT *”, “FROM blog”, “WHERE id IN”, “<foreach item=’item’ index=’index’ collection=’list'”, “open='(‘ separator=”,” close=”)”>”, “#{item}”, “</foreach>”, “</script>”}) List<Blog> selectBlogs(@Param(“list”) int[] ids); The <script> element enables dynamic SQL parsing … Read more
You want to get a Map<Integer,String> where the Integer is the id and the String is the name. If there were 200 categories in your table, you would want 200 entries in your map, rather than a list of 200 maps. MyBatis can’t quite do that out of the box, but you can use its … Read more
I’ve found the solution here: What transaction manager should I use for JBDC template When using JPA ? I’m using JpaTransactionManager and not DataSourceTransactionManager. JavaDoc http://static.springsource.org/spring/docs/3.0.x/javadoc-api/org/springframework/orm/jpa/JpaTransactionManager.html This transaction manager also supports direct DataSource access within a transaction (i.e. plain JDBC code working with the same DataSource). This allows for mixing services which access JPA and … Read more
The accepted answer is not the recommended way of handling batch operations. It does not show true batch statements since the batch executor mode should be used when opening a session. See this post in which a code contributor recommended that the proper way to batch update (or insert) is to open a session in … Read more