Bugs item #645842, was opened at 2002-11-29 13:11 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=645842&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole >Status: Closed >Resolution: Duplicate Priority: 5 Submitted By: Partha Dutta (pdutta) >Assigned to: Jeremy Boynes (jboynes) Summary: JBossQL ORDER BY Problem w/ Informix Initial Comment: I am running JBoss 3.0.3. I have the following finder query in the jbosscmp-jdbc.xml file for a bean named Groups: <query> <query-method> <method-name>findAllOrdered</method-name> <method-params></method-params> </query-method> <jboss-ql>SELECT OBJECT(g) FROM Groups g ORDER BY g.groupName</jboss-ql> </query> I am using Informix as my database server. This is a snippet of the server.log file: 2002-11-25 12:40:41,756 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.Gro upsEJB.findAllOrdered] Executing SQL: SELECT t0_g.group_number FROM GROUPS t0_g ORDER BY t0_g.name ASC 2002-11-25 12:40:41,763 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityComma nd.GroupsEJB] Executing SQL: SELECT group_number,name, description FROM GROUPS WHERE (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) OR (group_number=?) The first SQL statement DOES NOT work in Informix!! It will produce an error (SQL error code -309). Anything in the order by clause must be specified in the select list. The question I have is why is the container even trying to perform an ORDER BY while fetching the primary keys? I would have though that the ORDER BY would be performed on the subsequent query. ---------------------------------------------------------------------- Comment By: Stephen Coy (scoy) Date: 2002-12-03 15:43 Message: Logged In: YES user_id=463096 This is a duplicate of 591835 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=645842&group_id=22866 ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
