commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Ash <stevem...@gmail.com>
Subject Re: [dbutils]
Date Tue, 21 Dec 2010 17:31:08 GMT
Nikhil,

This is an oracle syntax problem, not a DbUtils problem.  Oracle
doesn't support "as" to alias names in the projection list.  Try
SELECT USER_ID user, USER_NAME name FROM T_USER_MSTR

Steve

On Tue, Dec 21, 2010 at 7:14 AM, Nikhil <bhatnagar.nikhil@gmail.com> wrote:
> Hi,
>
>
>
> I am new to DbUtils, I tried it and found it very helpful.
>
>
>
> But now I am having problem in executing queries that have alias name
>
>
>
> e.g. SELECT USER_ID as user, USER_NAME as name FROM T_USER_MSTR
>
>
>
> When I run my program I get error shown below:
>
>
>
> java.sql.SQLException: ORA-00923: FROM keyword not found where expected
>
>  Query: SELECT USER_ID as user, USER_NAME as name FROM T_USER_MSTR
> Parameters: []
>
>
>
> Please help me
>
>
>
>
>
> Thanks,
>
> Nikhil
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org


Mime
View raw message