[juddi-Developers] RE: Changes

[Steve Viens <st...@inflexionpoint.com>]

Thanks Lance,

I like what you've sent and have already committed it to jUDDI-0.6.2
(fairly new CVS module). I've also created a UDDI4jProxy.java which
simply extends the UDDIProxy class so that I/we might be able to include
additional functionality to UDDI4j's standard UDDIProxy later (e.g.
logging).

The 0.6.2 version will be the one that is announced in the
SourceForge.net Java Foundry newsletter (soon). Also, it'll be the first
version available for download in 'war' file format.

Steve

Steve Viens
jUDDI Project Manager
sviens@users.sourceforge.net
http://www.juddi.org

-----Original Message-----
From: lance.waterman@new-era-of-networks.com
[mailto:lance.waterman@new-era-of-networks.com] 
Sent: Monday, December 02, 2002 10:11 AM
To: steve@inflexionpoint.com
Subject: RE: Changes



Steve,

Here are some of the classes I developed to help use JUDDI from a direct
client.

(See attached file: UDDIProxyFactory.java)(See attached file:
JUDDIProxy.java)

Please let me know if you have other thoughts.

Lance



 

                    Steve Viens

                    <steve@inflexion       To:     "Waterman, Lance"
<La...@New-Era-of-Networks.com>        
                    point.com>             cc:

                                           Subject:     RE: Changes

                    11/26/2002 10:40

                    AM

                    Please respond

                    to steve

 

 




Lance, I've taken a look at your list below ... Great feedback - thank
you. Here's some info related to a few of your items.

1. We originally had explicitly set this value to either NULL or NOT
NULL - not certain why this changed but I'll look into it. If there's no
issue then I'll do as you suggest.

2. Good catch - this was a bug. You'll notice in the juddi.ddl that
these column lengths were correctly set to 41 (I'm somewhat surprised
MySQL and HSQL didn't kick this out).

3. Anou also had to do this (of course - you're both working with ASA)
... The group-by was left over from some SQL experimentation when the
FindXxxxx services were being implemented. Since she hasn't seen a
problem after removing these in almost two months I doubt there's an
issue.  They will be removed from CVS as well.

4. That must have been a lot of work! I remember the issue you've
mentioned with the jConnect driver (I worked in a Sybase shop for 9
years). I'll take a closer look and do probably do likewise.

Please do forward on your JUDDIProxy class (and others). I'll take a
look at the attached org.juddi.service source you've sent along over the
next couple of days.

Steve

Steve Viens
jUDDI Project Manager
sviens@users.sourceforge.net
http://www.juddi.org


-----Original Message-----
From: lance.waterman@new-era-of-networks.com
[mailto:lance.waterman@new-era-of-networks.com]
Sent: Monday, November 25, 2002 5:30 PM
To: steve@inflexionpoint.com
Subject: Changes


Steve,

I thought I would forward some of the changes I made to get your
feedback. Please let me know if I am off base on these:

1) Ran into a problem with NULL column values in ASA. If you don't
explicitly specify the NULL or NOT NULL within the create table column
definition a database level default is used. It would be nice to add the
NULL qualifier within the create table code. I have attached a list
where I have added it.

2) Changed the length of the BUSINESS_KEY column for
BusinessCategoryTable and BusinessIdentifierTable ( 255 --> 41 ). ASA
requires that the signature of the key in a foreign/primary relationship
be identical.

3) Took out the group by clause in select statements. ASA requires all
select columns ( non-aggregated ) must participate in the group by
clause. Not sure what the ramifications of this will be?

4) Added a .trim() to the DB columns that allow nulls and have some type
of standard format. (i.e. LANG_CODE ). For some reason the Sybase JDBC
driver returns a string with one space for columns that contain an empty
string. I could be that empty strings should not even be pushed into the
DB at save.

5) See attached for a list of changes to Service classes.

I also have a set of changes that allow JUDDI to be deployed from and
run within the context of a .war file. This includes a new
DataStoreFactory that obtains a connection from the containers
DataSource object. I also have a JUDDIProxy that extends UDDIProxy (
along with a UDDIProxyFactory that creates the appropriate instance from
properties file ). Let me know if you would be interested in looking at
these and I would be happy to forward them along.

Lance Waterman
Sybase - eBD

(See attached file: serviceUpdates.htm)(See attached file: Changes to
tables.htm)(See attached file: FindTModelService.java)(See attached
file: SaveTModelService.java)(See attached file:
SaveBusinessService.java)(See attached file:
SaveServiceService.java)(See attached file:
SaveBindingService.java)