Thank you all again for your suggestions. One of the use cases of mine is to create an XML in the end. I don't have an object serve as a middle stage to use with Rowhandler (in RowHandler's term, I need to map the valueObject to something, right?). I also did read some post posted by someone a couple of years ago. I didn't think that fits my needs. what I need is that my final XML should have structure, not flat (i.e. not to simply convert each row into XML format). Therefore, I need to check each field/column to determine what tag I should give when I loop. I think this is better and easily done if I loop through my resultSet row by row and check each field/column by field/column. How can rowhandler help me to look into columns? I do use iBatis for other sql/object mapping and it works out great. As I mentioned in my earlier post, I certainly didn't want to move some special SQLs somewhere else so I thought there might be a way to get my SQLs out from sqlMap.xml and use them by spring JDBC instead. The other use case is that I need to generate some report, which is also very convenient to just loop through resultSet without introducing the middle layer object/list (rowHandler might be helpful in that case, but I have to evaluate further...)Thank you -Rick
> Date: Mon, 10 Mar 2008 06:23:24 -0600> From: [EMAIL PROTECTED]> To: > [email protected]> Subject: Re: Retrieve the SQL statement being > executed> > Depending on your iBATIS version, I think you can get to what > you> want, but it is pretty fragile, because you have to do some casting to> > internal classes which could change.> > I think your safest bet is the > RowHandler or a stored procedure - and> I say stored procedure only because > it sounds like you need to process> a lot of data for just a little bit of > information. If that is the> case, a SP will kick butt over everything else > in terms of both memory> footprint and performance.> > Larry> > > On Sun, Mar > 9, 2008 at 8:44 PM, Ricky Murphy <[EMAIL PROTECTED]> wrote:> >> > Thank you > for your reply. Well, I have no problem doing log activity. let me> > > elaborate what I want to do. I have a SQLMap file which contains all my SQLs> > > maps related to the same domain. In one case, I need to use ResultSet> > > directly and not need iBatis. However, I want to keep all domain related> > > SQLs in the same place. In iBatis, it seems there is no decent way to> > > handle this (RowHandler seems to get the result up in memory (i,e, after> > > data is obtained, the db connection is closed) first, then I can treat each> > > row as a object. I don't want to go that extra step. To work with each row> > > in ResultSet seemed to be efficient to me without extra steps. This is the> > > only SQL that does not need iBatis. However, in order to keep all SQL maps> > > that tackle the same domain of problems together, I want to put this > special> > SQL together with sqlMaps together in the same XML file. Because > this, I> > want sqlMapClient to somehow read the SQL and then in my code > retrieve the> > SQL and execute it with Spring jdbcTemplate to get my > resultSet. I hope that> > I explained clearly.> >> > iBatis has a session > scope, and requestScope objects that seem to be OK to> > get the SQL > statement. however, they are protect method and not open to> > public. > Therefore, I am trying to see if there is any way to get that SQL> > before > it is executed.> >> > -Rick> >> > ________________________________> > From: > [EMAIL PROTECTED]> > To: [email protected]> > Subject: Re: Retrieve > the SQL statement being executed> > Date: Sat, 8 Mar 2008 07:33:38 -0700> >> > >> >> > Please take a look at the logging section in one of the following 3> > > places...> >> > The website> > The developers guide> > The book> >> > Sent > from my iPhone> >> > On Mar 8, 2008, at 5:55 AM, Ricky Murphy <[EMAIL > PROTECTED]> wrote:> >> >> >> > Hello:> >> > I am using Spring 2 together with > iBatis 2.2. I need in my program to> > retrieve the SQL statement being > executed from the SqlMap.> >> > Spring's SqlMapClientDaoSupport class has > getSqlMapClient() ,which gives> > com.ibatis.sqlmap.client.SqlMapClient as a > result object, from there on, I> > started searching thru all related the > iBatis classes, haven't found one> > method that will return the SQL > statement being executed. Please advise.> >> > Thank you.> >> > -Rick> >> >> > > ________________________________> > Connect and share in new ways with > Windows Live. Get it n> > ________________________________> > Climb to the > top of the charts! Play the word scramble challenge with star> > power. Play > now! _________________________________________________________________ Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/
