Bryan Pendleton wrote:
> Sunitha Kambhampati wrote: > >> If I try to connect, the error thrown is >> ij> connect >> 'jdbc:derby:testdb;create=true;[EMAIL PROTECTED];password=a'; >> ERROR 28502: The user name '[EMAIL PROTECTED]' 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, [EMAIL PROTECTED] is not a valid SQL identifier. You could treat them as delimited identifiers... meaning '[EMAIL PROTECTED]', but that has its own issues.. User names need to be case insensitive. Satheesh
