And how I can to log the iBatis query generated ?
2006/3/29, Diran Ayandele <[EMAIL PROTECTED]>:
This is probably a syntax error in your sql. That error message from
oracle often indicates a comma in the wrong place or parenthesis that is
unmatched. I would use your logs to see exactly what sql you're sending
to your database. Or else run your statements using sqlplus to see a
nice carat under the exact syntax problem.
Diran
Chema wrote:
>
> Not, it isn't
>
> The name is VIEW_JOB ( but the table name is FUTURE_JOB and works fine )
>
>
>
>
> 2006/3/29, Larry Meadors <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>>:
>
> Does the view name have a # or $ character in it?
>
> Larry
>
>
> On 3/29/06, Chema < [EMAIL PROTECTED]
> <mailto: [EMAIL PROTECTED]>> 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
