My Query

any type of join gives error where as if i use table1,table 2 and use where clause it works.
i.e this query works

select w.WellName from AM.Library.AMWell as w , AM.Library.AMOperator op
where w.Operator.Id = op.Id and op.Id = 5020


Queries that didnt work

select w.WellName from AM.Library.AMWell as w inner join AM.Library.AMOperator op on w.OperatorId = op.Id

OR

select w.WellName from AM.Library.AMWell as w inner join AM.Library.AMOperator op on w.Operator.Id = op.Id

OR

select w.WellName from AM.Library.AMWell as w inner join AM.Library.AMOperator op where w.OperatorId = op.Id

This is the exception that i got in both ways

NHibernate.QueryException: outer or full join must be followed by path expression [select w.WellName from AM.Library.AMWell as w inner join AM.Library.AMOperator op on w.OperatorId = op.Id
]
at NHibernate.Hql.FromParser.Token(String token, QueryTranslator q)
at NHibernate.Hql.ClauseParser.Token(String token, QueryTranslator q)
at NHibernate.Hql.PreprocessingParser.Token(String token, QueryTranslator q)
at NHibernate.Hql.ParserHelper.Parse(IParser p, String text, String seperators, QueryTranslator q)
at NHibernate.Hql.QueryTranslator.Compile()
at NHibernate.Hql.QueryTranslator.Compile(ISessionFactoryImplementor factory, IDictionary replacements, Boolean scalar)
at NHibernate.Impl.SessionFactoryImpl.GetQuery(String queryString, Boolean shallow) at Ayende.NHibernateQueryAnalyzer.Model.Project.HqlToSql(String hqlQuery, IDictionary parameters)
at Ayende.NHibernateQueryAnalyzer.UserInterface.Presenters.QueryPresenter.TranslateHql()



Here is my mapping file


<class name="AM.Library.AMWell, AM.Library" table="AM_Well">
<id name="WellId" column="WellId">
<generator class="identity" />
</id>
<property name="WellName" column="WellName" />
<property name="OperatorId" column="OperatorId" />
<property name="WellNumber" column="WellNumber" />
<many-to-one name="Operator" class="AM.Library.AMOperator, AM.Library" column="OperatorId" cascade="none" update="false" insert="false" />
</class>


<class name="AM.Library.AMOperator, AM.Library" table="ET_Operator">
<id name="Id" column="ID">
<generator class="assigned" />
</id>
<property name="Name" column="OperatorID" />
<property name="Remarks" column="Operator" />
</class>



I am using NHibernate version 1.0.2, Windowx XP, .net 2.0, sqlserver 2005 express


many thanks in advance

Zafar Ullah

Hi

Please change the query as mentioned below.

select w.WellName from AM.Library.AMWell w inner join AM.Library.AMOperator op on w.OperatorId = op.Id

In addition, in the mapping file table name is AM_WELL and in quey its AMWELL. Correct that.

Also try this blog.

http://forum.hibernate.org/viewtopic.php?t=956459

NOTE: DO not forget to rate if this is helpful.

Regards,

From NHUsers group of google i got this reply and it works.

http://groups.google.com/group/nhusers/ ... 84eb?hl=en