db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Trejkaz <trej...@trypticon.org>
Subject Re: Period in username when using a DataSource
Date Fri, 16 Dec 2011 07:16:26 GMT
On Fri, Dec 16, 2011 at 10:41 AM, Dag H. Wanvik <dag.wanvik@oracle.com> wrote:
> Trejkaz <trejkaz@trypticon.org> writes:
>
>> Yet Derby doesn't appear to be doing this.  Is this a bug?
>
> A username must be a valid SQL identifier in Derby. If you want to use
> "."  inside one, you need to quite it. In Java, "\"john.smith\"", in
> SQL, e.g in a GRANT statement: GRANT xxx TO "john.smith",
>
> Note that quoted identifier must have the correct case (case is
> significant then).

Yeah, I read about that, but the surprising thing to me is that I have
to quote it even when using a bean-like API which it seems should be
doing it for me...

But I guess as long as it will never start doing it, it's safe to
quote it myself.

TX

Mime
View raw message