juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Viens" <st...@viens.net>
Subject FW: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER BY columns to the result set
Date Fri, 19 Sep 2003 16:08:41 GMT
Glenn, would you be willing/able to test these jUDDI DataStore changes
with your PostgreSQL DDL for us?

The ornginal bug# is 803015

http://sourceforge.net/tracker/?func=detail&atid=434422&aid=803015&group
_id=42875

Steve

-----Original Message-----
From: juddi-developers-admin@lists.sourceforge.net
[mailto:juddi-developers-admin@lists.sourceforge.net] On Behalf Of
Viens, Steve
Sent: Monday, September 15, 2003 5:22 PM
To: 'juddi-developers@lists.sourceforge.net'
Subject: RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER
BY columns to the result set


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&grou
p_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&grou
p_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


-------------------------------------------------------
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






Mime
View raw message