That question comes up a lot, you can log the actual query if you switch
log4j logging on (see documentation) but
a) I wouldn't know a easy way to get the query back to your code
b) The query is parameterized, the parameter values are in the log
Meaning you can get the query string like
select sequenceId,
name,
lastname,
mobileNo,
from mytable where
Id=?);
What is send to the JDBC layer
-----Original Message-----
From: suprememenu [mailto:shaik...@gmail.com]
Sent: 28 January 2010 01:05 PM
To: user-java@ibatis.apache.org
Subject: how to write Sql query in system out or to a log using ibatis?
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
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2650 - Release Date: 01/27/10
21:36:00
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
