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?