0

Im using hibernate and i tried to do the following

session.get(Company.class, 1);

After i executed the statement above i got this strange select statement generated by hibernate

Hibernate: 
    select
        company0_.Company_ID as Company1_31_4_,
        company0_.version as version2_31_4_,
        company0_.Address_ID as Address5_31_4_,
        company0_.Company_Code as Company3_31_4_,
        company0_.Company_Name as Company4_31_4_,
        company0_.Phone_ID as Phone6_31_4_,
        address1_.Address_ID as Address1_0_0_,
        address1_.version as version2_0_0_,
        address1_.Company_ID as Company4_0_0_,
        address1_.Address as Address3_0_0_,
        company2_.Company_ID as Company1_31_1_,
        company2_.version as version2_31_1_,
        company2_.Address_ID as Address5_31_1_,
        company2_.Company_Code as Company3_31_1_,
        company2_.Company_Name as Company4_31_1_,
        company2_.Phone_ID as Phone6_31_1_,
        phone3_.Phone_ID as Phone1_77_2_,
        phone3_.version as version2_77_2_,
        phone3_.Company_ID as Company5_77_2_,
        phone3_.Fax_Number as Fax3_77_2_,
        phone3_.Phone_Number as Phone4_77_2_,
        company4_.Company_ID as Company1_31_3_,
        company4_.version as version2_31_3_,
        company4_.Address_ID as Address5_31_3_,
        company4_.Company_Code as Company3_31_3_,
        company4_.Company_Name as Company4_31_3_,
        company4_.Phone_ID as Phone6_31_3_ 
    from
        testing.Company company0_ 
    left outer join
        testing.Address address1_ 
            on company0_.Address_ID=address1_.Address_ID 
    left outer join
        testing.Company company2_ 
            on address1_.Company_ID=company2_.Company_ID 
    left outer join
        testing.Phone phone3_ 
            on company0_.Phone_ID=phone3_.Phone_ID 
    left outer join
        testing.Company company4_ 
            on phone3_.Company_ID=company4_.Company_ID 
    where
        company0_.Company_ID=?

What is wrong here?

2
Contributors
1
Reply
26
Views
3 Years
Discussion Span
Last Post by milil
0

You dont use it well, try like this:

Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();

List<Company> lista = new ArrayList<Company>();
Criteria crit = session.createCriteria(Company.class);

if (true){ // you can add restriction like this name is passed in to method...
       crit.add(Restrictions.like("name", name).ignoreCase());
}
lista = crit.list();
sesija.getTransaction().commit();

And you can see a lot of examples on this link.

Edited by milil

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.