Hibernate Community • View topic - Order by element of Collection

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Order by element of Collection

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

jellyfish8899

Post subject: Order by element of Collection

Posted: Wed Aug 25, 2004 12:45 pm

Beginner

Joined: Tue Mar 23, 2004 8:40 pm
Posts: 22

I got the Oracle error with the following HQL:

Code:

select 
  elements(vo.descriptions)  
from 
  CompanyVO vo 
order by 
  elements(vo.descriptions)

Any ideas? Thanks in advance!

P.S. Problem is table alias "descriptio1_" instead of "descriptio2_" is used in order by clause.

Martin

Hibernate version:
2.1.6

Mapping documents:

Code:

    <map name="descriptions"
      table="COMPANY_DESCR"
      lazy="false"
      cascade="all"
      >
      <key column="COMPANYOBJID"/>
      <index column="LOCALEINFOOBJID" type="string"/>
      <element column="DESCRIPTION" type="string"/>
    </map>

Full stack trace of any exception that occurs:
net.sf.hibernate.JDBCException: Could not execute query java.sql.SQLException: ORA-00904: invalid column name

Name and version of the database you are using:
Oracle 8.1.7

Generated SQl:

Code:

SELECT 
  descriptio2_.description as x0_0_
FROM 
  company companyvo0_,
  company_descr descriptio2_
WHERE 
  companyvo0_.objId = descriptio2_.companyobjid
ORDER BY  
  descriptio1_.description

Top

jellyfish8899

Post subject:

Posted: Thu Aug 26, 2004 11:30 am

Beginner

Joined: Tue Mar 23, 2004 8:40 pm
Posts: 22

That's my only workaround right now, any comments?

HQL

Code:

select 
  elements(vo.descriptions)  
from 
  CompanyVO vo,
  vo.descriptions vo_descriptions 
order by 
  vo_descriptions

Generated SQL

Code:

SELECT 
  descriptio2_.DESCRIPTION as x0_0_
FROM 
  COMPANY companyvo0_,
  COMPANY_DESCR descriptio1_,
  COMPANY_DESCR descriptio2_
WHERE 
  companyvo0_.objId=descriptio1_.COMPANYOBJID and
  companyvo0_.objId=descriptio2_.COMPANYOBJID
order by  
  descriptio1_.DESCRIPTION

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum