select
Id as "id",
Code as "code",
TypeStr as "typeStr"
from MyTable
On Wed, Mar 24, 2010 at 10:30 PM, Pavel Bortnovskiy
<pbortnovs...@jefferies.com> wrote:
>
> Hello, all:
>
> when executing a statement, such as:
>
> select
> Id as id,
> Code as code,
> TypeStr as typeStr
> from MyTable
>
> against a Derby in-memory table, the ResultSetMetaData present column names
> all in upper case and the original case is not preserved.
>
> Is there a setting which would allow to preserve the case specified in the
> SQL statement, i.e. with the statement above, the first column would be
> "id", second - "code", third - "typeStr", etc...
>
> Thank you,
>
> Pavel.
>
>
>
> Jefferies archives and monitors outgoing and incoming e-mail. The contents
> of this email, including any attachments, are confidential to the ordinary
> user of the email address to which it was addressed. If you are not the
> addressee of this email you may not copy, forward, disclose or otherwise use
> it or any part of it in any form whatsoever. This email may be produced at
> the request of regulators or in connection with civil litigation. Jefferies
> accepts no liability for any errors or omissions arising as a result of
> transmission. Use by other than intended recipients is prohibited. In the
> United Kingdom, Jefferies operates as Jefferies International Limited;
> registered in England: no. 1978621; registered office: Vintners Place, 68
> Upper Thames Street, London EC4V 3BJ. Jefferies International Limited is
> authorised and regulated by the Financial Services Authority.
