juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "SourceForge.net" <nore...@sourceforge.net>
Subject [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER BY columns to the result set
Date Tue, 09 Sep 2003 07:09:18 GMT
Bugs item #803015, was opened at 2003-09-09 09:23
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=434422&aid=803015&group_id=42875

Category: Build
Group: Development
Status: Open
Resolution: None
Priority: 5
Submitted By: Subrahmanya Nayak (snayak)
Assigned to: Nobody/Anonymous (nobody)
Summary: Adding the ORDER BY columns to the result set

Initial Comment:
The juddi code (for example in

 org.juddi.datastore.jdbc.BindingCategoryTable.java  and 

other files as

 well) use select statements which contains ORDER BY 

CLAUSE like:

 

     sql.append("SELECT ");

     sql.append("TMODEL_KEY_REF,");

     sql.append("KEY_NAME,");

     sql.append("KEY_VALUE ");

     sql.append("FROM BINDING_CATEGORY ");

     sql.append("WHERE BINDING_KEY=? ");

     sql.append("ORDER BY CATEGORY_ID");

 

 Here ORDER BY Column CATEGORY_ID is not one of 

selected column. Since that is the ANSI standard

the Code must be changed to contain ORDER BY Column 

CATEGORY_ID in select

 clause as follows



     sql.append("SELECT ");

     sql.append("CATEGORY_ID,");

     sql.append("TMODEL_KEY_REF,");

     sql.append("KEY_NAME,");

     sql.append("KEY_VALUE ");

     sql.append("FROM BINDING_CATEGORY ");

     sql.append("WHERE BINDING_KEY=? ");

     sql.append("ORDER BY CATEGORY_ID");



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=434422&aid=803015&group_id=42875


Mime
View raw message