I'm still confused. I can't find any place where it says that an order by field has to be in the primary key. I am accustomed to doing an order by any field as long as that field is also in the select clause. Did I miss something in the docs, or am I unknowingly thinking in terms of a non standard SQL?
Dain Sundstrom wrote: > JbossCMP only needs to load the primary key columns, and it does not > think lname is a pk column. You either have the pk fields misconfigured > or the custom pk class is not written correctly. > > -dain > > Greg Turner wrote: > > In JBoss 3.0, I have a JBoss query: > > <jboss-ql> > > <![CDATA[SELECT OBJECT(a) FROM Customer a WHERE a.zip = ?1 > > ORDER BY a.zip DESC]]> > > </jboss-ql> > > > > This query fails because the SQL that is executed is only selecting on > > customer.id, not both customer.id and customer.lname. > > > > How can I make it select on the required fields? > > > > Thanks > > > > Greg > > ------------------------------------------------------- > This sf.net email is sponsored by: Dice - The leading online job board > for high-tech professionals. Search and apply for tech jobs today! > http://seeker.dice.com/seeker.epl?rel_code=31 > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user -- Greg Turner, JBoss Authorized Consultant Tiburon Enterprise Systems http://www.tiburon-e-systems.com Box 1171 Tiburon, CA 94920 415-332-3363 ------------------------------------------------------- This sf.net email is sponsored by: Dice - The leading online job board for high-tech professionals. Search and apply for tech jobs today! http://seeker.dice.com/seeker.epl?rel_code=31 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
