You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by "Subrahmanya, Noida" <su...@noida.hcltech.com> on 2003/08/22 19:06:19 UTC
RE: [juddi-Developers] RE: updated src Unknown Source SaveBusines
sExample
Hi,
I am able to run all UDDI4 samples with totalXML database product with some
minor changes in juddi source. I would like to have these changes to juddi
source code. Mainly there are two types of changes. Details are given below,
1)The juddi code (for example in
org.juddi.datastore.jdbc.FindBusinessByNameQuery.java and other files as
well) use select statements like:
SELECT B.BUSINESS_KEY, ........, FROM BUSINESS_ENTITY
B,....................
When the result set is constructed, the column header will be
"B.BUSINESS_KEY" .
Later the code issues a getString("BUSINESS_KEY"); on the result set from
the query above.
We don't find the column, because the column name is B.BUSINESS_KEY .
That causes error like "Invalid attribute name: "BUSINESS_KEY"."
So code getString("BUSINESS_KEY"); should be changed to
getString("B.BUSINESS_KEY");
2) 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. So 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");
So it would be helpful to know where to send these changes and also the DDL
statement for TotalXML database product.
With Thanks and Regards,
B. Subrahmanya Nayak
Member Technical Staff,
HCL Technologies Ltd.,
-----Original Message-----
From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
Sent: Thursday, August 14, 2003 07:31 PM
To: 'juddi-developers@lists.sourceforge.net'
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
It might be beneficial for you to deploy jUDDI using one of the already
supported database products. If you can get jUDDI to function properly with
MySQL (or one of the others) then you can begin to isolate the issue with
your "totalxml" DB product.
Steve
> -----Original Message-----
> From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
> Sent: Friday, August 08, 2003 8:22 AM
> To: 'juddi-users@lists.sourceforge.net'
> Subject: RE: [juddi-Users] Unknown Source SaveBusinessExample
>
>
> I strongly believe that the message:
>
> Invalid attribute name: "BUSINESS_KEY"
>
> Is the message part of an exception that's coming from the
> JDBC Driver for
> "totalxml" database product you're using. You may want to confirm that
> you're Database is setup and configured properly. Most of the
> relational
> database drivers would report this stating something like:
>
> Invalid column name: "BUSINESS_KEY"
>
> Steve
-----Original Message-----
From: Anou Manavalan [mailto:amanaval@sybase.com]
Sent: Thursday, August 14, 2003 9:09 AM
To: juddi-developers@lists.sourceforge.net
Subject: [juddi-Developers] RE: updated src Unknown Source
SaveBusinessExample
Is the log4j in the debug mode and you still are not seeing any error in
the juddi log ? What is this uddi4j ( v2 beta ), I can't find any version
info in the one I am using ? is this different from what we have in juddi
lib directory ?
-Anou
-----Original Message-----
From: Subrahmanya, Noida [mailto:subrahmanya@noida.hcltech.com]
Sent: Thursday, August 14, 2003 5:27 AM
To: Anou Manavalan; juddi-developers@lists.sourceforge.net
Cc: Viens, Steve
Subject: RE: updated src Unknown Source SaveBusinessExample
Hi,
I am able to build the src sent by u. By using latest files i am getting
same problem ( i.e exception while finding service, bussiness, tmodel,
binding). But now it gives proper reason such as Invalid attribute name:
"BUSINESS_KEY". No more information from other log files such as juddi.log,
tomcat log etc.
Following are various example from uddi4j samples.
16:51 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
SaveBusinessExample
*********** Running SaveBusinessExample ***********
Get authtoken
Returned authToken:authToken:8C4ED4F0-CE49-11D7-94F0-C1E35831FE9B
Save 'Sample Business'
Returned businessKey:8CB537E0-CE49-11D7-B7E0-8AE0C0218CA6
Listing businesses starting with S after we publish
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at SaveBusinessExample.run(SaveBusinessExample.java:112)
at SaveBusinessExample.main(SaveBusinessExample.java:51)
16:52 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
SaveTModelExample
*********** Running SaveTModelExample ***********
Get authtoken
Returned authToken: authToken:95649390-CE49-11D7-9390-CAF7D8EE676B
Save 'Sample TModel'
TModel Saved: Sample TModel
TModel Key : uuid:95C7E940-CE49-11D7-A940-856497B8EA53
Find 'Sample TModel'
Invalid attribute name: "TMODEL_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.TModelList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_tModel(Unknown Source)
at SaveTModelExample.run(SaveTModelExample.java:103)
at SaveTModelExample.main(SaveTModelExample.java:50)
16:52 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
PublisherAssertionExample
*********** Running PublisherAssertionExample ***********
Get authtoken
Returned authToken:authToken:A79010D0-CE49-11D7-90D0-B7C58E3616FA
Saving one Business Entity for PublisherAssertion
Finding One Business Entity for PublisherAssertion
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at PublisherAssertionExample.run(PublisherAssertionExample.java:100)
at PublisherAssertionExample.main(PublisherAssertionExample.java:55)
16:52 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
BindingTemplateExample
*********** Running BindingTemplateExample ***********
Get authtoken
Returned authToken:authToken:CB713F10-CE49-11D7-BF10-E3732037099A
Saving a BindingTemplate
Returned BindingKey: CCFA01F0-CE49-11D7-81F0-BE4BE47A9C52
Finding the BindingTemplate saved
Invalid attribute name: "BINDING_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BindingDetail.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_binding(Unknown Source)
at BindingTemplateExample.run(BindingTemplateExample.java:175)
at BindingTemplateExample.main(BindingTemplateExample.java:54)
16:54 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
With Thanks and Regards,
B. Subrahmanya Nayak
> -----Original Message-----
> From: Anou Manavalan [mailto:amanaval@sybase.com]
> Sent: Wednesday, August 13, 2003 08:41 PM
> To: Subrahmanya, Noida
> Subject: updated src
>
> << File: src.zip >>
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
juddi-developers mailing list
juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
juddi-developers mailing list
juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
RE: [juddi-Developers] RE: updated src Unknown Source SaveBusines sExample
Posted by Steve Viens <st...@viens.net>.
Good idea Noida and Anou (good catch Noida)
+1 for changing all getXxx(String) calls to getXxx(int).
+1 for adding the ORDER BY columns to the result set.
(Noida, please submit this bug to the jUDDI Bug DB - the URL's are in
Anou's msg below)
Steve
-----Original Message-----
From: juddi-developers-admin@lists.sourceforge.net
[mailto:juddi-developers-admin@lists.sourceforge.net] On Behalf Of Anou
Manavalan
Sent: Friday, August 22, 2003 9:44 AM
To: juddi-developers@lists.sourceforge.net
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
This is interesting, could you test the code by changing the resultset
getString("B.BUSINESS_KEY") to take the column index instead of a name.
If that works, then we can change them to point to the index, since that
is more reliable and standard across all the DBs. I don't think
"B.BUSINESS_KEY" will normally work in other dbs.
I agree with this, since that is the ANSI std.
Here ORDER BY Column CATEGORY_ID is not one of selected column. So the
Code must be changed to contain ORDER BY Column CATEGORY_ID in select
clause as follows
sql.append("SELECT ");
You could submit this as a bug at http://sourceforge.net/projects/juddi
or http://sourceforge.net/tracker/?group_id=42875&atid=434422
regards,
-Anou
-----Original Message-----
From: Subrahmanya, Noida [mailto:subrahmanya@noida.hcltech.com]
Sent: Friday, August 22, 2003 1:48 AM
To: juddi-developers@lists.sourceforge.net
Cc: Stephen.Viens@FMR.COM; amanaval@sybase.com
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
Hi,
I am able to run all UDDI4 samples with totalXML database product with
some minor changes in juddi source. I would like to have these changes
to juddi source code. Mainly there are two types of changes. Details are
given below,
1)The juddi code (for example in
org.juddi.datastore.jdbc.FindBusinessByNameQuery.java and other files
as
well) use select statements like:
SELECT B.BUSINESS_KEY, ........, FROM BUSINESS_ENTITY
B,....................
When the result set is constructed, the column header will be
"B.BUSINESS_KEY" .
Later the code issues a getString("BUSINESS_KEY"); on the result set
from the query above.
We don't find the column, because the column name is B.BUSINESS_KEY .
That causes error like "Invalid attribute name: "BUSINESS_KEY"." So
code getString("BUSINESS_KEY"); should be changed to
getString("B.BUSINESS_KEY");
2) 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. So 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");
So it would be helpful to know where to send these changes and also the
DDL statement for TotalXML database product.
With Thanks and Regards,
B. Subrahmanya Nayak
Member Technical Staff,
HCL Technologies Ltd.,
-----Original Message-----
From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
Sent: Thursday, August 14, 2003 07:31 PM
To: 'juddi-developers@lists.sourceforge.net'
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
It might be beneficial for you to deploy jUDDI using one of the already
supported database products. If you can get jUDDI to function properly
with MySQL (or one of the others) then you can begin to isolate the
issue with your "totalxml" DB product.
Steve
> -----Original Message-----
> From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
> Sent: Friday, August 08, 2003 8:22 AM
> To: 'juddi-users@lists.sourceforge.net'
> Subject: RE: [juddi-Users] Unknown Source SaveBusinessExample
>
>
> I strongly believe that the message:
>
> Invalid attribute name: "BUSINESS_KEY"
>
> Is the message part of an exception that's coming from the JDBC Driver
> for "totalxml" database product you're using. You may want to confirm
> that you're Database is setup and configured properly. Most of the
> relational
> database drivers would report this stating something like:
>
> Invalid column name: "BUSINESS_KEY"
>
> Steve
-----Original Message-----
From: Anou Manavalan [mailto:amanaval@sybase.com]
Sent: Thursday, August 14, 2003 9:09 AM
To: juddi-developers@lists.sourceforge.net
Subject: [juddi-Developers] RE: updated src Unknown Source
SaveBusinessExample
Is the log4j in the debug mode and you still are not seeing any error
in the juddi log ? What is this uddi4j ( v2 beta ), I can't find any
version info in the one I am using ? is this different from what we
have in juddi lib directory ?
-Anou
-----Original Message-----
From: Subrahmanya, Noida [mailto:subrahmanya@noida.hcltech.com]
Sent: Thursday, August 14, 2003 5:27 AM
To: Anou Manavalan; juddi-developers@lists.sourceforge.net
Cc: Viens, Steve
Subject: RE: updated src Unknown Source SaveBusinessExample
Hi,
I am able to build the src sent by u. By using latest files i am getting
same problem ( i.e exception while finding service, bussiness, tmodel,
binding). But now it gives proper reason such as Invalid attribute name:
"BUSINESS_KEY". No more information from other log files such as
juddi.log, tomcat log etc. Following are various example from uddi4j
samples.
16:51 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tom
cat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomca
t-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.
jar"
SaveBusinessExample
*********** Running SaveBusinessExample ***********
Get authtoken
Returned authToken:authToken:8C4ED4F0-CE49-11D7-94F0-C1E35831FE9B
Save 'Sample Business'
Returned businessKey:8CB537E0-CE49-11D7-B7E0-8AE0C0218CA6
Listing businesses starting with S after we publish
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at SaveBusinessExample.run(SaveBusinessExample.java:112)
at SaveBusinessExample.main(SaveBusinessExample.java:51)
16:52 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tom
cat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomca
t-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.
jar"
SaveTModelExample
*********** Running SaveTModelExample ***********
Get authtoken
Returned authToken: authToken:95649390-CE49-11D7-9390-CAF7D8EE676B
Save 'Sample TModel'
TModel Saved: Sample TModel
TModel Key : uuid:95C7E940-CE49-11D7-A940-856497B8EA53
Find 'Sample TModel'
Invalid attribute name: "TMODEL_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.TModelList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_tModel(Unknown Source)
at SaveTModelExample.run(SaveTModelExample.java:103)
at SaveTModelExample.main(SaveTModelExample.java:50)
16:52 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tom
cat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomca
t-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.
jar"
PublisherAssertionExample
*********** Running PublisherAssertionExample ***********
Get authtoken
Returned authToken:authToken:A79010D0-CE49-11D7-90D0-B7C58E3616FA
Saving one Business Entity for PublisherAssertion
Finding One Business Entity for PublisherAssertion
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at
PublisherAssertionExample.run(PublisherAssertionExample.java:100)
at
PublisherAssertionExample.main(PublisherAssertionExample.java:55)
16:52 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tom
cat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomca
t-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.
jar"
BindingTemplateExample
*********** Running BindingTemplateExample ***********
Get authtoken
Returned authToken:authToken:CB713F10-CE49-11D7-BF10-E3732037099A
Saving a BindingTemplate
Returned BindingKey: CCFA01F0-CE49-11D7-81F0-BE4BE47A9C52
Finding the BindingTemplate saved
Invalid attribute name: "BINDING_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BindingDetail.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_binding(Unknown Source)
at BindingTemplateExample.run(BindingTemplateExample.java:175)
at BindingTemplateExample.main(BindingTemplateExample.java:54)
16:54 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
With Thanks and Regards,
B. Subrahmanya Nayak
> -----Original Message-----
> From: Anou Manavalan [mailto:amanaval@sybase.com]
> Sent: Wednesday, August 13, 2003 08:41 PM
> To: Subrahmanya, Noida
> Subject: updated src
>
> << File: src.zip >>
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01
/01
_______________________________________________
juddi-developers mailing list juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01
/01
_______________________________________________
juddi-developers mailing list juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
-------------------------------------------------------
This SF.net email is sponsored by: VM Ware
With VMware you can run multiple operating systems on a single machine.
WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the
same time. Free trial click here:http://www.vmware.com/wl/offer/358/0
_______________________________________________
juddi-developers mailing list juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
RE: [juddi-Developers] RE: updated src Unknown Source SaveBusines sExample
Posted by Anou Manavalan <am...@sybase.com>.
I forgot, actually GROUP BY is the one that needs the columns to be the
selected column or an aggregate function. But if it helps your DB, it
wouldn't hurt to add it as the selected column.
-----Original Message-----
From: Anou Manavalan [mailto:amanaval@sybase.com]
Sent: Friday, August 22, 2003 7:44 AM
To: juddi-developers@lists.sourceforge.net
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
This is interesting, could you test the code by changing the resultset
getString("B.BUSINESS_KEY") to take the column index instead of a name. If
that works, then we can change them to point to the index, since that is
more reliable and standard across all the DBs. I don't think
"B.BUSINESS_KEY" will normally work in other dbs.
I agree with this, since that is the ANSI std.
Here ORDER BY Column CATEGORY_ID is not one of selected column. So the Code
must be changed to contain ORDER BY Column CATEGORY_ID in select clause as
follows
sql.append("SELECT ");
You could submit this as a bug at http://sourceforge.net/projects/juddi or
http://sourceforge.net/tracker/?group_id=42875&atid=434422
regards,
-Anou
-----Original Message-----
From: Subrahmanya, Noida [mailto:subrahmanya@noida.hcltech.com]
Sent: Friday, August 22, 2003 1:48 AM
To: juddi-developers@lists.sourceforge.net
Cc: Stephen.Viens@FMR.COM; amanaval@sybase.com
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
Hi,
I am able to run all UDDI4 samples with totalXML database product with some
minor changes in juddi source. I would like to have these changes to juddi
source code. Mainly there are two types of changes. Details are given below,
1)The juddi code (for example in
org.juddi.datastore.jdbc.FindBusinessByNameQuery.java and other files as
well) use select statements like:
SELECT B.BUSINESS_KEY, ........, FROM BUSINESS_ENTITY
B,....................
When the result set is constructed, the column header will be
"B.BUSINESS_KEY" .
Later the code issues a getString("BUSINESS_KEY"); on the result set from
the query above.
We don't find the column, because the column name is B.BUSINESS_KEY .
That causes error like "Invalid attribute name: "BUSINESS_KEY"."
So code getString("BUSINESS_KEY"); should be changed to
getString("B.BUSINESS_KEY");
2) 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. So 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");
So it would be helpful to know where to send these changes and also the DDL
statement for TotalXML database product.
With Thanks and Regards,
B. Subrahmanya Nayak
Member Technical Staff,
HCL Technologies Ltd.,
-----Original Message-----
From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
Sent: Thursday, August 14, 2003 07:31 PM
To: 'juddi-developers@lists.sourceforge.net'
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
It might be beneficial for you to deploy jUDDI using one of the already
supported database products. If you can get jUDDI to function properly with
MySQL (or one of the others) then you can begin to isolate the issue with
your "totalxml" DB product.
Steve
> -----Original Message-----
> From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
> Sent: Friday, August 08, 2003 8:22 AM
> To: 'juddi-users@lists.sourceforge.net'
> Subject: RE: [juddi-Users] Unknown Source SaveBusinessExample
>
>
> I strongly believe that the message:
>
> Invalid attribute name: "BUSINESS_KEY"
>
> Is the message part of an exception that's coming from the
> JDBC Driver for
> "totalxml" database product you're using. You may want to confirm that
> you're Database is setup and configured properly. Most of the
> relational
> database drivers would report this stating something like:
>
> Invalid column name: "BUSINESS_KEY"
>
> Steve
-----Original Message-----
From: Anou Manavalan [mailto:amanaval@sybase.com]
Sent: Thursday, August 14, 2003 9:09 AM
To: juddi-developers@lists.sourceforge.net
Subject: [juddi-Developers] RE: updated src Unknown Source
SaveBusinessExample
Is the log4j in the debug mode and you still are not seeing any error in
the juddi log ? What is this uddi4j ( v2 beta ), I can't find any version
info in the one I am using ? is this different from what we have in juddi
lib directory ?
-Anou
-----Original Message-----
From: Subrahmanya, Noida [mailto:subrahmanya@noida.hcltech.com]
Sent: Thursday, August 14, 2003 5:27 AM
To: Anou Manavalan; juddi-developers@lists.sourceforge.net
Cc: Viens, Steve
Subject: RE: updated src Unknown Source SaveBusinessExample
Hi,
I am able to build the src sent by u. By using latest files i am getting
same problem ( i.e exception while finding service, bussiness, tmodel,
binding). But now it gives proper reason such as Invalid attribute name:
"BUSINESS_KEY". No more information from other log files such as juddi.log,
tomcat log etc.
Following are various example from uddi4j samples.
16:51 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
SaveBusinessExample
*********** Running SaveBusinessExample ***********
Get authtoken
Returned authToken:authToken:8C4ED4F0-CE49-11D7-94F0-C1E35831FE9B
Save 'Sample Business'
Returned businessKey:8CB537E0-CE49-11D7-B7E0-8AE0C0218CA6
Listing businesses starting with S after we publish
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at SaveBusinessExample.run(SaveBusinessExample.java:112)
at SaveBusinessExample.main(SaveBusinessExample.java:51)
16:52 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
SaveTModelExample
*********** Running SaveTModelExample ***********
Get authtoken
Returned authToken: authToken:95649390-CE49-11D7-9390-CAF7D8EE676B
Save 'Sample TModel'
TModel Saved: Sample TModel
TModel Key : uuid:95C7E940-CE49-11D7-A940-856497B8EA53
Find 'Sample TModel'
Invalid attribute name: "TMODEL_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.TModelList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_tModel(Unknown Source)
at SaveTModelExample.run(SaveTModelExample.java:103)
at SaveTModelExample.main(SaveTModelExample.java:50)
16:52 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
PublisherAssertionExample
*********** Running PublisherAssertionExample ***********
Get authtoken
Returned authToken:authToken:A79010D0-CE49-11D7-90D0-B7C58E3616FA
Saving one Business Entity for PublisherAssertion
Finding One Business Entity for PublisherAssertion
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at PublisherAssertionExample.run(PublisherAssertionExample.java:100)
at PublisherAssertionExample.main(PublisherAssertionExample.java:55)
16:52 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
BindingTemplateExample
*********** Running BindingTemplateExample ***********
Get authtoken
Returned authToken:authToken:CB713F10-CE49-11D7-BF10-E3732037099A
Saving a BindingTemplate
Returned BindingKey: CCFA01F0-CE49-11D7-81F0-BE4BE47A9C52
Finding the BindingTemplate saved
Invalid attribute name: "BINDING_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BindingDetail.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_binding(Unknown Source)
at BindingTemplateExample.run(BindingTemplateExample.java:175)
at BindingTemplateExample.main(BindingTemplateExample.java:54)
16:54 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
With Thanks and Regards,
B. Subrahmanya Nayak
> -----Original Message-----
> From: Anou Manavalan [mailto:amanaval@sybase.com]
> Sent: Wednesday, August 13, 2003 08:41 PM
> To: Subrahmanya, Noida
> Subject: updated src
>
> << File: src.zip >>
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
juddi-developers mailing list
juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
juddi-developers mailing list
juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
RE: [juddi-Developers] RE: updated src Unknown Source SaveBusines sExample
Posted by Anou Manavalan <am...@sybase.com>.
This is interesting, could you test the code by changing the resultset
getString("B.BUSINESS_KEY") to take the column index instead of a name. If
that works, then we can change them to point to the index, since that is
more reliable and standard across all the DBs. I don't think
"B.BUSINESS_KEY" will normally work in other dbs.
I agree with this, since that is the ANSI std.
Here ORDER BY Column CATEGORY_ID is not one of selected column. So the Code
must be changed to contain ORDER BY Column CATEGORY_ID in select clause as
follows
sql.append("SELECT ");
You could submit this as a bug at http://sourceforge.net/projects/juddi or
http://sourceforge.net/tracker/?group_id=42875&atid=434422
regards,
-Anou
-----Original Message-----
From: Subrahmanya, Noida [mailto:subrahmanya@noida.hcltech.com]
Sent: Friday, August 22, 2003 1:48 AM
To: juddi-developers@lists.sourceforge.net
Cc: Stephen.Viens@FMR.COM; amanaval@sybase.com
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
Hi,
I am able to run all UDDI4 samples with totalXML database product with some
minor changes in juddi source. I would like to have these changes to juddi
source code. Mainly there are two types of changes. Details are given below,
1)The juddi code (for example in
org.juddi.datastore.jdbc.FindBusinessByNameQuery.java and other files as
well) use select statements like:
SELECT B.BUSINESS_KEY, ........, FROM BUSINESS_ENTITY
B,....................
When the result set is constructed, the column header will be
"B.BUSINESS_KEY" .
Later the code issues a getString("BUSINESS_KEY"); on the result set from
the query above.
We don't find the column, because the column name is B.BUSINESS_KEY .
That causes error like "Invalid attribute name: "BUSINESS_KEY"."
So code getString("BUSINESS_KEY"); should be changed to
getString("B.BUSINESS_KEY");
2) 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. So 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");
So it would be helpful to know where to send these changes and also the DDL
statement for TotalXML database product.
With Thanks and Regards,
B. Subrahmanya Nayak
Member Technical Staff,
HCL Technologies Ltd.,
-----Original Message-----
From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
Sent: Thursday, August 14, 2003 07:31 PM
To: 'juddi-developers@lists.sourceforge.net'
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
It might be beneficial for you to deploy jUDDI using one of the already
supported database products. If you can get jUDDI to function properly with
MySQL (or one of the others) then you can begin to isolate the issue with
your "totalxml" DB product.
Steve
> -----Original Message-----
> From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
> Sent: Friday, August 08, 2003 8:22 AM
> To: 'juddi-users@lists.sourceforge.net'
> Subject: RE: [juddi-Users] Unknown Source SaveBusinessExample
>
>
> I strongly believe that the message:
>
> Invalid attribute name: "BUSINESS_KEY"
>
> Is the message part of an exception that's coming from the
> JDBC Driver for
> "totalxml" database product you're using. You may want to confirm that
> you're Database is setup and configured properly. Most of the
> relational
> database drivers would report this stating something like:
>
> Invalid column name: "BUSINESS_KEY"
>
> Steve
-----Original Message-----
From: Anou Manavalan [mailto:amanaval@sybase.com]
Sent: Thursday, August 14, 2003 9:09 AM
To: juddi-developers@lists.sourceforge.net
Subject: [juddi-Developers] RE: updated src Unknown Source
SaveBusinessExample
Is the log4j in the debug mode and you still are not seeing any error in
the juddi log ? What is this uddi4j ( v2 beta ), I can't find any version
info in the one I am using ? is this different from what we have in juddi
lib directory ?
-Anou
-----Original Message-----
From: Subrahmanya, Noida [mailto:subrahmanya@noida.hcltech.com]
Sent: Thursday, August 14, 2003 5:27 AM
To: Anou Manavalan; juddi-developers@lists.sourceforge.net
Cc: Viens, Steve
Subject: RE: updated src Unknown Source SaveBusinessExample
Hi,
I am able to build the src sent by u. By using latest files i am getting
same problem ( i.e exception while finding service, bussiness, tmodel,
binding). But now it gives proper reason such as Invalid attribute name:
"BUSINESS_KEY". No more information from other log files such as juddi.log,
tomcat log etc.
Following are various example from uddi4j samples.
16:51 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
SaveBusinessExample
*********** Running SaveBusinessExample ***********
Get authtoken
Returned authToken:authToken:8C4ED4F0-CE49-11D7-94F0-C1E35831FE9B
Save 'Sample Business'
Returned businessKey:8CB537E0-CE49-11D7-B7E0-8AE0C0218CA6
Listing businesses starting with S after we publish
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at SaveBusinessExample.run(SaveBusinessExample.java:112)
at SaveBusinessExample.main(SaveBusinessExample.java:51)
16:52 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
SaveTModelExample
*********** Running SaveTModelExample ***********
Get authtoken
Returned authToken: authToken:95649390-CE49-11D7-9390-CAF7D8EE676B
Save 'Sample TModel'
TModel Saved: Sample TModel
TModel Key : uuid:95C7E940-CE49-11D7-A940-856497B8EA53
Find 'Sample TModel'
Invalid attribute name: "TMODEL_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.TModelList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_tModel(Unknown Source)
at SaveTModelExample.run(SaveTModelExample.java:103)
at SaveTModelExample.main(SaveTModelExample.java:50)
16:52 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
PublisherAssertionExample
*********** Running PublisherAssertionExample ***********
Get authtoken
Returned authToken:authToken:A79010D0-CE49-11D7-90D0-B7C58E3616FA
Saving one Business Entity for PublisherAssertion
Finding One Business Entity for PublisherAssertion
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at PublisherAssertionExample.run(PublisherAssertionExample.java:100)
at PublisherAssertionExample.main(PublisherAssertionExample.java:55)
16:52 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tomcat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomcat-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.jar"
BindingTemplateExample
*********** Running BindingTemplateExample ***********
Get authtoken
Returned authToken:authToken:CB713F10-CE49-11D7-BF10-E3732037099A
Saving a BindingTemplate
Returned BindingKey: CCFA01F0-CE49-11D7-81F0-BE4BE47A9C52
Finding the BindingTemplate saved
Invalid attribute name: "BINDING_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BindingDetail.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_binding(Unknown Source)
at BindingTemplateExample.run(BindingTemplateExample.java:175)
at BindingTemplateExample.main(BindingTemplateExample.java:54)
16:54 [vc32] G:\Installs\Web Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
With Thanks and Regards,
B. Subrahmanya Nayak
> -----Original Message-----
> From: Anou Manavalan [mailto:amanaval@sybase.com]
> Sent: Wednesday, August 13, 2003 08:41 PM
> To: Subrahmanya, Noida
> Subject: updated src
>
> << File: src.zip >>
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
juddi-developers mailing list
juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
juddi-developers mailing list
juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
RE: [juddi-Developers] RE: updated src Unknown Source SaveBusines sExample
Posted by Steve Viens <st...@viens.net>.
Nodia (hopefully I've got your fist name correct)
You can send your TotalXML DDL to this list.
Steve
-----Original Message-----
From: juddi-developers-admin@lists.sourceforge.net
[mailto:juddi-developers-admin@lists.sourceforge.net] On Behalf Of
Subrahmanya, Noida
Sent: Friday, August 22, 2003 3:48 AM
To: juddi-developers@lists.sourceforge.net
Cc: Stephen.Viens@FMR.COM; amanaval@sybase.com
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
Hi,
I am able to run all UDDI4 samples with totalXML database product with
some minor changes in juddi source. I would like to have these changes
to juddi source code. Mainly there are two types of changes. Details are
given below,
1)The juddi code (for example in
org.juddi.datastore.jdbc.FindBusinessByNameQuery.java and other files
as
well) use select statements like:
SELECT B.BUSINESS_KEY, ........, FROM BUSINESS_ENTITY
B,....................
When the result set is constructed, the column header will be
"B.BUSINESS_KEY" .
Later the code issues a getString("BUSINESS_KEY"); on the result set
from the query above.
We don't find the column, because the column name is B.BUSINESS_KEY .
That causes error like "Invalid attribute name: "BUSINESS_KEY"." So
code getString("BUSINESS_KEY"); should be changed to
getString("B.BUSINESS_KEY");
2) 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. So 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");
So it would be helpful to know where to send these changes and also the
DDL statement for TotalXML database product.
With Thanks and Regards,
B. Subrahmanya Nayak
Member Technical Staff,
HCL Technologies Ltd.,
-----Original Message-----
From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
Sent: Thursday, August 14, 2003 07:31 PM
To: 'juddi-developers@lists.sourceforge.net'
Subject: RE: [juddi-Developers] RE: updated src Unknown Source
SaveBusines sExample
It might be beneficial for you to deploy jUDDI using one of the already
supported database products. If you can get jUDDI to function properly
with MySQL (or one of the others) then you can begin to isolate the
issue with your "totalxml" DB product.
Steve
> -----Original Message-----
> From: Viens, Steve [mailto:Stephen.Viens@FMR.COM]
> Sent: Friday, August 08, 2003 8:22 AM
> To: 'juddi-users@lists.sourceforge.net'
> Subject: RE: [juddi-Users] Unknown Source SaveBusinessExample
>
>
> I strongly believe that the message:
>
> Invalid attribute name: "BUSINESS_KEY"
>
> Is the message part of an exception that's coming from the
> JDBC Driver for
> "totalxml" database product you're using. You may want to confirm that
> you're Database is setup and configured properly. Most of the
> relational
> database drivers would report this stating something like:
>
> Invalid column name: "BUSINESS_KEY"
>
> Steve
-----Original Message-----
From: Anou Manavalan [mailto:amanaval@sybase.com]
Sent: Thursday, August 14, 2003 9:09 AM
To: juddi-developers@lists.sourceforge.net
Subject: [juddi-Developers] RE: updated src Unknown Source
SaveBusinessExample
Is the log4j in the debug mode and you still are not seeing any error
in the juddi log ? What is this uddi4j ( v2 beta ), I can't find any
version info in the one I am using ? is this different from what we
have in juddi lib directory ?
-Anou
-----Original Message-----
From: Subrahmanya, Noida [mailto:subrahmanya@noida.hcltech.com]
Sent: Thursday, August 14, 2003 5:27 AM
To: Anou Manavalan; juddi-developers@lists.sourceforge.net
Cc: Viens, Steve
Subject: RE: updated src Unknown Source SaveBusinessExample
Hi,
I am able to build the src sent by u. By using latest files i am getting
same problem ( i.e exception while finding service, bussiness, tmodel,
binding). But now it gives proper reason such as Invalid attribute name:
"BUSINESS_KEY". No more information from other log files such as
juddi.log, tomcat log etc. Following are various example from uddi4j
samples.
16:51 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tom
cat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomca
t-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.
jar"
SaveBusinessExample
*********** Running SaveBusinessExample ***********
Get authtoken
Returned authToken:authToken:8C4ED4F0-CE49-11D7-94F0-C1E35831FE9B
Save 'Sample Business'
Returned businessKey:8CB537E0-CE49-11D7-B7E0-8AE0C0218CA6
Listing businesses starting with S after we publish
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at SaveBusinessExample.run(SaveBusinessExample.java:112)
at SaveBusinessExample.main(SaveBusinessExample.java:51)
16:52 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tom
cat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomca
t-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.
jar"
SaveTModelExample
*********** Running SaveTModelExample ***********
Get authtoken
Returned authToken: authToken:95649390-CE49-11D7-9390-CAF7D8EE676B
Save 'Sample TModel'
TModel Saved: Sample TModel
TModel Key : uuid:95C7E940-CE49-11D7-A940-856497B8EA53
Find 'Sample TModel'
Invalid attribute name: "TMODEL_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.TModelList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_tModel(Unknown Source)
at SaveTModelExample.run(SaveTModelExample.java:103)
at SaveTModelExample.main(SaveTModelExample.java:50)
16:52 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tom
cat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomca
t-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.
jar"
PublisherAssertionExample
*********** Running PublisherAssertionExample ***********
Get authtoken
Returned authToken:authToken:A79010D0-CE49-11D7-90D0-B7C58E3616FA
Saving one Business Entity for PublisherAssertion
Finding One Business Entity for PublisherAssertion
Invalid attribute name: "BUSINESS_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BusinessList.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_business(Unknown Source)
at
PublisherAssertionExample.run(PublisherAssertionExample.java:100)
at
PublisherAssertionExample.main(PublisherAssertionExample.java:55)
16:52 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
java -classpath ".;G:\Installs\Installs\temp\we
b services\axis-1_1rc2-src\axis-1_1RC2\lib\axis.jar;G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\lib\uddi4j.jar;G:
\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\axis.jar;G:\jakarta-tom
cat-
4.1.24\webapps\tuddi\WEB-INF\lib\saaj.jar;G:\jak
arta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\jaxrpc.jar;G:\jakarta-tomca
t-4.
1.24\webapps\tuddi\WEB-INF\lib\commons-logging.j
ar;G:\jakarta-tomcat-4.1.24\webapps\tuddi\WEB-INF\lib\commons-discovery.
jar"
BindingTemplateExample
*********** Running BindingTemplateExample ***********
Get authtoken
Returned authToken:authToken:CB713F10-CE49-11D7-BF10-E3732037099A
Saving a BindingTemplate
Returned BindingKey: CCFA01F0-CE49-11D7-81F0-BE4BE47A9C52
Finding the BindingTemplate saved
Invalid attribute name: "BINDING_KEY".
at org.uddi4j.UDDIElement.<init>(Unknown Source)
at org.uddi4j.response.BindingDetail.<init>(Unknown Source)
at org.uddi4j.client.UDDIProxy.find_binding(Unknown Source)
at BindingTemplateExample.run(BindingTemplateExample.java:175)
at BindingTemplateExample.main(BindingTemplateExample.java:54)
16:54 [vc32] G:\Installs\Web
Services\docs\uddi4j-bin-v2beta\uddi4j\samples>
With Thanks and Regards,
B. Subrahmanya Nayak
> -----Original Message-----
> From: Anou Manavalan [mailto:amanaval@sybase.com]
> Sent: Wednesday, August 13, 2003 08:41 PM
> To: Subrahmanya, Noida
> Subject: updated src
>
> << File: src.zip >>
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01
/01
_______________________________________________
juddi-developers mailing list juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01
/01
_______________________________________________
juddi-developers mailing list juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers
-------------------------------------------------------
This SF.net email is sponsored by: VM Ware
With VMware you can run multiple operating systems on a single machine.
WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the
same time. Free trial click here:http://www.vmware.com/wl/offer/358/0
_______________________________________________
juddi-developers mailing list juddi-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-developers