ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: Are there any ways to view the SQL mapping statements?
Date Thu, 16 Dec 2004 20:58:17 GMT
You could use logging to view your sql statement and the parameters it
is receiving. But, there is no simple way to view the sql statement
combined with your parameters. IBatis uses PreparedStatement
underneath and there is no way to view the compiled sql statement in
java. There is a section in the User Guide that explains how to log
your SQL

On Thu, 16 Dec 2004 14:25:08 -0500, Lucy Fang <fang@acs.rutgers.edu> wrote:
> Hi, 
> Are there any ways I can view the SQL mapping statements after created a
> dynamic SQL statement and passed all of parameters to it?
> I have a dynamic SQL mapping statement with 
>         select * from campus where campuscode in #campusCode# 
> if I use campuscode in (03,04), it works good. But if I use the parameter
> campusCode replace the value, it doesn't work. I pretty sure the parameter
> value is "(03,04)".
> The database I am using is Oracle and iBatis is SQL Map 2.0. 
> Thanks. 
> Lucy

View raw message