On Fri, Dec 16, 2011 at 10:41 AM, Dag H. Wanvik <dag.wan...@oracle.com> wrote: > Trejkaz <trej...@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
