iBatis get executed sql
- by qaxi
Hi all.
Is there any way where I can get the executed query of iBatis? I want to reuse the query for an UNION query.
For example:
<sqlMap namespace="userSQLMap">
<select id="getUser" resultClass="UserPackage.User">
SELECT username,
password
FROM table
WHERE id=#value#
</select>
</sqlMap>
And when I execute the query through
int id = 1
List<User> userList = queryDAO.executeForObjectList("userSQLMap.getUser",id)
I want to get SELECT username, password FROM table WHERE id=1
Is there any way I could get the query?
Thanks.