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 17:16:22 GMT

On Feb 13, 2005, at 11:20 AM, Steve Viens wrote:

> Geir,
>
> Will this MySQL DDL fix still allow for case-incensitive matching?

it should.  Given that SQL is case sensitive, we'll just setup the SQL 
in jUDDI to use the standard patten (UPPERCASE() ?) and then try and 
rig MySQL to behave as normal as possible.

geir

>
> Steve
>
> -----Original Message-----
> From: Geir Magnusson Jr [mailto:geir@4quarters.com]
> Sent: Saturday, February 12, 2005 8:27 PM
> To: juddi-dev@ws.apache.org
> Subject: Re: caseSensitiveMatch ?
>
>
>
> 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
>
>
>
-- 
Geir Magnusson Jr                                  +1-203-665-6437
geir@gluecode.com


Mime
View raw message