ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tom Henricksen" <T...@A-t-g.com>
Subject RE: how to write Sql query in system out or to a log using ibatis?
Date Thu, 28 Jan 2010 13:33:34 GMT
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:shaikhid@gmail.com] 
Sent: Thursday, January 28, 2010 5:05 AM
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-u
sing-ibatis--tp27354226p27354226.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


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


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


Mime
View raw message