Hi,
after a long time i've a question i can't solve on my own.
First i'm sorry about the length of this post, but i need some words to explain the situation.
We've build an application to manage meta data in our data warehouse. I have decided to use NHibernate 1.2.1. I hope the this fact doesn't matter cause the problem seems to be in the mapping files (shown later in this post).
We use three different mapping documents. One for the dwh meta data, one for a tree view (this mapping document is only a lighweight of the dwh meta data mapping document) and one for reference objects (database objects read out of the system catalog).
We use Ms Sql Server 2005 Sp1 as our database engine.
Now we encounter heavy performance issues in due to work with our application. I think this is an configuration problem of our hibernate configuration file and/or our mapping files.
Each client open multiple sessions and hold it until he close the application. We use one session for the dwh meta data, tree view meta data and multiple sessions for reference data (one session for each database which is used as a reference database because ms sql server has a database specific object catalog for concrete database objects).
We using our own data access class to encapsulate nhibernate from the business layer. But we dont use this class to much. In each mapping document exist one or few "top level objects" we must query for. Other mapped classes are members of these classes and can be accessed through the top level class.
In each mapping document the top level class is the first mapped class. Except in the reference mapping. There is the ReferenceSchema the top level class.
NHibernate configuration
Code:
<?xml version='1.0' encoding='utf-8'?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<!-- properties -->
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
<property name="hibernate.cache.provider_class">NHibernate.Caches.SysCache2.SysCacheProvider, NHibernate.Caches.SysCache2, Version=1.2.1.4000, Culture=neutral, PublicKeyToken=aa95f207798dfdb4</property>
<property name="hibernate.cache.use_query_cache">true</property>
<property name="hibernate.cache.use_structured_entries">true</property>
</session-factory>
</hibernate-configuration>
First the reference mapping. Its used to read existing database object which can be meta data (converting such data is handled in the business layer). For each database one session is used with the reference mapping (because the structure of the ms sql catalog).
The mapping file cause no performance problems.
Reference mappingCode:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="DaveMdm.Bl, Version=1.0.0.0, Culture=neutral, PublicKeyToken=5f30d2ae8e3baa9f" namespace="RaconWest.DWH.davemdm.bl.reference" default-lazy="true">
<!-- Mapping for ReferenceDatabase -->
<class name="ReferenceDatabase" schema="master.sys" table="databases" mutable="false">
<id name="IdentCode" column="database_id" type="Int32">
<generator class="identity"/>
</id>
<property name="Name" column="`name`" type="String" not-null="true" />
<property name="Collation" column="collation_name" type="String" not-null="true" />
</class>
<!-- Mapping for ReferenceSchema -->
<class name="ReferenceSchema" schema="sys" table="schemas" mutable="false">
<id name="IdentCode" column="schema_id" type="Int32">
<generator class="identity" />
</id>
<property name="IdentCode" column="schema_id" type="Int32" not-null="true" />
<property name="Name" column="`name`" type="String" not-null="true" />
<!-- ReferenceTables -->
<bag name="ReferenceTables" fetch="join" where="`type` IN ('U ','V ','IF')" outer-join="true">
<key column="schema_id" />
<one-to-many class="ReferenceTableBase" not-found="ignore"/>
</bag>
<!-- ReferenceProcedures -->
<bag name="ReferenceProcedures" fetch="join" outer-join="true">
<key column="schema_id" />
<one-to-many class="ReferenceProcedure" not-found="ignore" />
</bag>
</class>
<!-- Mapping for ReferenceProcedure -->
<class name="ReferenceProcedure" schema="sys" table="procedures" mutable="false">
<id name="IdentCode" column="object_id" type="Int32">
<generator class="identity" />
</id>
<property name="IdentCode" column="object_id" type="Int32" not-null="true" />
<property name="Name" column="`name`" type="String" not-null="true" />
<many-to-one not-found="ignore" name="ReferenceSchema" class="ReferenceSchema" column="schema_id" outer-join="true" fetch="join" />
<!-- ReferenceParameter -->
<bag name="ReferenceParameters" fetch="join">
<key column="object_id" />
<one-to-many class="ReferenceParameter" not-found="ignore" />
</bag>
</class>
<!-- Mapping for ReferenceParameter -->
<class name="ReferenceParameter" schema="sys" table="parameters" mutable="false">
<composite-id>
<key-property name="IdentCode" column="parameter_id" type="Int32" />
<key-property name="ReferenceProcedureId" column="object_id" type="Int32" />
</composite-id>
<property name="Name" column="`name`" type="String" not-null="true" />
<property name="MaxLength" column="max_length" type="Int32" not-null="true" />
<property name="Scale" column="scale" type="Int32" />
<property name="Precision" column="precision" type="Int32" />
<many-to-one not-found="ignore" name="ReferenceType" fetch="join" outer-join="true">
<column name="system_type_id" />
<column name="user_type_id" />
</many-to-one>
<many-to-one not-found="ignore" name="ReferenceProcedure" column="object_id" fetch="join" outer-join="true" />
</class>
<!-- Mapping for ReferenceTable -->
<class name="ReferenceTableBase" schema="sys" table="objects" mutable="false" discriminator-value="ZZ">
<id name="IdentCode" column="object_id" type="Int32">
<generator class="identity" />
</id>
<discriminator column="`type`" type="String" not-null="true" force="true" insert="false" formula="case when `type` = 'TF' then 'IF' else `type` end" />
<property name="Name" column="`name`" type="String" not-null="true" />
<many-to-one not-found="ignore" name="Schema" class="ReferenceSchema" column="schema_id" fetch="join" outer-join="true"/>
<bag name="ReferenceColumns" table="columns" lazy="true" fetch="join" outer-join="true">
<key column="object_id" foreign-key="object_id" />
<one-to-many class="ReferenceColumn" not-found="ignore"/>
</bag>
<bag name="IdentityColumns" table="identity_columns" fetch="join" outer-join="true">
<key column="object_id" />
<one-to-many class="ReferenceIdentityColumn" not-found="ignore"/>
</bag>
<subclass name="ReferenceTable" discriminator-value="U " />
<subclass name="ReferenceView" discriminator-value="V " />
<subclass name="ReferenceTVF" discriminator-value="IF" />
</class>
<!-- Mapping for ReferenceColumn -->
<class name="ReferenceColumn" schema="sys" table="columns" mutable="false">
<composite-id>
<key-property name="IdentCode" column="column_id" type="Int32" />
<key-property name="ReferenceTableId" column="object_id" type="Int32" />
</composite-id>
<property name="Name" column="`name`" type="String" not-null="true" />
<property name="MaxLength" column="max_length" type="Int32" not-null="true" />
<property name="Collation" column="collation_name" type="String" />
<property name="IsNullable" column="is_nullable" type="Boolean" />
<property name="Scale" column="scale" type="Int32" />
<property name="Precision" column="precision" type="Int32" />
<property name="IsIdentity" column="is_identity" type="Boolean" />
<many-to-one not-found="ignore" name="ReferenceType" fetch="join" outer-join="true">
<column name="system_type_id" />
<column name="user_type_id" />
</many-to-one>
<many-to-one not-found="ignore" name="ReferenceTable" column="object_id" fetch="join" outer-join="true" />
<!-- Mapping for subclass ReferenceIdentityColumn -->
<joined-subclass name="ReferenceIdentityColumn" schema="sys" table="identity_columns">
<key>
<column name="column_id"/>
<column name="object_id"/>
</key>
<property name="Seed" column="seed_value" type="Int32" />
<property name="IncrementBy" column="increment_value" type="Int32" />
<property name="LastValue" column="last_value" type="Int32" />
</joined-subclass>
</class>
<!-- Mapping for ReferenceType -->
<class name="ReferenceType" schema="sys" table="types" mutable="false">
<composite-id>
<key-property name="IdentCode" column="system_type_id" type="Int32" />
<key-property name="UserTypeId" column="user_type_id" type="Int32" />
</composite-id>
<property name="Name" column="`name`" type="String" not-null="true" />
<property name="Collation" column="collation_name" type="String" />
</class>
</hibernate-mapping>
An excerpt from a hibernate logging file shown the executed sql queries when accessing reference data.
Code:
2008-09-08 13:15:43,511 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping class: RaconWest.DWH.davemdm.bl.reference.ReferenceDatabase -> databases
2008-09-08 13:15:43,511 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping class: RaconWest.DWH.davemdm.bl.reference.ReferenceSchema -> schemas
2008-09-08 13:15:43,511 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping class: RaconWest.DWH.davemdm.bl.reference.ReferenceProcedure -> procedures
2008-09-08 13:15:43,511 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping class: RaconWest.DWH.davemdm.bl.reference.ReferenceParameter -> parameters
2008-09-08 13:15:43,511 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping class: RaconWest.DWH.davemdm.bl.reference.ReferenceTableBase -> objects
2008-09-08 13:15:43,511 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping subclass: RaconWest.DWH.davemdm.bl.reference.ReferenceTable -> objects
2008-09-08 13:15:43,511 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping subclass: RaconWest.DWH.davemdm.bl.reference.ReferenceView -> objects
2008-09-08 13:15:43,511 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping subclass: RaconWest.DWH.davemdm.bl.reference.ReferenceTVF -> objects
2008-09-08 13:15:43,511 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping class: RaconWest.DWH.davemdm.bl.reference.ReferenceColumn -> columns
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping joined-subclass: RaconWest.DWH.davemdm.bl.reference.ReferenceIdentityColumn -> identity_columns
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - Mapping class: RaconWest.DWH.davemdm.bl.reference.ReferenceType -> types
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - checking mappings queue
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - processing one-to-many association mappings
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - mapping collection: RaconWest.DWH.davemdm.bl.reference.ReferenceSchema.ReferenceTables -> objects
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - mapping collection: RaconWest.DWH.davemdm.bl.reference.ReferenceSchema.ReferenceProcedures -> procedures
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - mapping collection: RaconWest.DWH.davemdm.bl.reference.ReferenceProcedure.ReferenceParameters -> parameters
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - mapping collection: RaconWest.DWH.davemdm.bl.reference.ReferenceTableBase.ReferenceColumns -> columns
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.HbmBinder [(null)] <(null)> - mapping collection: RaconWest.DWH.davemdm.bl.reference.ReferenceTableBase.IdentityColumns -> identity_columns
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - processing one-to-one association property references
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - processing foreign key constraints
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Dialect.Dialect [(null)] <(null)> - Using dialect: NHibernate.Dialect.MsSql2005Dialect
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Connection.ConnectionProviderFactory [(null)] <(null)> - Initializing connection provider: NHibernate.Connection.DriverConnectionProvider
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Connection.ConnectionProvider [(null)] <(null)> - Configuring ConnectionProvider
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - Transaction factory: NHibernate.Transaction.AdoNetTransactionFactory
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - Optimize cache for minimal puts: False
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - Connection release mode: auto
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - Query translator: NHibernate.Hql.Classic.ClassicQueryTranslatorFactory
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - Query language substitutions: {}
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - cache provider: NHibernate.Caches.SysCache2.SysCacheProvider, NHibernate.Caches.SysCache2, Version=1.2.1.4000, Culture=neutral, PublicKeyToken=aa95f207798dfdb4
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - query cache factory: NHibernate.Cache.StandardQueryCacheFactory
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Impl.SessionFactoryImpl [(null)] <(null)> - building session factory
2008-09-08 13:15:43,526 [Main] INFO NHibernate.Impl.SessionFactoryObjectFactory [(null)] <(null)> - no name configured
2008-09-08 13:15:43,542 [Main] INFO NHibernate.Cache.UpdateTimestampsCache [(null)] <(null)> - starting update timestamps cache at region: UpdateTimestampsCache
2008-09-08 13:15:43,542 [Main] INFO NHibernate.Cache.StandardQueryCache [(null)] <(null)> - starting query cache at region: NHibernate.Cache.StandardQueryCache
2008-09-08 13:15:43,542 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - select referenced0_.database_id as database1_607_, referenced0_.[name] as name2_607_, referenced0_.collation_name as collation3_607_ from master.sys.databases referenced0_
2008-09-08 13:15:43,667 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - select references0_.schema_id as schema1_608_, references0_.[name] as name2_608_ from sys.schemas references0_
2008-09-08 13:15:53,307 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,354 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,370 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,401 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,417 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,432 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,448 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,464 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,479 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,495 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,510 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,542 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:53,557 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_411_0_, referencet0_.[name] as name2_411_0_, referencet0_.schema_id as schema3_411_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,026 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,104 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,120 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,151 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,167 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,182 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,198 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,229 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,245 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,260 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,292 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,307 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,323 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,339 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,354 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,385 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,401 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,417 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,432 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,464 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,479 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,495 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,510 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,526 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,542 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,557 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,589 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,604 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,620 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,635 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:56,651 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_419_0_, referencet0_.[name] as name2_419_0_, referencet0_.schema_id as schema3_419_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,417 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,667 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,682 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,714 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,729 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,745 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,760 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,776 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,807 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,823 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,839 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,854 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,870 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,885 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
2008-09-08 13:15:59,917 [Main] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT referencet0_.schema_id as schema3___1_, referencet0_.object_id as object1_1_, referencet0_.object_id as object1_467_0_, referencet0_.[name] as name2_467_0_, referencet0_.schema_id as schema3_467_0_, case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end as clazz_0_ FROM sys.objects referencet0_ WHERE referencet0_.[type] IN ('U ','V ','IF') and case when referencet0_.[type] = 'TF' then 'IF' else referencet0_.[type] end in ('ZZ', 'U ', 'V ', 'IF') and referencet0_.schema_id=@p0
The second mapping file is the mapping for our meta data tree view. The tree view shows meta data to the user. Its a leightweight of the "real" meta data mapping which i do not show here, because the problems are the same as the simplier tree view mapping.
TreeView meta data mapping
[code]
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="DaveMdm.Bl, Version=1.0.0.0, Culture=neutral, PublicKeyToken=5f30d2ae8e3baa9f" namespace="RaconWest.DWH.davemdm.bl">
<!-- MetaBuild mapping -->
<class name="MetaBuild" schema="dbo" table="BuildItem" lazy="true">
<cache usage="read-only" />
<id name="IdentCode" type="Int32">
<generator class="identity" />
</id>
<property name="TypeId" column="BuildTypeID" type="Int32" not-null="true" update="false" insert="false" />
<property name="ReleaseNumber" column="ReleaseNumber" type="String" not-null="true" />
<property name="Major" column="MayorRelease" type="String" not-null="true" />
<property name="Minor" column="MinorRelease" type="String" not-null="true" />
<property name="Build" column="BuildNumber" type="String" not-null="true" />
<property name="BuildDate" column="BuildDate" type="DateTime" not-null="true" />
<property name="Note" column="BuildComment" type="String" />
<property name="Client" column="BuildMandant" type="String" />
<bag name="MetaDatabases" where="ObjectTypeID=1" cascade="delete" fetch="join" order-by="ObjectItemName">
<cache usage="read-only"/>
<key column="BuildItemID" foreign-key="IdentCode" />
<one-to-many class="MetaDatabase" />
</bag>
<bag name="MetaCalculations" where="ObjectTypeID=14" lazy="true">
<cache usage="read-only"/>
<key column="BuildItemID" foreign-key="IdentCode" />
<one-to-many class="MetaCalculation" />
</bag>
</class>
<!-- MetaObject mapping includes subclasses -->
<class name="MetaObject" schema="dbo" table="ObjectItem" discriminator-value="-1" lazy="true">
<cache usage="read-only" />
<id name="IdentCode" type="Int32">
<generator class="identity"/>
</id>
<discriminator column="ObjectTypeID" type="String" not-null="true" force="true" insert="false" />
<property name="TypeId" column="ObjectTypeID" type="Int32" not-null="true" update="false" insert="false" />
<property name="Name" column="ObjectItemName" type="String" />
<property name="Note" column="ObjectItemComment" type="String" />
<property name=&q
Login
FAQ
Search