db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: SQL Exception: Database 'Test' not found
Date Wed, 18 Jul 2007 15:23:43 GMT
> name (Test) is correct. Is there a way to setup the persistence provider 
> so that it can insert double quotes around both the connection string 
> and all query strings? 

You'll have better luck asking on the persistence provider's mailing lists.
Some readers of this list are expert in some persistence providers, but in
general the discussions on this list are about the core Derby database itself.

> If the database name is ALL in uppercase then 
> there is no problem, however it appears as though additional problems 
> can occur if non uppercase names are used for tables, databases, columns 
> etc with any persistence provider .

Yes, this is true. If you decide to use case-sensitive names for tables
and columns, you have to be very careful to use those case-sensitive
names throughout your application, which means always enclosing the
table or column name in double quotes, in the exactly-right case, and
this is indeed very tricky if you are using libraries of code which
generate SQL on your behalf.

Case-sensitive schema names are certainly valid, and work just fine in
Derby, but you will find it simpler to build your application if you
can avoid them.



View raw message