JBoss Community

Codes are

-Members.java(Entity)-

package com.aaa.ejb3;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "family")
public class Members implements Serializable {
    @Id
    @Column(name = "EMP_ID")
    private String ID;
  
    @Column(name = "EMP_Passwd")
    private String Passwd;
  
    @Column(name = "EMP_Name")
    private String Name;
....getter와 setter method....

Through STDOUT

13:48:53,875 INFO  [STDOUT] Hibernate: select members0_.EMP_ID as EMP1_2_0_, members0_.EMP_Name as EMP2_2_0_, members0_.EMP_Passwd as EMP3_2_0_ from family members0_ where members0_.EMP_ID=?
13:48:53,951 INFO  [STDOUT] null
13:48:53,952 INFO  [STDOUT] Hibernate: select members0_.EMP_ID as EMP1_2_0_, members0_.EMP_Name as EMP2_2_0_, members0_.EMP_Passwd as EMP3_2_0_ from family members0_ where members0_.EMP_ID=?

SQL select is done well and there is no exception, but why EntityManager.find returns null?
When I execute EntityManager.persist, insert SQL is generated and values are inserted to Oracle DB!!!!

I need your advice ! Thanks in advance

Best Regards

 

-EJBLoginBean.java(Session Bean)-
package com.aaa.ejb3;

 

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

 

@Stateless
public class EJBLoginBean implements IEJBLogin {

 

    @PersistenceContext(unitName="MyDBTest")
   EntityManager em;
   
    public Object loginFunc(Class clazz, Object primaryKey) {
        // TODO Auto-generated method stub
        Object obj = em.find(clazz, primaryKey);
        System.out.println(obj); // always returns null
        return em.find(clazz, primaryKey);
    }

 

}

 

- WSLoginTest.java(EJB Invocation)-
@WebService
public class WSLoginTest implements WSLoginTestPort {
   
    @EJB
    IEJBLogin login;

 

    public String loginFunc(String ID, String Passwd) {
        // TODO Auto-generated method stub
        try {
            Members member = new Members();
            member = (Members)login.loginFunc(Members.class, ID); // I tried ID.trim but failed.                     
            if( member == null )
                return "no user."; //always return this value
            else if(!Passwd.equals(member.getPasswd().trim()))
                return "wrong password";
                else
                    return member.toString();
        }
        catch(Exception e) {
            return e.getMessage();
        }
    }

 

}

 

in console

 

13:47:37,381 INFO  [SessionFactoryObjectFactory] Factory name: persistence.unit:unitName=TotalTestEAR.ear/EJBLoginModule.jar#MyDBTest
.....
13:47:48,492 INFO  [SchemaUpdate] updating schema
13:47:57,430 INFO  [TableMetadata] table found: SCOTT.FAMILY
13:47:57,430 INFO  [TableMetadata] columns: [emp_passwd, emp_name, emp_id]

 

JBoss recognized Entity ...

There is no Exception.