<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
EntityManager.find returns null.
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/aupres">Joseph Hwang</a> in <i>EJB3</i> - <a href="http://community.jboss.org/message/605376#605376">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p style="min-height: 8pt; height: 8pt; padding: 0px;"><span style="font-weight: bold; font-size: 9pt; color: #000000; font-family: 굴림체;"> </span> </p><p class="NHN_Writeform_Main">My developmet environment is</p><p class="NHN_Writeform_Main" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><div class="NHN_Writeform_Main"><span style="font-size: 9pt; color: #000000; font-family: 굴림체;">  OS : Linux CentOS 5.6</span><br style="color: #000000;"/><span style="font-size: 9pt; color: #000000; font-family: 굴림체;">  JDK : JDK 1.6</span><br style="color: #000000;"/><span style="font-size: 9pt; color: #000000; font-family: 굴림체;">  JBoss : JBoss 5.1.0.GA</span><br style="color: #000000;"/><span style="font-size: 9pt; color: #000000; font-family: 굴림체;">  DB : Oracle 11g</span></div><p class="NHN_Writeform_Main" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="NHN_Writeform_Main">EntityManager.find method always returns null. Same source is executed good on Windows Server 2008 and SQL Server 2008.</p><div class="NHN_Writeform_Main">Codes are<br style="color: #000000;"/><span style="font-size: 9pt; color: #000000; font-family: 굴림체;"><br/>-Members.java(Entity)-<br/><br/>package com.aaa.ejb3;<br/><br/>import java.io.Serializable;<br/><br/>import javax.persistence.Column;<br/>import javax.persistence.Entity;<br/>import javax.persistence.Id;<br/>import javax.persistence.Table;<br/><br/>@Entity<br/>@Table(name = "family")<br/>public class Members implements Serializable {<br/>    @Id<br/>    @Column(name = "EMP_ID")<br/>    private String ID;<br/>   <br/>    @Column(name = "EMP_Passwd")<br/>    private String Passwd;<br/>   <br/>    @Column(name = "EMP_Name")<br/>    private String Name;<br/>....getter와 setter method....</span></div><p style="min-height: 8pt; height: 8pt; padding: 0px;"><span style="font-size: 9pt; color: #000000; font-family: 굴림체;"> </span> </p><p><span style="font-size: 9pt; color: #000000; font-family: 굴림체;"> </span><div class="NHN_Writeform_Main">Through STDOUT</div><div class="NHN_Writeform_Main"><br/>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=?<br/>13:48:53,951 INFO  [STDOUT] null<br/>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=?</div><p class="NHN_Writeform_Main" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><div class="NHN_Writeform_Main">SQL select is done well and there is no exception, but why EntityManager.find returns null?<br/>When I execute EntityManager.persist, insert SQL is generated and values are inserted to Oracle DB!!!!</div><div class="NHN_Writeform_Main"> </div><div class="NHN_Writeform_Main">I need your advice ! Thanks in advance</div><div class="NHN_Writeform_Main"> </div><div class="NHN_Writeform_Main">Best Regards</div></p><div class="NHN_Writeform_Main"><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>-EJBLoginBean.java(Session Bean)-<br/>package com.aaa.ejb3;<p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>import javax.ejb.Stateless;<br/>import javax.persistence.EntityManager;<br/>import javax.persistence.PersistenceContext;<p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>@Stateless<br/>public class EJBLoginBean implements IEJBLogin {<p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>    @PersistenceContext(unitName="MyDBTest")<br/>   EntityManager em;<br/>    <br/>    public Object loginFunc(Class clazz, Object primaryKey) {<br/>        // TODO Auto-generated method stub<br/>        Object obj = em.find(clazz, primaryKey);<br/>        System.out.println(obj); <span style="font-weight: bold; color: #ff0000;">// always returns null</span><br/>        return em.find(clazz, primaryKey);<br/>    }<p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>}<p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>- WSLoginTest.java(EJB Invocation)-<br/>@WebService<br/>public class WSLoginTest implements WSLoginTestPort {<br/>    <br/>    @EJB<br/>    IEJBLogin login;<p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>    public String loginFunc(String ID, String Passwd) {<br/>        // TODO Auto-generated method stub<br/>        try {<br/>            Members member = new Members();<br/>            member = (Members)login.loginFunc(Members.class, ID); <strong style="color: #ff0000;">// I tried ID.trim but failed.</strong>                      <br/>            if( member == null )<br/>                return "no user."; <span style="font-weight: bold; color: #ff0000;">//always return this value</span><br/>            else if(!Passwd.equals(member.getPasswd().trim()))<br/>                return "wrong password";<br/>                else<br/>                    return member.toString();<br/>        }<br/>        catch(Exception e) {<br/>            return e.getMessage();<br/>        }<br/>    }<p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>}<p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>in console<p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>13:47:37,381 INFO  [SessionFactoryObjectFactory] Factory name: persistence.unit:unitName=TotalTestEAR.ear/EJBLoginModule.jar#MyDBTest<br/>.....<br/>13:47:48,492 INFO  [SchemaUpdate] updating schema<br/>13:47:57,430 INFO  [TableMetadata] table found: SCOTT.FAMILY<br/>13:47:57,430 INFO  [TableMetadata] columns: [emp_passwd, emp_name, emp_id]<br/><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>JBoss recognized Entity ...</p><span style="font-size: 9pt; color: #000000; font-family: 굴림체;">There is no Exception.</span></div></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/605376#605376">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in EJB3 at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2029">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>