RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER BY columns to the result set

["Viens, Steve" <St...@FMR.COM>]

Yes, 

I think it would be wise to test these changes with every DB we've got DDL
for (if possible).

  MySQL (Steve)
  HSQLdb (Steve)
  Sybase ASE (Anou) 
  Borland JDataStore (Andy)
  DB2 (?? Anyone have DB2 loaded?)
  PostgreSQL (???)
  TotalXML (Subrahmanya Nayak)

Steve

-----Original Message-----
From: Anou Manavalan [mailto:amanaval@sybase.com] 
Sent: Monday, September 15, 2003 4:40 PM
To: juddi-developers@lists.sourceforge.net
Subject: RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER BY
columns to the result set


I changed this, even though this is not an ANSI std.  As I said earlier,
Cols in GROUP BY are the ones that needs to be in the select statement as
per ANSI std and not the ORDER BY.  But since it helps the xmlDB and I
didn't see any harm in adding that column, so added them as much as I can.

I also changed the getString("xyz") to getString(int).

If you could download the latest version from CVS and test it to make sure
it works, I will close the 2 bugs.

regards,
-Anou

-----Original Message-----
From: juddi-developers-admin@lists.sourceforge.net
[mailto:juddi-developers-admin@lists.sourceforge.net]On Behalf Of
SourceForge.net
Sent: Tuesday, September 09, 2003 3:23 AM
To: noreply@sourceforge.net
Subject: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER BY
columns to the result set


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


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
juddi-developers mailing list
juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
juddi-developers mailing list
juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers

[juddi-Developers] Test the latest

[Anou Manavalan <am...@sybase.com>]

Fixed a bug in the BusinessNameTable - so download the latest from CVS
before you test the ORDER BY and getString(int) changes.

thanks,
-Anou