hi all,
       Can anyone can guide me how can i write the sql query in system.out?

This query is in a.xml file

 <select id="getDetailsId" resultClass="Trans" parameterClass="string">
        select sequenceId, 
        name,
        lastname,
        mobileNo, 
         from mytable  where
        Id=#Id# 
  </select>

when i call this query i need to write to the System.out the executing of
the query 

for 

System.out("The executing query is "+ 
select sequenceId, 
        name,
        lastname,
        mobileNo, 
         from mytable  where
        Id=25662);


when i use in normal jdbc connection

like for ex 
sql="select sequenceId, 
        name,
        lastname,
        mobileNo, 
         from mytable  where
        Id="+<%=id%>

System.out("The executing query is "+ sql);
rs.executeQuery(sql)

 
I tried to system.out to just know the query before executing .
-- 
View this message in context: 
http://old.nabble.com/how-to-write-Sql-query-in-system-out-or-to-a-log-using-ibatis--tp27354226p27354226.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org

Reply via email to