db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: SQLException Table does not exist although just created
Date Tue, 15 Dec 2009 14:08:14 GMT
Hi Bill,

You need to use double-quotes rather than single-quotes. See the 
following section in the Derby Reference Guide: 
http://db.apache.org/derby/docs/10.5/ref/ref-single.html#crefsqlj34834

Hope this helps,
-Rick

Wildman wrote:
> Thanks, Rick -- that is indeed quite helpful.
>
> I am a bit unsure of how to specify the table name so that it retains
> lower-case. If I quote the name when creating the table; e.g. "create table
> 'part_type' ( .... )" then I get a SQL error complaining about the quotes.
> Is there another way to specify a table name including casing?
>
> Thanks!
> -Bill
>
>   


Mime
View raw message