Re: Passing date as string to IBATIS.

[Andrey Rogov]

and here I pass String

select count(*) as count
  from projects.documents d
where to_char( d.created, 'dd Mon yy' ) = to_char(#created#)  or

select count(*) as count
  from projects.documents d
where to_char( d.created, 'dd Mon yy' ) = #created#

DEBUG [http-8080-Processor24] java.sql.Connection debug- {conn-100003}
Connection
DEBUG [http-8080-Processor24] java.sql.PreparedStatement debug-
{pstm-100004} PreparedStatement:                select count(*) as
count             from projects.documents d            where to_char(
d.created, 'dd Mon yy' ) =
to_char(?)

DEBUG [http-8080-Processor24] java.sql.PreparedStatement debug-
{pstm-100004} Parameters: [28 Фев 08]
DEBUG [http-8080-Processor24] java.sql.PreparedStatement debug-
{pstm-100004} Types: [java.lang.String]
DEBUG [http-8080-Processor24] java.sql.ResultSet debug- {rset-100005}
ResultSet
DEBUG [http-8080-Processor24] java.sql.ResultSet debug- {rset-100005}
Header: [COUNT]
DEBUG [http-8080-Processor24] java.sql.ResultSet debug- {rset-100005}
Result: [2]

iBatis works great .