Exceptional query -- help needed, SOS

Raul · **Posted:** Fri Jan 05, 2007 5:29 am

Hi,

I am writing a query , in which the select cause contains a column of type [i]"Iesi.Collections.ISet"[/i].

If i mention the column name, i get an execption
[i]{"undefined alias or unknown mapping: m [select m.Annotation_s from com.ml.ps.data.Movement p]"}[/i]

The query i am trying to run is
[i]select m.Annotation_s from com.ml.ps.data.Movement p[/i]

where Annotation_s is of type ISet.

Help or pointer's will be greatly appreciated.

Thankz,
Raul

gert · **Joined:** Thu Jan 19, 2006 4:29 pm **Posts:** 348

Raul wrote:

The query i am trying to run is
select m.Annotation_s from com.ml.ps.data.Movement p

where Annotation_s is of type ISet.

Help or pointer's will be greatly appreciated.

Note "p" in "Movement p" and "m" in "m.Annotation_s ". You probably wanty change one of them.

Gert

Raul · **Posted:** Fri Jan 05, 2007 7:31 am

sorry, that was a silly mistake from me, after correcting the query , the query reads

[i]select m.Annotation_s from com.ml.ps.data.Movement m[/i]

The execption i rec. now is:

[i]{"expecting 'elements' or 'indices' after id [select m.Annotation_s from com.ml.ps.data.Movement m]"}[/i]

Help would be appreciated.

Thankz,
Raul

gert · **Joined:** Thu Jan 19, 2006 4:29 pm **Posts:** 348

Raul wrote:

sorry, that was a silly mistake from me, after correcting the query , the query reads

select m.Annotation_s from com.ml.ps.data.Movement m

The execption i rec. now is:

{"expecting 'elements' or 'indices' after id [select m.Annotation_s from com.ml.ps.data.Movement m]"}

Help would be appreciated.

Thankz,
Raul

You probaly want
select elements(m.Annotation_s) from com.ml.ps.data.Movement m

see http://www.hibernate.org/hib_docs/nhibernate/html/queryhql.html#queryhql-select

Gert

Raul · **Posted:** Fri Jan 05, 2007 8:32 am

I corrected the query to :
select elements(m.ExplicitTags) from com.ml.ps.data.Movement m

Now i am getting the exception
InnerException = {"could not load by id: [com.ml.ps.data.Category#1001]"}

Help will be appreciated.

Thankz,
Raul

Raul · **Posted:** Fri Jan 05, 2007 9:28 am

Gert,

Thanks Gert, though the problem is still not over, however in some cases this it is working well.

Great!!!.

Thanks once again.
Raul

gert · **Joined:** Thu Jan 19, 2006 4:29 pm **Posts:** 348

Raul wrote:

InnerException = {"could not load by id: [com.ml.ps.data.Category#1001]"}

Sounds like the category with id=1001 is referenced somewhere, but that Category is not present in database.

Gert

Raul · **Posted:** Fri Jan 05, 2007 10:22 am

Hi,

Now the exception has been removed, however no rows are bieng retrived.

The code i am using is :

[i]IQuery sqlQuery = session.CreateQuery(" select m.Annotation_s.elements from com.ml.ps.data.Movement m ");

Transaction = sqlQuery.List();[/i]

[b]The Transaction.Count is coming as 0.[/b]

But, When we fire the query in Oracle , it returns a single (1) record.

Help will be appreciated.

Thankz,
Raul