Left join query

[krunal prajapati]

Hello,
I want to make left join using hibernate,
I can make left join using native query in hibernate like

List<Object[]> langList = session.createSQLQuery("select me.me_Dsidioma,u4.u4_Dstexto from Me_Idiomas me left join U4_Textosussds u4 on u4.u4_Me_nuidioma= me.me_Nuidioma").list();
		 

but while I am using HQL I getting error,

Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: Path expected for join! [select me.meDsidioma,u4.u4Dstexto  from  tid.cip.bd.prepago120000.impl.MeIdiomas me left join U4Textosussds u4 WHERE me.meNuidoma=u4.u4Menuidioma]
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
	at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
	at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:235)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
	at tid.cip.planes.Plans.main(Plans.java:127)

and my hbm.xml and java files are shown below

MeIdiomas.hbm.xml
<?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="tid.cip.bd.prepago120000.impl.MeIdiomas" table="ME_IDIOMAS"> <id name="meNuidoma" type="long"> <column name="ME_NUIDIOMA" length="2"/> <generator class="assigned" /> </id> <property name="meDsidioma" type="string"> <column name="ME_DSIDIOMA"/> </property> <property name="mecdcaracterdecimal" type="string"> <column name="ME_CDCARACTERDECIMAL"/> </property> </class> </hibernate-mapping>


U4Textosussds.hbm.xml
<?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="tid.cip.bd.prepago120000.impl.U4Textosussds" table="U4_TEXTOSUSSDS"> <id name="u4u3Nuidussd" type="long"> <column name="U4_U3_NUIDUSSD" length="2"/> <generator class="assigned" /> </id> <!-- <many-to-one name="u4Menuidioma" class="tid.cip.bd.prepago120000.impl.MeIdiomas"> --> <!-- <column name="U4_ME_NUIDIOMA"/> --> <!-- </many-to-one> --> <property name="u4Menuidioma" type="long"> <column name="U4_ME_NUIDIOMA"/> </property> <property name="u4Dstexto" type="string"> <column name="U4_DSTEXTO"/> </property> </class> </hibernate-mapping>


MeIdiomas.java

package tid.cip.bd.prepago120000.impl;

public class MeIdiomas {

	private long meNuidioma;
	private String meDsidioma;
	private String mecdcaracterdecimal;
	


	/**
	 * @return the meNuidoma
	 */
	public long getMeNuidoma() {
		return meNuidioma;
	}
	/**
	 * @param meNuidoma the meNuidoma to set
	 */
	public void setMeNuidoma(long meNuidioma) {
		this.meNuidioma = meNuidioma;
	}
	/**
	 * @return the meDsidioma
	 */
	public String getMeDsidioma() {
		return meDsidioma;
	}
	/**
	 * @param meDsidioma the meDsidioma to set
	 */
	public void setMeDsidioma(String meDsidioma) {
		this.meDsidioma = meDsidioma;
	}
	/**
	 * @return the mecdcaracterdecimal
	 */
	public String getMecdcaracterdecimal() {
		return mecdcaracterdecimal;
	}
	/**
	 * @param mecdcaracterdecimal the mecdcaracterdecimal to set
	 */
	public void setMecdcaracterdecimal(String mecdcaracterdecimal) {
		this.mecdcaracterdecimal = mecdcaracterdecimal;
	}
	
}

U4Textosussds.java

package tid.cip.bd.prepago120000.impl;

public class U4Textosussds {

	private long u4u3Nuidussd;
	private long u4Menuidioma;
	private String u4Dstexto;
	/**
	 * @return the u4u3Nuidussd
	 */
	public long getU4u3Nuidussd() {
		return u4u3Nuidussd;
	}
	/**
	 * @param u4u3Nuidussd the u4u3Nuidussd to set
	 */
	public void setU4u3Nuidussd(long u4u3Nuidussd) {
		this.u4u3Nuidussd = u4u3Nuidussd;
	}
	/**
	 * @return the u4Menuidioma
	 */
	public long getU4Menuidioma() {
		return u4Menuidioma;
	}
	/**
	 * @param u4Menuidioma the u4Menuidioma to set
	 */
	public void setU4Menuidioma(long u4Menuidioma) {
		this.u4Menuidioma = u4Menuidioma;
	}
	/**
	 * @return the u4Dstexto
	 */
	public String getU4Dstexto() {
		return u4Dstexto;
	}
	/**
	 * @param u4Dstexto the u4Dstexto to set
	 */
	public void setU4Dstexto(String u4Dstexto) {
		this.u4Dstexto = u4Dstexto;
	}
	
	
}

Plans.java main method here

public static void main(String args[]){
		
		HibernateConnectionManager manager = new HibernateConnectionManager();
		SessionFactory sessionFactory = new Configuration().configure("/prepago.cfg.xml").buildSessionFactory();
		Session session = sessionFactory.openSession();
		 Transaction tx = null;
		 tx = session.beginTransaction();
//		 List<Object[]> langList = session.createSQLQuery("select me.meDsidioma,u4.u4Dstexto  from  MeIdiomas me left join U4Textosussds u4 on me.meNuidoma=u4.u4Menuidioma").list();
		 List<Object[]> langList = session.createSQLQuery("select me.me_Dsidioma,u4.u4_Dstexto from Me_Idiomas me left join U4_Textosussds u4 on u4.u4_Me_nuidioma= me.me_Nuidioma").list();
		 
		for(Object[] obj : langList)
		{
			System.out.println(">>>>>>>"+obj[0]);
			System.out.println(">>>>>>>"+obj[1]);
		}
	//	"select d.name,p.name,sum(p.price) as totalprice from Product p join p.dealer d group by p.name";
	//	List langList = session.createQuery("select u4Dstexto from U4Textosussds").list();
	//	List langList = session.createQuery("select meDsidioma from MeIdiomas").list();
		 manager.closeSession(session);
		 System.out.println("success");
		
	}

Now what I have to do to use HQL?
Thank you in advance,
Krunal