Edit Question - KnowledgeHub

Title Body

I am trying to implement a web service that uses open JPA to access the data layer. I am using websphere v7.0 and JPA 2.0. This service is going to get all rows out of a small db (about 6 rows and it won't expand much at all in the future). I am attempting to get all rows and return them through the user. I am right now creating the Session Bean that will retrieve the data. I have several JPA objects one of them (representing a row of all the data I want to return) looks like so... @Entity @NamedQueries({ @NamedQuery( name="EmailDomainTrust.getEmailDomains", query="SELECT DOMAIN_NAME, DESCRIPTION, CONFIRMED_BY, CONFIRMED_DATE FROM EMAIL_DOMAIN_TRUST") }) @Table(name="EMAIL_DOMAIN_TRUST") public class EmailDomainTrust implements Serializable { @Id @Column(name="EMAIL_DOMAIN_TRUST_ID") private long emailDomainTrustId; @Column(name="DOMAIN_NAME") private String domainName; } There is a lot more in there, but I don't want to make this too long. I just thought I would show a couple usefull variables and maybe some get sets. In my session bean I am trying to get all the rows... public List<EmailDomainTrust> GetEmailDomains(){ EntityManagerFactory emf = Persistence.createEntityManagerFactory(""); EntityManager em = emf.createEntityManager(); // EntityTransaction userTransaction = em.getTransaction(); System.out.println("Testing 1..2...3...!"); List<EmailDomainTrust> ListOfEmailDomains = em.find(EmailDomainTrust.class, arg1) return null; } What I have so far is definitely not up to snuff. But the tutorials online never describe getting all rows out of a table. I won't have any parameters for this method, so I won't be able to select based on ID or anything like that. An

Tags (comma-separated) Cancel