Newbie question: join

moonlight · **Joined:** Mon Aug 29, 2005 9:46 am **Posts:** 102

Hello everyone,

I'm having problems with a simple join. I have the following statement, from a createQuery:

Code:

 
from FichaTecnica as f  join auge.bean.Produto as p  where upper(p.descricao) like upper(?)  order by descricao

and I get the error:

Code:

2005-09-30 14:47:32,328 ERROR StandardWrapper[/AugeProducao:action]  -> Servlet.service() for servlet action threw exception
java.lang.NullPointerException
        at org.hibernate.hql.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:264)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3022)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:2841)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2719)
        at 

I don't know what's wrong, is it my HQL or my mapping files? I'll put them below:

Code:

  <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" 
         "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
  
 <hibernate-mapping>
    <class name="auge.bean.FichaTecnica" table="FICHATECNICA" >
       <id name="fichaTecnica" column="fichaTecnica" type="java.lang.String"> 
           <generator class="assigned"/> 
       </id>           
          
       <property name="molde" column="molde" type="java.lang.String" />
       <property name="tamanhoPiloto" column="tamanhoPiloto" type="java.lang.String" />
                                            
       <many-to-one name="estilista" column="estilista" class="auge.bean.Pessoa" 
                    not-null="false" lazy="false"/>                       

       <many-to-one name="produto" column="produto" class="auge.bean.Produto" 
                    not-null="false" lazy="false"/>                       
                                        
    </class>
 </hibernate-mapping>

Code:

  <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" 
         "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
  
 <hibernate-mapping>
    <class name="auge.bean.Produto" table="PRODUTOS" >
          <id name="produto" column="produto" type="java.lang.String"> 
              <generator class="assigned"/> 
          </id> 
       <property name="descricao" column="descricao" type="java.lang.String" />
               
    </class>    
 </hibernate-mapping>

Could someone help? What's the right way for the HQL? Is mine right? Is my mapping files right?

I thank you all for the help

moonlight · **Joined:** Mon Aug 29, 2005 9:46 am **Posts:** 102

please?

nathanmoon · **Posted:** Fri Sep 30, 2005 4:01 pm

Looks like you should have p.descricao, not just descricao, in your order by.

I don't see anything wrong with your mapping files at first glance.

I find that the new Hibernate Tools are very useful for getting your queries right. It will parse them into SQL on the fly, so you can immediately see if it's correct.

moonlight · **Joined:** Mon Aug 29, 2005 9:46 am **Posts:** 102

I changed it, now it's:

Code:

from FichaTecnica as f  inner join f.produto as p  where upper(p.descricao) like upper(?)  order by p.descricao

and the same error is happening. Is it my hql?

Thanks

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

Try this :

Code:

from FichaTecnica as f  where upper(f.produto.descricao) like upper(?)  order by f.produto.descricao 

moonlight · **Joined:** Mon Aug 29, 2005 9:46 am **Posts:** 102

it worked! thank you so much!