-
1. Re: PostgreSQL collection problem
askesis Dec 8, 2006 3:19 AM (in response to sherkan777)
Nothing wrong with this: unless you specify an order in an SQL query, a
database is allowed to return the result set in any order it likes. It
is not even required to return the same result set in the same order if
the query is rerun immediately after the first time.
The fact that MySQL returns the records in insertion order is a
"coincidence".
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl -
2. Re: PostgreSQL collection problem
sherkan777 Dec 8, 2006 8:28 AM (in response to sherkan777)So, can U tell me how to force DB to load objcets collection by find. method?
Is any annotation for one to many relation mapping to specify loadings objcets from db?
or, how U control loading objects from db (not using query and order by) but loadings them by find.(parent)? -
3. Re: PostgreSQL collection problem
pmuir Dec 8, 2006 8:56 AM (in response to sherkan777)You need to use @OrderBy or @Sort on the collection (RTFM)