Those aren't the actual SQL, those are the prepared statements.You need to look at the items from NHiberante.SQL logger
On Fri, May 22, 2009 at 6:06 PM, joelkeepup <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
