juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Cutright" <Andy.Cutri...@borland.com>
Subject RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER BYcolumns to the result set
Date Mon, 15 Sep 2003 14:28:02 GMT
yes, i was thinking much the same thing :) 

cheers,
andy 

> -----Original Message-----
> From: Viens, Steve [mailto:Stephen.Viens@FMR.COM] 
> Sent: Monday, September 15, 2003 2:22 PM
> To: 'juddi-developers@lists.sourceforge.net'
> Subject: RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding 
> the ORDER BYcolumns 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&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=8
03015&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


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