Mybatis is way slower than running query in Oracle.

By | April 1, 2016
0 Comment
Share the joy
  •  
  •  
  •  
  •  
  •  
  •  

Today, when I tried a query in mybatis. It is super slow. After an hour investigation, I found the root reason is that we should use #{username} instead of ${value}. Accordingly, we should use map as the type.

<select id="getChgoffDt" resultType="java.util.Date" parameterType="map">
SELECT acc_chgoff_dt FROM daybreak.accounts WHERE acc_nbr = #{accNbr}
</select>>