turn on sql logging ?

realien · **Posted:** Mon May 22, 2006 11:59 pm

I'm trying to diagnose a odd exception in my application :

Code:

2006-05-22 23:34:26,765 [4652] ERROR NHibernate.ADOException [(null)] <(null)> - Could not execute query
System.Data.SqlClient.SqlException: Invalid object name 'PageItemType'.

and I've validated that the PageItemType is a valid object :)

So I'm now trying to see the sql that nhibernate is producing but my log does not appear to be logging sql, I have the log level set to DEBUG.

My other nhibernate apps are just webapps using nhibernate, this application is a DLL using nhibernate and the webapp references it, are there any gotchas I should be looking for ?

Thanks
Grant

sergey · **Posted:** Tue May 23, 2006 8:07 am

Since this is an SQL Server error, make sure you have the table named PageItemType.

SQL is logged to NHibernate.SQL log4net logger. You can also set hibernate.show_sql to true to log SQL to System.Console.

realien · **Posted:** Tue May 23, 2006 9:03 am

Thanks, I do have a table called PageItemType which is whats throwing me off :) I used puzzle.net object mapper to create my hbm file and I normally do it by hand so I'm running through now trying to figure out what the hell I'm doing wrong :)

It looks like I was mistaken about logging, my logging is working with log4net but I'm not getting any logging out of hibernate and I have the log level set at DEBUG. I've forced log4net to intialize in the Application_Start using log4net.Config.XmlConfigurator.Configure(); but this is in my webapp and nhibernate is being used in my dll, does this make a difference ?

I do see a repository being created in the output console :

Code:

og4net: DefaultRepositorySelector: Creating repository for assembly [NHibernate, Version=1.0.2.0, Culture=neutral, PublicKeyToken=154fdcb44c4484fc]
log4net: DefaultRepositorySelector: Assembly [NHibernate, Version=1.0.2.0, Culture=neutral, PublicKeyToken=154fdcb44c4484fc] Loaded From [c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net files\ilearnwebapp\cb2e936e\71e9225d\assembly\dl2\1a367256\00f17686_fd19c601\nhibernate.dll]
log4net: DefaultRepositorySelector: Assembly [NHibernate, Version=1.0.2.0, Culture=neutral, PublicKeyToken=154fdcb44c4484fc] does not have a RepositoryAttribute specified.
log4net: DefaultRepositorySelector: Assembly [NHibernate, Version=1.0.2.0, Culture=neutral, PublicKeyToken=154fdcb44c4484fc] using repository [log4net-default-repository] and repository type [log4net.Repository.Hierarchy.Hierarchy]
log4net: DefaultRepositorySelector: repository [log4net-default-repository] already exists, using repository type [log4net.Repository.Hierarchy.Hierarchy]

but nhibnerate is not debugging logging to it.

realien · **Posted:** Tue May 23, 2006 10:08 am

I'm an idiot, figured it out. Have too many open projects and was editing the wrong web.config :) Sorry guys, I'll go stand in the corner and you can throw vegetables at me :)