What database are you running NPetShop against? NPetShop has been neglected for a while. I think NPetShop2:
http://svn.apache.org/repos/asf/ibatis/trunk/cs/npetshop2/ is more up to date. What does your log4net config file/section look like? This is wrong: [assembly: log4net.Config.DOMConfigurator( ConfigFile="NPetshop.Web.dll.config",Watch=true )] The config file for every ASP.Net application is Web.config. ASP.Net automatically puts a file watch on the Web.config file. If the log4net node is inside the Web.config file, this is what you'd call to configure log4net: [assembly: log4net.Config.DOMConfigurator()] --- Ling Wang <[EMAIL PROTECTED]> wrote: > Hi there, > > I ran NPetShop out of box and got an sql exception > "Data type mismatch in criteria" when I tried to > register a new user (I did not create any new code, > the original code uses "InsertProfile"). I would like > to see the sql statement. I searched the mail archive > and found a suggestion using > GetMappedStatement("InsertProfile"). I tried and got > an message: > > MappedStatement: InsertProfile > InsertProfile-InLineParameterMap > > which is not I am looking for. > > I then tried to configure log4net following the > documentation. Hoping to get the SQL statement that > way. I tried almost everything including adding > log4net config info to the web.config or using its > own config file by setting or withoug setting: > > [assembly: log4net.Config.DOMConfigurator( > ConfigFile="NPetshop.Web.dll.config",Watch=true )] > > I still did not see any log.txt file. > > Can anyone help me out? > > Thanks. > > Ling >

