ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chema <chemago...@gmail.com>
Subject Re: Views and dynamic queries
Date Wed, 29 Mar 2006 16:18:15 GMT
Not, it isn't

The name is VIEW_JOB  ( but the table name is FUTURE_JOB and works fine )




2006/3/29, Larry Meadors <lmeadors@apache.org>:
>
> Does the view name have a # or $ character in it?
>
> Larry
>
>
> On 3/29/06, Chema <chemagogia@gmail.com> wrote:
> >  Hello:
> >
> > I've got this query in sqlmap config file
> >
> > <select remapResults ="true" id="getValue" resultClass="java.lang.Object
> "
> > parameterClass="QueryClass">
> >       SELECT     $c$
> >       FROM     $table$
> >       WHERE     $where$
> >  </select>
> >
> >
> >
> > If $table$ is the name of a view , this error happens:
> > ORA-00921: unexpected end of SQL command
> >
> > If $table$ is the name of a table, all works fine
> >
> > why ?
> >
> > Thanks in advance
> >
> > Best regards
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>

Mime
View raw message