First i'm not good at English so I hope you understood my mistake.

I want to get some ordered results by hibernate Creteria.

First native query that I want to ordered results is

select * from foo order by regist_date;

1. table DDL is


# Table: 'foo'
#
CREATE TABLE `foo` (
`sort_id` bigint(20) NOT NULL default '0',
`regist_date` varchar(7) NOT NULL default '',
`foo_id` varchar(64) default '',
`foo_name` varchar(100) default '',
PRIMARY KEY (`sort_id`,`reg_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


2. Generated DTO is
Foo.java, FooPK.java

3. config is

<class
name="Foo"
table="foo"
>

<composite-id name="comp_id" class="FooPK">
<key-property
name="sortId"
column="sort_id"
type="java.lang.Long"
length="20"
/>
<key-property
name="registDate"
column="regist_date"
type="java.lang.String"
length="7"
/>
</composite-id>

<property
name="FooId"
type="java.lang.String"
column="foo_id"
length="64"
/>
......


above is my env.
and then How do I get ordered results use criteria..

I using criteria like this :

Session session = HibernateUtil.getSession();
List zines = session.createCriteria(ZinePopular.class)
.addOrder(Order.desc("regDate"))
.setMaxResults(5)
.list();

how can I??
thanks your help

Where is your problem?

my problem is

Session session = HibernateUtil.getSession();
List zines = session.createCriteria(Foo.class)
.addOrder(Order.desc("registDate"))
.setMaxResults(5)
.list();

this code occured error...

net.sf.hibernate.QueryException: could not resolve property: ZinePopularPK.regDate of: com.haansoft.kaatal.model.dto.ZinePopular
at net.sf.hibernate.persister.AbstractPropertyMapping.toColumns(AbstractPropertyMapping.java:50)
at net.sf.hibernate.expression.AbstractCriterion.getColumns(AbstractCriterion.java:35)
at net.sf.hibernate.expression.Order.toSqlString(Order.java:37)
at net.sf.hibernate.loader.CriteriaLoader.<init>(CriteriaLoader.java:78)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3595)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)


of course this error is occured why Foo.java class have not 'registDate' variable that is located in FooPK.java class. [registDate is Primary Key]

so I can't order by registDate....

You can use registDate as in the mapping but you are using regDate (see the exception)

oh sorry it's my mistacke i convert regDate to registDate to this board...

original source code and message is all using regDate........
[it's not error ]

My question is how can I ordering use Primary Key cloumn.
[Condition:
1. Using Criteria class and composite-id tag
2. There is two DTO class one is Foo.java(have FooPK class getter & setter) other is FooPK.java (just have PK)
]

Session session = HibernateUtil.getSession();
List zines = session.createCriteria(Foo.class)
.addOrder(Order.desc("comp_id.registDate"))
.setMaxResults(5)
.list();

thanks your help ^^;

have nice today...