juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Geir Magnusson Jr <g...@4quarters.com>
Subject Re: caseSensitiveMatch ?
Date Sun, 13 Feb 2005 01:27:01 GMT

On Feb 11, 2005, at 5:13 PM, Viens, Stephen wrote:

> Probably not ... There's still work to be done in/around the use of
> findQualifiers in jUDDI.

Well, I traced it down to the fact that I am using MySQL, which doesn't 
actually do SQL, but something sorta like it.

So the fix is to change the DDL for MySQL to require that searches are 
binary - this was a quickie 'let me try it to see if I can make sure 
Scout is ok' - and I don't know the implications of doing this beyond 
this, but the patch is :

Index: create_database.sql
===================================================================
RCS file: /home/cvspublic/ws-juddi/sql/mysql/create_database.sql,v
retrieving revision 1.4
diff -r1.4 create_database.sql
58c58
<   NAME VARCHAR(255) NOT NULL,
---
 >   NAME VARCHAR(255) BINARY NOT NULL,
187c187
<   NAME VARCHAR(255) NOT NULL,
---
 >   NAME VARCHAR(255) BINARY NOT NULL,


which is changing the create table for BUSINESS_NAME and SERVICE_NAME 
to make the NAME field 'binary'.

I'm going to port the DDL to Derby, and offer that to the project.  
We'll be hanging jUDDI onto Geronimo as our UDDI registry, and we'll 
just use the internal Derby database by default.  The bonus is that 
Derby implements SQL :)

geir

>
> Steve
>
> -----Original Message-----
> From: Geir Magnusson Jr. [mailto:geirm@apache.org]
> Sent: Friday, February 11, 2005 4:26 PM
> To: juddi-dev@ws.apache.org
> Subject: caseSensitiveMatch ?
>
>
> I'm doing findService() with a "caseSensitiveMatch" findQualifier.
>
> I get back stuff that doesn't match - it would if it were
> caseINsensitive, but ...
>
> Am I doing something wrong?
>
> -- 
> Geir Magnusson Jr                                  +1-203-665-6437
> geirm@apache.org
>
>
-- 
Geir Magnusson Jr                                  +1-203-665-6437
geirm@apache.org


Mime
View raw message