Thanks, I needed to config log4net, now that I have done I see lines like this:
2009-05-22 13:01:43,144 [8] INFO NHibernate.Loader.Loader - SELECT this_.ListItemId as ListItemId0_0_, this_.SiteId as SiteId0_0_, this_.ListId as ListId0_0_, this_.Id as Id0_0_, this_.CreatedAt as CreatedAt0_0_, this_.ModifiedAt as ModifiedAt0_0_, this_.Tags as Tags0_0_, this_.SiteCollection as SiteColl8_0_0_, this_.DataTypeId as DataTypeId0_0_, this_.IsPrivate as IsPrivate0_0_, this_.Title as Title0_0_, this_.Body as Body0_0_, this_.Expires as Expires0_0_ FROM arAnnouncement this_ WHERE this_.SiteId = @p0 and this_.ListId = @p1 2009-05-22 13:01:54,881 [8] INFO NHibernate.Loader.Loader - SELECT this_.ListItemId as ListItemId0_0_, this_.SiteId as SiteId0_0_, this_.ListId as ListId0_0_, this_.Id as Id0_0_, this_.CreatedAt as CreatedAt0_0_, this_.ModifiedAt as ModifiedAt0_0_, this_.Tags as Tags0_0_, this_.SiteCollection as SiteColl8_0_0_, this_.DataTypeId as DataTypeId0_0_, this_.IsPrivate as IsPrivate0_0_, this_.Title as Title0_0_, this_.Body as Body0_0_, this_.Expires as Expires0_0_ FROM arAnnouncement this_ WHERE this_.SiteId = @p0 and this_.ListId = @p1 2009-05-22 13:01:54,941 [8] INFO NHibernate.Loader.Loader - SELECT this_.ListItemId as ListItemId0_0_, this_.SiteId as SiteId0_0_, this_.ListId as ListId0_0_, this_.Id as Id0_0_, this_.CreatedAt as CreatedAt0_0_, this_.ModifiedAt as ModifiedAt0_0_, this_.Tags as Tags0_0_, this_.SiteCollection as SiteColl8_0_0_, this_.DataTypeId as DataTypeId0_0_, this_.IsPrivate as IsPrivate0_0_, this_.Title as Title0_0_, this_.Body as Body0_0_, this_.Expires as Expires0_0_ FROM arAnnouncement this_ WHERE this_.SiteId = @p0 and this_.ListId = @p1 How can I get it to show the values of @p1 and @p0? thanks Joel On May 21, 5:08 pm, Mauricio Scheffer <[email protected]> wrote: > Enable > log4net:http://nhforge.org/wikis/howtonh/configure-log4net-for-use-with-nhibe... > > You could also use the SQL Server Profiler. > > On May 21, 4:32 pm, joelkeepup <[email protected]> wrote: > > > HI, is there a simple way I can see the sql my active record calls > > generate? > > > I tried: > > > <activerecord isWeb="false" isDebug="true"> > > <config> > > <add key="hibernate.connection.driver_class" > > value="NHibernate.Driver.SqlClientDriver" /> > > <add key="hibernate.dialect" > > value="NHibernate.Dialect.MsSql2005Dialect" /> > > <add key="hibernate.show_sql" value="true" /> > > <add key="hibernate.connection.provider" > > value="NHibernate.Connection.DriverConnectionProvider" /> > > <add key="hibernate.connection.connection_string" value="Data > > Source=.;Initial Catalog=ContentStoreGlobal;Integrated Security=True" / > > > </config> > > </activerecord> > > > In my web.config, but didnt seem to do anything. > > > thanks > > Joel --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Development List" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-devel?hl=en -~----------~----~----~----~------~----~------~--~---
