hi
I am using seams generated entities.
Using entity manager i fetched two columns from the database table.
List idList=em.createQuery("select p.programId,p.programOid from Program p").getResultList();
Iterator iterator = idList.iterator(); while (iterator.hasNext()) { programB=(com.awb.action.ProgramBean) iterator.next(); }
public class ProgramBean { private long programOid; private String programId; public long getProgramOid() { return programOid; } public void setProgramOid(long programOid) { this.programOid = programOid; } public String getProgramId() { return programId; } public void setProgramId(String programId) { this.programId = programId; } }