Hello!
i'm using DB2, AS400 database.
in User.xml i have:
<insert id="addUser" parameterClass="UserForm">
INSERT INTO USR (
username, passwordfirstname, lastname, role
)
</insert>
in UserDao.java i have
sqlMapper.insert("addUser", user);
Primary key is generated by iBatis (or database). How can i get this value?
For now, i'm using SELECT MAX(pKey) but it's not the happiest way for solving this problem.
I found this example.
http://ibatis.apache.org/docs/java/user/com/ibatis/sqlmap/client/SqlMapClient.html How should i write the <insert> for making this work?
I checked
http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=407 but still no luck
Hope to get answer soon!
Regards