ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: Should this cause problems?
Date Mon, 06 Dec 2004 20:48:57 GMT
Larry,

Not sure of what change precipitated the error.  We did install the 
latest ibatis about two weeks ago.  We are just not sure if that new 
version was pushed to production at that point.

The space works fine in sqlplus.  In fact it works perfect with the sql 
genterated by ibatis logging.

No changes in java version, server version or drivers.

Nathan

On Dec 6, 2004, at 1:18 PM, Larry Meadors wrote:

> 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