Hi all. If I do this (using version 10.8.2.2):
ClientConnectionPoolDataSource ds = new ClientConnectionPoolDataSource(); ds.setServerName("derby"); ds.setPortNumber(2000); ds.setDatabaseName("db"); ds.setUser("john.smith"); This eventually results in an error on the server side: ERROR 28502: The user name 'john.smith' is not valid. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:286) at org.apache.derby.iapi.util.IdUtil.getUserAuthorizationId(IdUtil.java:570) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.initialize(GenericLanguageConnectionContext.java:381) at org.apache.derby.impl.db.BasicDatabase.setupConnection(BasicDatabase.java:295) After a bit of research, I read that usernames with a dot are fine in a database *URL* as long as you quote them. But I'm *not* using a URL here, I'm using a setter on a bean. So I would be expecting the library to properly quote a string if it deems that the value I passed in needs it. Yet Derby doesn't appear to be doing this. Is this a bug? TX