Okay, drop a note if this fix does the trick so that the change is made to the MySQL DDL.
Thanks. Steve -----Original Message----- From: Geir Magnusson Jr [mailto:[EMAIL PROTECTED] Sent: Sunday, February 13, 2005 12:16 PM To: [email protected] Subject: Re: caseSensitiveMatch ? 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:[EMAIL PROTECTED] > Sent: Saturday, February 12, 2005 8:27 PM > To: [email protected] > 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:[EMAIL PROTECTED] >> Sent: Friday, February 11, 2005 4:26 PM >> To: [email protected] >> 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 >> [EMAIL PROTECTED] >> >> > -- > Geir Magnusson Jr +1-203-665-6437 > [EMAIL PROTECTED] > > > -- Geir Magnusson Jr +1-203-665-6437 [EMAIL PROTECTED]
