Hi i use iBatis 2 not 3, and i solved this using a TypeHandlerCallback. 1) in my sqlMapConfig.xml i declared the use of the type handler: <typeHandler javaType="mypackage.EnumAddressType" callback="mypackage.EnumAddressTypeIbatisTypeHandlerCallback"/> 2) i've implemented the iBAtis interface com.ibatis.sqlmap.client.extensions.TypeHandlerCallback and defined the methods to write and read from DB column.
If i rebemeber correctly an example of this is in guide or tutorial pdfs on the iBatis site Best regards Andrea On Thu, Jan 14, 2010 at 10:11 PM, Remijan, Michael < michael.remi...@suddenlink.com> wrote: > I have a legacy database which contains. A flat structure for addresses > like this: > > > > > homeAddress|homeCity|homeState|homeZip|workAddress|workCity|workState|workZip. > > > > I would like to map this into a List<Address> objects where the “home” > address uses Enumeration AddressType.HOME and “work” address type uses > Enumeration AddressType.WORK. > > > > How would I go about doing this with iBatis? > "The information transmitted is intended only for the person or entity to > which it is addressed and may contain proprietary, confidential and/or > legally privileged material. Any review, retransmission, dissemination or > other use of, or taking of any action in reliance upon, this information by > persons or entities other than the intended recipient is prohibited. If you > received this in error, please contact the sender and delete the material > from all computers." >