Thanks, I added:
<logger name="NHibernate">
<level value="WARN" />
</logger>
<logger name="NHibernate.SQL">
<level value="ALL" />
</logger>
and I get just what I want (the sql) per link from Mauricio, just
missed that part the first time.
thanks
Joel
On May 22, 1:12 pm, Ayende Rahien <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
