Use something like log4j and add something like this to your log4j.xml.
<logger name="java.sql">
<level value="debug" />
</logger>
You will get something like this:
java.sql.PreparedStatement - {pstm-100028} Executing Statement:
SELECT * FROM EMP WHERE EMPNAME = ?
java.sql.PreparedStatement - {pstm-100028} Parameters: [BOB]
java.sql.PreparedStatement - {pstm-100028} Types: [java.lang.String]
System.out.println should be avoided.
-----Original Message-----
From: suprememenu [mailto:[email protected]]
Sent: Thursday, January 28, 2010 5:05 AM
To: [email protected]
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-u
sing-ibatis--tp27354226p27354226.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
