That worked .
Thanks a lot !!
Pat
Larry Meadors wrote:
>
> Since you scrub the input by doing this:
>
> params.put("duration",new Integer(duration));
>
> You are pretty safe to do this:
>
> where (INSERTTIME >= CURRENT_TIMESTAMP - $duration$ MINUTES)
>
> That'll work.
>
> Larry
>
>
I agree - of all the jdbc drivers I have ever used, DB2 is the only
one that supports this.
Larry
On Wed, Feb 27, 2008 at 8:45 AM, Jeff Butler <[EMAIL PROTECTED]> wrote:
> This seems like an obvious error in iBATIS to me. I made the change and ran
> the build - the tests all passed.
>
> Unless
This seems like an obvious error in iBATIS to me. I made the change and ran
the build - the tests all passed.
Unless anyone has a strong objection, I'll commit the change.
Thanks to Rikki for doing the diagnosis on this!
Jeff Butler
On Wed, Feb 27, 2008 at 7:43 AM, Niels Beekman <[EMAIL PROT
I think that this affects the aliasing of columns, which would be bad
IMHO. But the javadoc of getColumnLabel says:
"Gets the designated column's suggested title for use in printouts and
displays."
This would mean that it's perfectly valid to call getColumnName, maybe
someone with more JDBC
Since you scrub the input by doing this:
params.put("duration",new Integer(duration));
You are pretty safe to do this:
where (INSERTTIME >= CURRENT_TIMESTAMP - $duration$ MINUTES)
That'll work.
Larry
On Wed, Feb 27, 2008 at 2:18 AM, apinke <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I am
Hi,
I think that you have to indicate the type of data, like this
#cod_cia:VARCHAR#
2008/2/27, Rikki Bindra <[EMAIL PROTECTED]>:
>
>
> Hi,
>
> I am using the jt400.jar as the JDBC Driver for accessing data from DB2
> database on AS400. The problem is that I want to use implicit resultmap like
>
Hi,
I am using the jt400.jar as the JDBC Driver for accessing data from DB2
database on AS400. The problem is that I want to use implicit resultmap
like
select * from PRODUCT
However, the problem is that while populating the HashMap, I have noticed
that the class "com.ibatis.sqlmap.engine.
I will be out of the office starting 27/02/2008 and will not return until
28/02/2008.
I will respond to your message when I return. For urgent issues, contact
WebSphere Support group.
Hi All,
I am using DB2 with IBatis and facing a problem in creating a where
condition which uses CURRENT_TIMESTAMP
The SQL that works :
Select sum(TOTAL),code from ORDER_DATA
where (INSERTTIME >= CURRENT_TIMESTAMP - 30 MINUTES)
group by code
I am trying to parametrize the value in minutes.
I
