db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Accept username of form xyz@somedomain.com
Date Sat, 11 Feb 2006 08:25:05 GMT


Bryan Pendleton wrote:

> Sunitha Kambhampati wrote:
>
>> If I try to connect, the error thrown is
>>    ij> connect
>> 'jdbc:derby:testdb;create=true;user=skambha@xyz.com;password=a';
>>    ERROR 28502: The user name 'skambha@xyz.com' is not valid.
>
>
> Is the string that we pass to "connect" an URL? If so, does it
> need to satisfy the URL character set requirements of RFC 1738:
> http://www.rfc-editor.org/rfc/rfc1738.txt

Also this authorizationID is currently used as SQL identifier. According
to ANSI, SQL identifiers can only have alphabets, digits and underscore.
That is why there seems to be that check. So, skamba@xyz.com is not a
valid SQL identifier.

You could treat them as delimited identifiers... meaning
'skamba@xyz.com', but that has its own issues.. User names need to be
case insensitive.

Satheesh


Mime
View raw message