juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Viens" <st...@viens.net>
Subject RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER BY columns to the result set
Date Sat, 20 Sep 2003 17:30:17 GMT
There isn't (that I know of).

I think if you run a text search through the "org.juddi.datastore.jdbc"
package for "ORDER BY" you'll get an idea of how many queries were
affected.

Steve

-----Original Message-----
From: juddi-developers-admin@lists.sourceforge.net
[mailto:juddi-developers-admin@lists.sourceforge.net] On Behalf Of Andy
Cutright
Sent: Saturday, September 20, 2003 12:52 PM
To: juddi-developers@lists.sourceforge.net
Subject: RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER
BY columns to the result set


is there a simple test case for this? 

> -----Original Message-----
> From: Steve Viens [mailto:steve@viens.net]
> Sent: Thursday, September 18, 2003 6:43 PM
> To: 'Glenn Bullock'; juddi-developers@lists.sourceforge.net
> Subject: FW: [juddi-Developers] [ juddi-Bugs-803015 ] Adding 
> the ORDER BY columns to the result set
> 
> 
> 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=80
> 3015&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=8
> 03015&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=8
03015&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






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