Return-Path: 
 <user-java-return-18576-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 96525 invoked from network); 28 Jan 2010 11:05:02 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 28 Jan 2010 11:05:02 -0000
Received: (qmail 56776 invoked by uid 500); 28 Jan 2010 11:05:01 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 56736 invoked by uid 500); 28 Jan 2010 11:05:01 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 56728 invoked by uid 99); 28 Jan 2010 11:05:01 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Jan 2010 11:05:01 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Jan 2010 11:04:53 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1NaSAr-0004wf-3G
	for user-java@ibatis.apache.org; Thu, 28 Jan 2010 03:04:33 -0800
Message-ID: <27354226.post@talk.nabble.com>
Date: Thu, 28 Jan 2010 03:04:33 -0800 (PST)
From: suprememenu <shaikhid@gmail.com>
To: user-java@ibatis.apache.org
Subject: how to write Sql query in system out or to a log using ibatis?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: shaikhid@gmail.com


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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org