Trouble in using joins in hibernate

[Betsy Camel]

Hi all,

I have two tables with the following columns :

Table name : employee
empid | int(11) | YES | | NULL
ename | varchar(20) | YES | | NULL
mgrid | varchar(20) | YES | | NULL

Table name : link
empid | int(11) | YES | | NULL
mgrid | varchar(20) | YES | | NULL

I would like to use the a criteria and mapping for the following condition in sql :

 
select * from employee a, link b where a.mgrid=b.mgrid

the mapping i have created looks like the below:

 
<?xml version='1.0'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> 
<hibernate-mapping>
<class name="Honey" table="employee">
  <id name="id" column="empid" type="java.lang.Integer">
  <generator class="native"/>
  </id> 
  <property name="first" column="ename" type="java.lang.String" /> 
  <!--<property name="last" column="mgrid" type="java.lang.String" /> -->
   
     
      <one-to-one name="last" class="Honey"/>
  </class>
 </hibernate-mapping> 

and

NewFile.hbm

<?xml version='1.0'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> 
<hibernate-mapping>
<class name="Honeys" table="link">
  <id name="id" column="empid" type="java.lang.String">
  <generator class="native"/>
  </id> 
    <!--<property name="mgrid" column="mgrid" type="java.lang.String" /> -->
    <one-to-one name="mgrid" class="Honeys"/>
  </class>
 </hibernate-mapping> 

I am however getting errors like
org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of Honey.setLast

Please help me asap.
[ November 03, 2008: Message edited by: Paul Sturrock ]

[ntumba lobo]

is that possible to see your persistent class and your mapping file ?
[ November 03, 2008: Message edited by: ntumba lobo ]

[Betsy Camel]

//package addressbook.HQL;

 
import java.util.Iterator;
import java.util.List;
 
import javax.sql.RowSet;
 
 
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Restrictions;
import org.hibernate.FetchMode;
public class Criteria
{
 
   /**
    * @param args
    */
   public static void main(String[] args)
   {
      // TODO Auto-generated method stub
  
   Session session = null;
   try {
   // This step will read hibernate.cfg.xml and prepare hibernate for use      
   SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
   session = sessionFactory.openSession();
   /*org.hibernate.Criteria criteria =  session.createCriteria(Honeys.class);
   criteria.add(Restrictions.eq("mgrid", "manju")); //setFetchMode("last", FetchMode.JOIN).
   System.out.println("criteria "+criteria);
   List list = criteria.list();*/
   
   String hql = "from Honey p inner join p.last";
            List query = session.createQuery(hql).list();
            
   Honey obj = (Honey)query.get(0);
   
   System.out.println(obj.getLast());
   }catch(Exception e){
   e.printStackTrace();
   }

  

 
 
   }
 
}

I have already posted the mapping files. Please help!
[ November 04, 2008: Message edited by: Paul Sturrock ]

[Paul Sturrock]

You don't specify a foreign key name in your one-to-one mapping for Honey, which I think means you are trying to associate a row with itself.