IBatisNet has had this feature for quite some time (sorry for the line wrapping):
DEBUG 2005-09-12 06:03:31 PM (Commands.DefaultPreparedCommand:138) - Statement Id: [User.Authenticate] PreparedStatement : [SELECT UserId, Login, Password, Name, EmailAddress, LastLogin, DateAdded, DateLastUpdated FROM [User] WHERE Login = ? AND Password = ?] DEBUG 2005-09-12 06:03:31 PM (Commands.DefaultPreparedCommand:138) - Statement Id: [User.Authenticate] Parameters: [param0=[Login,ron], param1=[Password,45798F269709550D6F6E1D2CF4B7D485]] DEBUG 2005-09-12 06:03:31 PM (Commands.DefaultPreparedCommand:138) - Statement Id: [User.Authenticate] Types: [param0=[String, System.String], param1=[String, System.String]] In fact there's even code in SVN to display results sent back from the database before IBatisNet processes the result set. Its still buggy though (uses to many system resources ???). It sounds like your log4net is not being initialized correctly. To debug that problem, we need to see log4net's internal debug messages (probably being written to log4net.txt). FYI, 45798F269709550D6F6E1D2CF4B7D485 is just "ron": http://gdataonline.com/ --- Ling Wang <[EMAIL PROTECTED]> wrote: > Ron, > > Yes, it is the version I am trying. It runs ok untill > registering new users. I am ok with it even with the > bugs. My problem is how am I supposed to debug it if I > do not see my sql statement? > > Be nice if you can turn on log4net together with other > means to show sql statement. I am sure there are many > users how are interested in seeing this. > > Thanks. > > Ling > > --- Ron Grabowski <[EMAIL PROTECTED]> wrote: > > > Are you using the "NPetShop Example Application" > > from this page: > > > > http://ibatis.apache.org/downloads.html > > > > That was compiled 10/4/2004 and aside from being > > close to a year old, > > its at least 3 versions behind of the current > > version in SVN. > > > > Unfortunetly the version of NPetShop in SVN isn't as > > up to date as it > > should be. I think a quick recompile and a > > double-check of the mapping > > files could fix that. I'll look into doing that (at > > least for MySQL and > > Access)... > > > > --- Ling Wang <[EMAIL PROTECTED]> wrote: > > > > > I am getting an error fresh out of box and just > > could > > > not figure out what is wrong. I got an error > > saying > > > > > > Error executing query 'InsertProfile' for insert. > > > Cause: Data type mismatch in criteria expression. > > > > > > when I was registering a new user. > > > > > > Everything else seems to work. > > > > > > I am using the npetshop.mdb database. > > > > > > Thanks. > > > > > > Ling > > > > > > > > >
