We addressed this issue by creating enums for the type columns, then creating a type handler to map from the column value to the enum and vice versa. In addition to the programming benefits of working with enums, you also let iBATIS handle the translations for both select and insert.

On 4/26/2010 9:42 AM, Josh Kamau wrote:
Hi team;

I am working on the domain model for  a project. I have a class named
user that has a class named UserType as one of the properties. I know
when i want to select all users, i will use joins to pick up all
corresponding usertypes. How do i do inserts? Do i have to write a
handler for userType? or can i do something like

    INSERT INTO users(... usertype_id ...) VALUES(..
#{usertype.usertype_id}...)

Please help;

I have spent the whole day trying to figure this out. Am using ibatis
3.0 and am new to ibatis.

Regards
Josh


--
Guy Rouillier

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org

Reply via email to