ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <Larry.Mead...@plumcreek.com>
Subject Re: Should this cause problems?
Date Mon, 06 Dec 2004 20:18:52 GMT
What happens if you run the sql in sqlplus with the space? Does it work
there?

What change precipitated this error? New driver? server? java version?
iBATIS version?

Larry

>>> Nathan Maves <Nathan.Maves@Sun.COM> 12/06/04 1:08 PM >>>
Here is the old sqlmap ...

<statement id="getPeriodsList" resultMap="periodsResult">
        SELECT to_char(day_date,'YYYY MM (MON)') as stringValue,
               min(trunc(day_date, 'MON')) as dateValue
        FROM financial_dates
        WHERE (trunc(Day_Date) >= 
trunc(add_months(last_day(sysdate),- #value#))+1
          AND trunc(Day_Date) <= trunc(add_months(sysdate,0)))
        GROUP BY to_char(day_date,'YYYY MM (MON)')
        ORDER BY 2
     </statement>

When run,  this above will hang.

DEBUG 12-06 10:41:22 {conn-100282} Connection  
(ConnectionLogProxy.java:42)
DEBUG 12-06 10:41:22 {pstm-100283} PreparedStatement:         SELECT 
to_char(day_date,'YYYY MM (MON)') as stringValue,                
min(trunc(day_date, 'MON')) as dateValue        FROM financial_dates    
      WHERE (trunc(Day_Date) >= trunc(add_months(last_day(sysdate),- 
?))+1          AND trunc(Day_Date) <= trunc(add_months(sysdate,0)))     
    GROUP BY to_char(day_date,'YYYY MM (MON)')         ORDER BY 2       
(PreparedStatementLogProxy.java:48)
DEBUG 12-06 10:41:22 {pstm-100283} Parameters: [12]  
(PreparedStatementLogProxy.java:49)
DEBUG 12-06 10:41:22 {pstm-100283} Types: [java.lang.String]  
(PreparedStatementLogProxy.java:50)

Nothing ever is returned.

We found that by removing the space after the minus sign "-#value#" 
everything worked perfectly.  This used to work for the last year and 
just recently start failing.

We are using Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

nathan



Mime
View raw message