Re: Views and dynamic queries

2006-03-30 Thread Jeff Butler
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Frequently+Asked+Questions   Jeff Butler  On 3/30/06, Chema <[EMAIL PROTECTED]> wrote: 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

Re: Views and dynamic queries

2006-03-30 Thread Chema
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 fromoracle often indicates a comma in the wrong place or parenthesis that isunmatched.  I would use your logs to see exactly what sql you'

Re: Views and dynamic queries

2006-03-29 Thread Diran Ayandele
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 cara

Re: Views and dynamic queries

2006-03-29 Thread Chema
Not, it isn'tThe name is VIEW_JOB  ( but the table name is FUTURE_JOB and works fine )2006/3/29, Larry Meadors <[EMAIL PROTECTED] >:Does the view name have a # or $ character in it?LarryOn 3/29/06, Chema < [EMAIL PROTECTED]> wrote:>  Hello:>> I've got this query in sqlmap config file>> > parameterC

Re: Views and dynamic queries

2006-03-29 Thread Larry Meadors
Does the view name have a # or $ character in it? Larry On 3/29/06, Chema <[EMAIL PROTECTED]> wrote: > Hello: > > I've got this query in sqlmap config file > > parameterClass="QueryClass"> > SELECT $c$ > FROM $table$ > WHERE $where$ > > > > > If $table$ is the n

Views and dynamic queries

2006-03-29 Thread Chema
 Hello:I've got this query in sqlmap config file      SELECT     $c$       FROM     $table$      WHERE     $where$    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 advanceBest regards