You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by Andy Cutright <An...@borland.com> on 2003/09/15 16:28:02 UTC
RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER BYcolumns to the result set
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
RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER BYcolumns to the result set
Posted by Steve Viens <st...@viens.net>.
I'm going to move the jUDDI ddl's back to the juddi/ddl directory but
would everyone please make sure that the ddl they're most familiar with
is still working?
The juddi_mysql.ddl wasn't working for me because the INSERT TMODEL
statements didn't like the use of the 'getdate()' function to insert
into TIMESTAMP tables.
I also noticed one of the INSERT statement to the TMODEL_DESCRIPTION
table was attempting to insert a value that was too large for the
associated column (which makes MySQL barf). The insert in question had a
TMODEL key of: uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88. I simply
shortened the description by truncating everything after "Part 2:Country
subdivision codes.".
One last thing. The ddl for creating the MONITOR table had a syntax
error in each of the ddl files (the final column incuded a trialing
comma).
I've made the two fixes to the juddi_mysql.ddl and I've also made the
fix to the MONITOR table in each of the ddl files but it would be great
to be sure that the ddl to be included in the release will work.
Steve
-----Original Message-----
From: juddi-developers-admin@lists.sourceforge.net
[mailto:juddi-developers-admin@lists.sourceforge.net] On Behalf Of Andy
Cutright
Sent: Monday, September 15, 2003 5:27 PM
To: juddi-developers@lists.sourceforge.net
Subject: RE: [juddi-Developers] [ juddi-Bugs-803015 ] Adding the ORDER
BYcolumns to the result set
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
-------------------------------------------------------
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