I changed from a single table hierarchy (inheritence strategy) to a table-per-class hierarchy and I started getting the
Code:
System.IndexOutOfRangeException: clazz_8_
exception. Please don't be distracted by the Lazy Initialization Exception that is thrown later. Is this a known issue with joined-subclass, or could I have perhaps messed something up in the mapping document when I was making my changes?
Hibernate version: 1.2.1.4000
Mapping documents:Code:
<?xml version="1.0"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-lazy="true">
<class
name="WPMS.Model.Web.UI.Control, WPMS"
table="Control">
<id name="UUID" type="Int64" column="uuid" >
<generator class="sequence">
<param name="sequence">Control_SEQ</param>
</generator>
</id>
<property name="ID" column="id"/>
<many-to-one name="Parent" class="WPMS.Model.Web.UI.Control, WPMS" column="parent_id_fk" outer-join="true" cascade="all"/>
<joined-subclass
table="WebControl"
name="WPMS.Model.Web.UI.WebControls.WebControl, WPMS">
<key column="control_id_fk"/>
<property name="AccessKey" column="access_key"/>
<property name="CssClass" column="css_class"/>
<property name="Enabled"/>
<property name="Height"/>
<property name="SkinID" column="skin_id"/>
<property name="TabIndex" column="tab_index"/>
<property name="ToolTip" column="tool_tip"/>
<list name="Events" lazy="false" cascade="all">
<key column="web_control_id_fk"/>
<index column="sort_index"/>
<one-to-many class="WPMS.Model.Web.UI.WebControls.WebControlEvent, WPMS" />
</list>
<many-to-one name="Style" class="WPMS.Model.Web.UI.WebControls.Style, WPMS" column="style_id_fk" outer-join="true" cascade="all"/>
<many-to-one name="Attributes" class="WPMS.Model.Web.UI.WebControls.Attributes, WPMS" column="attributes_id_fk" outer-join="true" cascade="all"/>
<joined-subclass
table="Form"
name="WPMS.Model.Web.UI.WebControls.Form, WPMS">
<key column="web_control_id_fk"/>
<property name="Name" />
<property name="Description" column="description" />
<property name="DateCreated" column="date_created" />
<property name="DateLastModified" column="date_last_modified" />
<property name="Active" />
<many-to-one name="CreatedBy" class="WPMS.Model.User, WPMS" column="created_by_id_fk" outer-join="true" />
<many-to-one name="LastModifiedBy" class="WPMS.Model.User, WPMS" column="last_modified_by_id_fk" outer-join="true" />
<bag name="Controls" cascade="all">
<key column="form_id_fk"/>
<one-to-many class="WPMS.Model.Web.UI.Control, WPMS" />
</bag >
<joined-subclass
table="SearchForm"
name="WPMS.Model.Web.UI.WebControls.SearchForm, WPMS">
<key column="form_id_fk"/>
<many-to-one name="SearchButton" class="WPMS.Model.Web.UI.WebControls.Button, WPMS" column="search_button_id_fk" outer-join="true" />
</joined-subclass>
<joined-subclass
table="ResultsViewer"
name="WPMS.Model.Web.UI.WebControls.ResultsViewer, WPMS">
<key column="form_id_fk"/>
</joined-subclass>
</joined-subclass>
<joined-subclass
table="Panel"
name="WPMS.Model.Web.UI.WebControls.Panel, WPMS">
<key column="web_control_id_fk"/>
<property name="Text"/>
<list name="Controls" cascade="all">
<key column="panel_id_fk"/>
<index column="sort_index"/>
<one-to-many class="WPMS.Model.Web.UI.Control, WPMS" />
</list>
</joined-subclass>
<joined-subclass
table="DropDownList"
name="WPMS.Model.Web.UI.WebControls.DropDownList, WPMS">
<key column="web_control_id_fk"/>
<property name="Text"/>
<list name="Items" cascade="all">
<key column="drop_down_list_id_fk"/>
<index column="sort_index"/>
<one-to-many class="WPMS.Model.Web.UI.WebControls.ListItem, WPMS" />
</list>
</joined-subclass>
<joined-subclass
table="ListBox"
name="WPMS.Model.Web.UI.WebControls.ListBox, WPMS">
<key column="web_control_id_fk"/>
<property name="Text"/>
<list name="Items" cascade="all">
<key column="list_box_list_id_fk"/>
<index column="sort_index"/>
<one-to-many class="WPMS.Model.Web.UI.WebControls.ListItem, WPMS" />
</list>
</joined-subclass>
<joined-subclass
table="AddRemove"
name="WPMS.Model.Web.UI.WebControls.AddRemove, WPMS">
<key column="web_control_id_fk"/>
<property name="Text"/>
<list name="Items" cascade="all">
<key column="add_remove_list_id_fk"/>
<index column="sort_index"/>
<one-to-many class="WPMS.Model.Web.UI.WebControls.ListItem, WPMS" />
</list>
</joined-subclass>
<joined-subclass
table="Button"
name="WPMS.Model.Web.UI.WebControls.Button, WPMS">
<key column="web_control_id_fk"/>
<property name="Text"/>
<property name="OnClientClick"/>
<property name="Type" column="button_type"/>
</joined-subclass>
<joined-subclass
table="Label"
name="WPMS.Model.Web.UI.WebControls.Label, WPMS">
<key column="web_control_id_fk"/>
<property name="Text"/>
</joined-subclass>
<joined-subclass
table="TextBox"
name="WPMS.Model.Web.UI.WebControls.TextBox, WPMS">
<key column="web_control_id_fk"/>
<property name="AutoPostBack" column="auto_post_back"/>
<property name="MaxLength" column="max_length"/>
<property name="Text"/>
</joined-subclass>
<joined-subclass
table="RadioButton"
name="WPMS.Model.Web.UI.WebControls.RadioButton, WPMS">
<key column="web_control_id_fk"/>
<property name="Checked"/>
<property name="Text"/>
</joined-subclass>
<joined-subclass
table="CheckBox"
name="WPMS.Model.Web.UI.WebControls.CheckBox, WPMS">
<key column="web_control_id_fk"/>
<property name="Checked"/>
<property name="Text"/>
</joined-subclass>
<joined-subclass
table="GridView"
name="WPMS.Model.Web.UI.WebControls.GridView, WPMS">
<key column="web_control_id_fk"/>
<property name="AllowPaging"/>
<property name="AllowSorting"/>
<property name="DataSourceID"/>
<property name="GridLines"/>
<list name="Columns" cascade="all">
<key column="grid_view_id_fk"/>
<index column="sort_index"/>
<one-to-many class="WPMS.Model.Web.UI.WebControls.DataControlField, WPMS" />
</list>
</joined-subclass>
</joined-subclass>
<joined-subclass
table="ObjectDataSource"
name="WPMS.Model.Web.UI.WebControls.ObjectDataSource, WPMS">
<key column="control_id_fk"/>
<property name="TypeName"/>
<property name="SelectMethod"/>
<list name="OnSelectingInputParameters" cascade="all">
<key column="object_data_source_id_fk"/>
<index column="sort_index"/>
<one-to-many class="WPMS.Model.KeyValue, WPMS" />
</list>
</joined-subclass>
</class>
</hibernate-mapping>
Full stack trace of any exception that occurs:Code:
NHibernate.Util.ADOExceptionReporter: 10:03:57,656 DEBUG ADOExceptionReporter:0 - could not initialize a collection: [WPMS.Model.Web.UI.WebControls.Form.Controls#259] [SELECT controls0_.form_id_fk as form4___9_, controls0_.uuid as uuid9_, controls0_.uuid as uuid5_8_, controls0_.id as id5_8_, controls0_.parent_id_fk as parent3_5_8_, controls0_1_.access_key as access2_6_8_, controls0_1_.css_class as css3_6_8_, controls0_1_.Enabled as Enabled6_8_, controls0_1_.Height as Height6_8_, controls0_1_.skin_id as skin6_6_8_, controls0_1_.tab_index as tab7_6_8_, controls0_1_.tool_tip as tool8_6_8_, controls0_1_.style_id_fk as style9_6_8_, controls0_1_.attributes_id_fk as attributes10_6_8_, controls0_2_.Name as Name7_8_, controls0_2_.description as descript3_7_8_, controls0_2_.date_created as date4_7_8_, controls0_2_.date_last_modified as date5_7_8_, controls0_2_.Active as Active7_8_, controls0_2_.created_by_id_fk as created7_7_8_, controls0_2_.last_modified_by_id_fk as last8_7_8_, controls0_3_.search_button_id_fk as search2_8_8_, controls0_5_.Text as Text10_8_, controls0_6_.Text as Text11_8_, controls0_7_.Text as Text12_8_, controls0_8_.Text as Text13_8_, controls0_9_.Text as Text14_8_, controls0_9_.OnClientClick as OnClient3_14_8_, controls0_9_.button_type as button4_14_8_, controls0_10_.Text as Text15_8_, controls0_11_.auto_post_back as auto2_16_8_, controls0_11_.max_length as max3_16_8_, controls0_11_.Text as Text16_8_, controls0_12_.Checked as Checked17_8_, controls0_12_.Text as Text17_8_, controls0_13_.Checked as Checked18_8_, controls0_13_.Text as Text18_8_, controls0_14_.AllowPaging as AllowPag2_19_8_, controls0_14_.AllowSorting as AllowSor3_19_8_, controls0_14_.DataSourceID as DataSour4_19_8_, controls0_14_.GridLines as GridLines19_8_, controls0_15_.TypeName as TypeName20_8_, controls0_15_.SelectMethod as SelectMe3_20_8_, decode(controls0_.uuid, controls0_3_.form_id_fk, 3, controls0_4_.form_id_fk, 4, controls0_2_.web_control_id_fk, 2, controls0_5_.web_control_id_fk, 5, controls0_6_.web_control_id_fk, 6, controls0_7_.web_control_id_fk, 7, controls0_8_.web_control_id_fk, 8, controls0_9_.web_control_id_fk, 9, controls0_10_.web_control_id_fk, 10, controls0_11_.web_control_id_fk, 11, controls0_12_.web_control_id_fk, 12, controls0_13_.web_control_id_fk, 13, controls0_14_.web_control_id_fk, 14, controls0_1_.control_id_fk, 1, controls0_15_.control_id_fk, 15, 0), control1_.uuid as uuid5_0_, control1_.id as id5_0_, control1_.parent_id_fk as parent3_5_0_, control1_1_.access_key as access2_6_0_, control1_1_.css_class as css3_6_0_, control1_1_.Enabled as Enabled6_0_, control1_1_.Height as Height6_0_, control1_1_.skin_id as skin6_6_0_, control1_1_.tab_index as tab7_6_0_, control1_1_.tool_tip as tool8_6_0_, control1_1_.style_id_fk as style9_6_0_, control1_1_.attributes_id_fk as attributes10_6_0_, control1_2_.Name as Name7_0_, control1_2_.description as descript3_7_0_, control1_2_.date_created as date4_7_0_, control1_2_.date_last_modified as date5_7_0_, control1_2_.Active as Active7_0_, control1_2_.created_by_id_fk as created7_7_0_, control1_2_.last_modified_by_id_fk as last8_7_0_, control1_3_.search_button_id_fk as search2_8_0_, control1_5_.Text as Text10_0_, control1_6_.Text as Text11_0_, control1_7_.Text as Text12_0_, control1_8_.Text as Text13_0_, control1_9_.Text as Text14_0_, control1_9_.OnClientClick as OnClient3_14_0_, control1_9_.button_type as button4_14_0_, control1_10_.Text as Text15_0_, control1_11_.auto_post_back as auto2_16_0_, control1_11_.max_length as max3_16_0_, control1_11_.Text as Text16_0_, control1_12_.Checked as Checked17_0_, control1_12_.Text as Text17_0_, control1_13_.Checked as Checked18_0_, control1_13_.Text as Text18_0_, control1_14_.AllowPaging as AllowPag2_19_0_, control1_14_.AllowSorting as AllowSor3_19_0_, control1_14_.DataSourceID as DataSour4_19_0_, control1_14_.GridLines as GridLines19_0_, control1_15_.TypeName as TypeName20_0_, control1_15_.SelectMethod as SelectMe3_20_0_, decode(control1_.uuid, control1_3_.form_id_fk, 3, control1_4_.form_id_fk, 4, control1_2_.web_control_id_fk, 2, control1_5_.web_control_id_fk, 5, control1_6_.web_control_id_fk, 6, control1_7_.web_control_id_fk, 7, control1_8_.web_control_id_fk, 8, control1_9_.web_control_id_fk, 9, control1_10_.web_control_id_fk, 10, control1_11_.web_control_id_fk, 11, control1_12_.web_control_id_fk, 12, control1_13_.web_control_id_fk, 13, control1_14_.web_control_id_fk, 14, control1_1_.control_id_fk, 1, control1_15_.control_id_fk, 15, 0), style2_.Id as Id4_1_, attributes3_.Id as Id0_2_, user4_.UUID as UUID24_3_, user4_.Username as Username24_3_, user4_.Password as Password24_3_, user4_.Email as Email24_3_, user4_.last_login as last5_24_3_, user4_.date_created as date6_24_3_, user4_.date_last_modified as date7_24_3_, user4_.Active as Active24_3_, user4_.created_by_id_fk as created9_24_3_, user4_.last_modified_by_id_fk as last10_24_3_, user5_.UUID as UUID24_4_, user5_.Username as Username24_4_, user5_.Password as Password24_4_, user5_.Email as Email24_4_, user5_.last_login as last5_24_4_, user5_.date_created as date6_24_4_, user5_.date_last_modified as date7_24_4_, user5_.Active as Active24_4_, user5_.created_by_id_fk as created9_24_4_, user5_.last_modified_by_id_fk as last10_24_4_, user6_.UUID as UUID24_5_, user6_.Username as Username24_5_, user6_.Password as Password24_5_, user6_.Email as Email24_5_, user6_.last_login as last5_24_5_, user6_.date_created as date6_24_5_, user6_.date_last_modified as date7_24_5_, user6_.Active as Active24_5_, user6_.created_by_id_fk as created9_24_5_, user6_.last_modified_by_id_fk as last10_24_5_, user7_.UUID as UUID24_6_, user7_.Username as Username24_6_, user7_.Password as Password24_6_, user7_.Email as Email24_6_, user7_.last_login as last5_24_6_, user7_.date_created as date6_24_6_, user7_.date_last_modified as date7_24_6_, user7_.Active as Active24_6_, user7_.created_by_id_fk as created9_24_6_, user7_.last_modified_by_id_fk as last10_24_6_, button8_.web_control_id_fk as uuid5_7_, button8_.Text as Text14_7_, button8_.OnClientClick as OnClient3_14_7_, button8_.button_type as button4_14_7_, button8_1_.access_key as access2_6_7_, button8_1_.css_class as css3_6_7_, button8_1_.Enabled as Enabled6_7_, button8_1_.Height as Height6_7_, button8_1_.skin_id as skin6_6_7_, button8_1_.tab_index as tab7_6_7_, button8_1_.tool_tip as tool8_6_7_, button8_1_.style_id_fk as style9_6_7_, button8_1_.attributes_id_fk as attributes10_6_7_, button8_2_.id as id5_7_, button8_2_.parent_id_fk as parent3_5_7_ FROM Control controls0_, WebControl controls0_1_, Form controls0_2_, SearchForm controls0_3_, ResultsViewer controls0_4_, Panel controls0_5_, DropDownList controls0_6_, ListBox controls0_7_, AddRemove controls0_8_, Button controls0_9_, Label controls0_10_, TextBox controls0_11_, RadioButton controls0_12_, CheckBox controls0_13_, GridView controls0_14_, ObjectDataSource controls0_15_, Control control1_, WebControl control1_1_, Form control1_2_, SearchForm control1_3_, ResultsViewer control1_4_, Panel control1_5_, DropDownList control1_6_, ListBox control1_7_, AddRemove control1_8_, Button control1_9_, Label control1_10_, TextBox control1_11_, RadioButton control1_12_, CheckBox control1_13_, GridView control1_14_, ObjectDataSource control1_15_, Style style2_, Attributes attributes3_, Users user4_, Users user5_, Users user6_, Users user7_, Button button8_, WebControl button8_1_, Control button8_2_ WHERE controls0_.parent_id_fk=control1_.uuid(+) and control1_.uuid=control1_1_.control_id_fk(+) and control1_.uuid=control1_2_.web_control_id_fk(+) and control1_.uuid=control1_3_.form_id_fk(+) and control1_.uuid=control1_4_.form_id_fk(+) and control1_.uuid=control1_5_.web_control_id_fk(+) and control1_.uuid=control1_6_.web_control_id_fk(+) and control1_.uuid=control1_7_.web_control_id_fk(+) and control1_.uuid=control1_8_.web_control_id_fk(+) and control1_.uuid=control1_9_.web_control_id_fk(+) and control1_.uuid=control1_10_.web_control_id_fk(+) and control1_.uuid=control1_11_.web_control_id_fk(+) and control1_.uuid=control1_12_.web_control_id_fk(+) and control1_.uuid=control1_13_.web_control_id_fk(+) and control1_.uuid=control1_14_.web_control_id_fk(+) and control1_.uuid=control1_15_.control_id_fk(+) and control1_1_.style_id_fk=style2_.Id(+) and control1_1_.attributes_id_fk=attributes3_.Id(+) and control1_2_.created_by_id_fk=user4_.UUID(+) and user4_.created_by_id_fk=user5_.UUID(+) and user5_.last_modified_by_id_fk=user6_.UUID(+) and control1_2_.last_modified_by_id_fk=user7_.UUID(+) and control1_3_.search_button_id_fk=button8_.web_control_id_fk(+) and button8_.web_control_id_fk=button8_1_.control_id_fk(+) and button8_.web_control_id_fk=button8_2_.uuid(+) and controls0_.uuid=controls0_1_.control_id_fk(+) and controls0_.uuid=controls0_2_.web_control_id_fk(+) and controls0_.uuid=controls0_3_.form_id_fk(+) and controls0_.uuid=controls0_4_.form_id_fk(+) and controls0_.uuid=controls0_5_.web_control_id_fk(+) and controls0_.uuid=controls0_6_.web_control_id_fk(+) and controls0_.uuid=controls0_7_.web_control_id_fk(+) and controls0_.uuid=controls0_8_.web_control_id_fk(+) and controls0_.uuid=controls0_9_.web_control_id_fk(+) and controls0_.uuid=controls0_10_.web_control_id_fk(+) and controls0_.uuid=controls0_11_.web_control_id_fk(+) and controls0_.uuid=controls0_12_.web_control_id_fk(+) and controls0_.uuid=controls0_13_.web_control_id_fk(+) and controls0_.uuid=controls0_14_.web_control_id_fk(+) and controls0_.uuid=controls0_15_.control_id_fk(+) AND controls0_.form_id_fk=?]
System.IndexOutOfRangeException: clazz_8_
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.OracleClient.OracleDataReader.GetOrdinal(String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name, ISessionImplementor session, Object owner)
at NHibernate.Loader.Loader.GetInstanceClass(IDataReader rs, Int32 i, ILoadable persister, Object id, ISessionImplementor session)
at NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.LoadCollection(ISessionImplementor session, Object id, IType type)
NHibernate.Util.ADOExceptionReporter: 10:03:57,687 WARN ADOExceptionReporter:0 - System.IndexOutOfRangeException: clazz_8_
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.OracleClient.OracleDataReader.GetOrdinal(String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name, ISessionImplementor session, Object owner)
at NHibernate.Loader.Loader.GetInstanceClass(IDataReader rs, Int32 i, ILoadable persister, Object id, ISessionImplementor session)
at NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.LoadCollection(ISessionImplementor session, Object id, IType type)
NHibernate.Util.ADOExceptionReporter: 10:03:57,703 ERROR ADOExceptionReporter:0 - clazz_8_
NHibernate.Collection.AbstractPersistentCollection: 10:03:57,703 ERROR AbstractPersistentCollection:0 - Failed to lazily initialize a collection
NHibernate.ADOException: could not initialize a collection: [WPMS.Model.Web.UI.WebControls.Form.Controls#259][SQL: SELECT controls0_.form_id_fk as form4___9_, controls0_.uuid as uuid9_, controls0_.uuid as uuid5_8_, controls0_.id as id5_8_, controls0_.parent_id_fk as parent3_5_8_, controls0_1_.access_key as access2_6_8_, controls0_1_.css_class as css3_6_8_, controls0_1_.Enabled as Enabled6_8_, controls0_1_.Height as Height6_8_, controls0_1_.skin_id as skin6_6_8_, controls0_1_.tab_index as tab7_6_8_, controls0_1_.tool_tip as tool8_6_8_, controls0_1_.style_id_fk as style9_6_8_, controls0_1_.attributes_id_fk as attributes10_6_8_, controls0_2_.Name as Name7_8_, controls0_2_.description as descript3_7_8_, controls0_2_.date_created as date4_7_8_, controls0_2_.date_last_modified as date5_7_8_, controls0_2_.Active as Active7_8_, controls0_2_.created_by_id_fk as created7_7_8_, controls0_2_.last_modified_by_id_fk as last8_7_8_, controls0_3_.search_button_id_fk as search2_8_8_, controls0_5_.Text as Text10_8_, controls0_6_.Text as Text11_8_, controls0_7_.Text as Text12_8_, controls0_8_.Text as Text13_8_, controls0_9_.Text as Text14_8_, controls0_9_.OnClientClick as OnClient3_14_8_, controls0_9_.button_type as button4_14_8_, controls0_10_.Text as Text15_8_, controls0_11_.auto_post_back as auto2_16_8_, controls0_11_.max_length as max3_16_8_, controls0_11_.Text as Text16_8_, controls0_12_.Checked as Checked17_8_, controls0_12_.Text as Text17_8_, controls0_13_.Checked as Checked18_8_, controls0_13_.Text as Text18_8_, controls0_14_.AllowPaging as AllowPag2_19_8_, controls0_14_.AllowSorting as AllowSor3_19_8_, controls0_14_.DataSourceID as DataSour4_19_8_, controls0_14_.GridLines as GridLines19_8_, controls0_15_.TypeName as TypeName20_8_, controls0_15_.SelectMethod as SelectMe3_20_8_, decode(controls0_.uuid, controls0_3_.form_id_fk, 3, controls0_4_.form_id_fk, 4, controls0_2_.web_control_id_fk, 2, controls0_5_.web_control_id_fk, 5, controls0_6_.web_control_id_fk, 6, controls0_7_.web_control_id_fk, 7, controls0_8_.web_control_id_fk, 8, controls0_9_.web_control_id_fk, 9, controls0_10_.web_control_id_fk, 10, controls0_11_.web_control_id_fk, 11, controls0_12_.web_control_id_fk, 12, controls0_13_.web_control_id_fk, 13, controls0_14_.web_control_id_fk, 14, controls0_1_.control_id_fk, 1, controls0_15_.control_id_fk, 15, 0), control1_.uuid as uuid5_0_, control1_.id as id5_0_, control1_.parent_id_fk as parent3_5_0_, control1_1_.access_key as access2_6_0_, control1_1_.css_class as css3_6_0_, control1_1_.Enabled as Enabled6_0_, control1_1_.Height as Height6_0_, control1_1_.skin_id as skin6_6_0_, control1_1_.tab_index as tab7_6_0_, control1_1_.tool_tip as tool8_6_0_, control1_1_.style_id_fk as style9_6_0_, control1_1_.attributes_id_fk as attributes10_6_0_, control1_2_.Name as Name7_0_, control1_2_.description as descript3_7_0_, control1_2_.date_created as date4_7_0_, control1_2_.date_last_modified as date5_7_0_, control1_2_.Active as Active7_0_, control1_2_.created_by_id_fk as created7_7_0_, control1_2_.last_modified_by_id_fk as last8_7_0_, control1_3_.search_button_id_fk as search2_8_0_, control1_5_.Text as Text10_0_, control1_6_.Text as Text11_0_, control1_7_.Text as Text12_0_, control1_8_.Text as Text13_0_, control1_9_.Text as Text14_0_, control1_9_.OnClientClick as OnClient3_14_0_, control1_9_.button_type as button4_14_0_, control1_10_.Text as Text15_0_, control1_11_.auto_post_back as auto2_16_0_, control1_11_.max_length as max3_16_0_, control1_11_.Text as Text16_0_, control1_12_.Checked as Checked17_0_, control1_12_.Text as Text17_0_, control1_13_.Checked as Checked18_0_, control1_13_.Text as Text18_0_, control1_14_.AllowPaging as AllowPag2_19_0_, control1_14_.AllowSorting as AllowSor3_19_0_, control1_14_.DataSourceID as DataSour4_19_0_, control1_14_.GridLines as GridLines19_0_, control1_15_.TypeName as TypeName20_0_, control1_15_.SelectMethod as SelectMe3_20_0_, decode(control1_.uuid, control1_3_.form_id_fk, 3, control1_4_.form_id_fk, 4, control1_2_.web_control_id_fk, 2, control1_5_.web_control_id_fk, 5, control1_6_.web_control_id_fk, 6, control1_7_.web_control_id_fk, 7, control1_8_.web_control_id_fk, 8, control1_9_.web_control_id_fk, 9, control1_10_.web_control_id_fk, 10, control1_11_.web_control_id_fk, 11, control1_12_.web_control_id_fk, 12, control1_13_.web_control_id_fk, 13, control1_14_.web_control_id_fk, 14, control1_1_.control_id_fk, 1, control1_15_.control_id_fk, 15, 0), style2_.Id as Id4_1_, attributes3_.Id as Id0_2_, user4_.UUID as UUID24_3_, user4_.Username as Username24_3_, user4_.Password as Password24_3_, user4_.Email as Email24_3_, user4_.last_login as last5_24_3_, user4_.date_created as date6_24_3_, user4_.date_last_modified as date7_24_3_, user4_.Active as Active24_3_, user4_.created_by_id_fk as created9_24_3_, user4_.last_modified_by_id_fk as last10_24_3_, user5_.UUID as UUID24_4_, user5_.Username as Username24_4_, user5_.Password as Password24_4_, user5_.Email as Email24_4_, user5_.last_login as last5_24_4_, user5_.date_created as date6_24_4_, user5_.date_last_modified as date7_24_4_, user5_.Active as Active24_4_, user5_.created_by_id_fk as created9_24_4_, user5_.last_modified_by_id_fk as last10_24_4_, user6_.UUID as UUID24_5_, user6_.Username as Username24_5_, user6_.Password as Password24_5_, user6_.Email as Email24_5_, user6_.last_login as last5_24_5_, user6_.date_created as date6_24_5_, user6_.date_last_modified as date7_24_5_, user6_.Active as Active24_5_, user6_.created_by_id_fk as created9_24_5_, user6_.last_modified_by_id_fk as last10_24_5_, user7_.UUID as UUID24_6_, user7_.Username as Username24_6_, user7_.Password as Password24_6_, user7_.Email as Email24_6_, user7_.last_login as last5_24_6_, user7_.date_created as date6_24_6_, user7_.date_last_modified as date7_24_6_, user7_.Active as Active24_6_, user7_.created_by_id_fk as created9_24_6_, user7_.last_modified_by_id_fk as last10_24_6_, button8_.web_control_id_fk as uuid5_7_, button8_.Text as Text14_7_, button8_.OnClientClick as OnClient3_14_7_, button8_.button_type as button4_14_7_, button8_1_.access_key as access2_6_7_, button8_1_.css_class as css3_6_7_, button8_1_.Enabled as Enabled6_7_, button8_1_.Height as Height6_7_, button8_1_.skin_id as skin6_6_7_, button8_1_.tab_index as tab7_6_7_, button8_1_.tool_tip as tool8_6_7_, button8_1_.style_id_fk as style9_6_7_, button8_1_.attributes_id_fk as attributes10_6_7_, button8_2_.id as id5_7_, button8_2_.parent_id_fk as parent3_5_7_ FROM Control controls0_, WebControl controls0_1_, Form controls0_2_, SearchForm controls0_3_, ResultsViewer controls0_4_, Panel controls0_5_, DropDownList controls0_6_, ListBox controls0_7_, AddRemove controls0_8_, Button controls0_9_, Label controls0_10_, TextBox controls0_11_, RadioButton controls0_12_, CheckBox controls0_13_, GridView controls0_14_, ObjectDataSource controls0_15_, Control control1_, WebControl control1_1_, Form control1_2_, SearchForm control1_3_, ResultsViewer control1_4_, Panel control1_5_, DropDownList control1_6_, ListBox control1_7_, AddRemove control1_8_, Button control1_9_, Label control1_10_, TextBox control1_11_, RadioButton control1_12_, CheckBox control1_13_, GridView control1_14_, ObjectDataSource control1_15_, Style style2_, Attributes attributes3_, Users user4_, Users user5_, Users user6_, Users user7_, Button button8_, WebControl button8_1_, Control button8_2_ WHERE controls0_.parent_id_fk=control1_.uuid(+) and control1_.uuid=control1_1_.control_id_fk(+) and control1_.uuid=control1_2_.web_control_id_fk(+) and control1_.uuid=control1_3_.form_id_fk(+) and control1_.uuid=control1_4_.form_id_fk(+) and control1_.uuid=control1_5_.web_control_id_fk(+) and control1_.uuid=control1_6_.web_control_id_fk(+) and control1_.uuid=control1_7_.web_control_id_fk(+) and control1_.uuid=control1_8_.web_control_id_fk(+) and control1_.uuid=control1_9_.web_control_id_fk(+) and control1_.uuid=control1_10_.web_control_id_fk(+) and control1_.uuid=control1_11_.web_control_id_fk(+) and control1_.uuid=control1_12_.web_control_id_fk(+) and control1_.uuid=control1_13_.web_control_id_fk(+) and control1_.uuid=control1_14_.web_control_id_fk(+) and control1_.uuid=control1_15_.control_id_fk(+) and control1_1_.style_id_fk=style2_.Id(+) and control1_1_.attributes_id_fk=attributes3_.Id(+) and control1_2_.created_by_id_fk=user4_.UUID(+) and user4_.created_by_id_fk=user5_.UUID(+) and user5_.last_modified_by_id_fk=user6_.UUID(+) and control1_2_.last_modified_by_id_fk=user7_.UUID(+) and control1_3_.search_button_id_fk=button8_.web_control_id_fk(+) and button8_.web_control_id_fk=button8_1_.control_id_fk(+) and button8_.web_control_id_fk=button8_2_.uuid(+) and controls0_.uuid=controls0_1_.control_id_fk(+) and controls0_.uuid=controls0_2_.web_control_id_fk(+) and controls0_.uuid=controls0_3_.form_id_fk(+) and controls0_.uuid=controls0_4_.form_id_fk(+) and controls0_.uuid=controls0_5_.web_control_id_fk(+) and controls0_.uuid=controls0_6_.web_control_id_fk(+) and controls0_.uuid=controls0_7_.web_control_id_fk(+) and controls0_.uuid=controls0_8_.web_control_id_fk(+) and controls0_.uuid=controls0_9_.web_control_id_fk(+) and controls0_.uuid=controls0_10_.web_control_id_fk(+) and controls0_.uuid=controls0_11_.web_control_id_fk(+) and controls0_.uuid=controls0_12_.web_control_id_fk(+) and controls0_.uuid=controls0_13_.web_control_id_fk(+) and controls0_.uuid=controls0_14_.web_control_id_fk(+) and controls0_.uuid=controls0_15_.control_id_fk(+) AND controls0_.form_id_fk=?] ---> System.IndexOutOfRangeException: clazz_8_
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.OracleClient.OracleDataReader.GetOrdinal(String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name, ISessionImplementor session, Object owner)
at NHibernate.Loader.Loader.GetInstanceClass(IDataReader rs, Int32 i, ILoadable persister, Object id, ISessionImplementor session)
at NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.LoadCollection(ISessionImplementor session, Object id, IType type)
--- End of inner exception stack trace ---
at NHibernate.Loader.Loader.LoadCollection(ISessionImplementor session, Object id, IType type)
at NHibernate.Loader.Collection.CollectionLoader.Initialize(Object id, ISessionImplementor session)
at NHibernate.Persister.Collection.AbstractCollectionPersister.Initialize(Object key, ISessionImplementor session)
at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing)
at NHibernate.Collection.AbstractPersistentCollection.Initialize(Boolean writing)
NHibernate.LazyInitializationException: 10:03:57,703 ERROR LazyInitializationException:0 - Failed to lazily initialize a collection
NHibernate.LazyInitializationException: Failed to lazily initialize a collection ---> NHibernate.ADOException: could not initialize a collection: [WPMS.Model.Web.UI.WebControls.Form.Controls#259][SQL: SELECT controls0_.form_id_fk as form4___9_, controls0_.uuid as uuid9_, controls0_.uuid as uuid5_8_, controls0_.id as id5_8_, controls0_.parent_id_fk as parent3_5_8_, controls0_1_.access_key as access2_6_8_, controls0_1_.css_class as css3_6_8_, controls0_1_.Enabled as Enabled6_8_, controls0_1_.Height as Height6_8_, controls0_1_.skin_id as skin6_6_8_, controls0_1_.tab_index as tab7_6_8_, controls0_1_.tool_tip as tool8_6_8_, controls0_1_.style_id_fk as style9_6_8_, controls0_1_.attributes_id_fk as attributes10_6_8_, controls0_2_.Name as Name7_8_, controls0_2_.description as descript3_7_8_, controls0_2_.date_created as date4_7_8_, controls0_2_.date_last_modified as date5_7_8_, controls0_2_.Active as Active7_8_, controls0_2_.created_by_id_fk as created7_7_8_, controls0_2_.last_modified_by_id_fk as last8_7_8_, controls0_3_.search_button_id_fk as search2_8_8_, controls0_5_.Text as Text10_8_, controls0_6_.Text as Text11_8_, controls0_7_.Text as Text12_8_, controls0_8_.Text as Text13_8_, controls0_9_.Text as Text14_8_, controls0_9_.OnClientClick as OnClient3_14_8_, controls0_9_.button_type as button4_14_8_, controls0_10_.Text as Text15_8_, controls0_11_.auto_post_back as auto2_16_8_, controls0_11_.max_length as max3_16_8_, controls0_11_.Text as Text16_8_, controls0_12_.Checked as Checked17_8_, controls0_12_.Text as Text17_8_, controls0_13_.Checked as Checked18_8_, controls0_13_.Text as Text18_8_, controls0_14_.AllowPaging as AllowPag2_19_8_, controls0_14_.AllowSorting as AllowSor3_19_8_, controls0_14_.DataSourceID as DataSour4_19_8_, controls0_14_.GridLines as GridLines19_8_, controls0_15_.TypeName as TypeName20_8_, controls0_15_.SelectMethod as SelectMe3_20_8_, decode(controls0_.uuid, controls0_3_.form_id_fk, 3, controls0_4_.form_id_fk, 4, controls0_2_.web_control_id_fk, 2, controls0_5_.web_control_id_fk, 5, controls0_6_.web_control_id_fk, 6, controls0_7_.web_control_id_fk, 7, controls0_8_.web_control_id_fk, 8, controls0_9_.web_control_id_fk, 9, controls0_10_.web_control_id_fk, 10, controls0_11_.web_control_id_fk, 11, controls0_12_.web_control_id_fk, 12, controls0_13_.web_control_id_fk, 13, controls0_14_.web_control_id_fk, 14, controls0_1_.control_id_fk, 1, controls0_15_.control_id_fk, 15, 0), control1_.uuid as uuid5_0_, control1_.id as id5_0_, control1_.parent_id_fk as parent3_5_0_, control1_1_.access_key as access2_6_0_, control1_1_.css_class as css3_6_0_, control1_1_.Enabled as Enabled6_0_, control1_1_.Height as Height6_0_, control1_1_.skin_id as skin6_6_0_, control1_1_.tab_index as tab7_6_0_, control1_1_.tool_tip as tool8_6_0_, control1_1_.style_id_fk as style9_6_0_, control1_1_.attributes_id_fk as attributes10_6_0_, control1_2_.Name as Name7_0_, control1_2_.description as descript3_7_0_, control1_2_.date_created as date4_7_0_, control1_2_.date_last_modified as date5_7_0_, control1_2_.Active as Active7_0_, control1_2_.created_by_id_fk as created7_7_0_, control1_2_.last_modified_by_id_fk as last8_7_0_, control1_3_.search_button_id_fk as search2_8_0_, control1_5_.Text as Text10_0_, control1_6_.Text as Text11_0_, control1_7_.Text as Text12_0_, control1_8_.Text as Text13_0_, control1_9_.Text as Text14_0_, control1_9_.OnClientClick as OnClient3_14_0_, control1_9_.button_type as button4_14_0_, control1_10_.Text as Text15_0_, control1_11_.auto_post_back as auto2_16_0_, control1_11_.max_length as max3_16_0_, control1_11_.Text as Text16_0_, control1_12_.Checked as Checked17_0_, control1_12_.Text as Text17_0_, control1_13_.Checked as Checked18_0_, control1_13_.Text as Text18_0_, control1_14_.AllowPaging as AllowPag2_19_0_, control1_14_.AllowSorting as AllowSor3_19_0_, control1_14_.DataSourceID as DataSour4_19_0_, control1_14_.GridLines as GridLines19_0_, control1_15_.TypeName as TypeName20_0_, control1_15_.SelectMethod as SelectMe3_20_0_, decode(control1_.uuid, control1_3_.form_id_fk, 3, control1_4_.form_id_fk, 4, control1_2_.web_control_id_fk, 2, control1_5_.web_control_id_fk, 5, control1_6_.web_control_id_fk, 6, control1_7_.web_control_id_fk, 7, control1_8_.web_control_id_fk, 8, control1_9_.web_control_id_fk, 9, control1_10_.web_control_id_fk, 10, control1_11_.web_control_id_fk, 11, control1_12_.web_control_id_fk, 12, control1_13_.web_control_id_fk, 13, control1_14_.web_control_id_fk, 14, control1_1_.control_id_fk, 1, control1_15_.control_id_fk, 15, 0), style2_.Id as Id4_1_, attributes3_.Id as Id0_2_, user4_.UUID as UUID24_3_, user4_.Username as Username24_3_, user4_.Password as Password24_3_, user4_.Email as Email24_3_, user4_.last_login as last5_24_3_, user4_.date_created as date6_24_3_, user4_.date_last_modified as date7_24_3_, user4_.Active as Active24_3_, user4_.created_by_id_fk as created9_24_3_, user4_.last_modified_by_id_fk as last10_24_3_, user5_.UUID as UUID24_4_, user5_.Username as Username24_4_, user5_.Password as Password24_4_, user5_.Email as Email24_4_, user5_.last_login as last5_24_4_, user5_.date_created as date6_24_4_, user5_.date_last_modified as date7_24_4_, user5_.Active as Active24_4_, user5_.created_by_id_fk as created9_24_4_, user5_.last_modified_by_id_fk as last10_24_4_, user6_.UUID as UUID24_5_, user6_.Username as Username24_5_, user6_.Password as Password24_5_, user6_.Email as Email24_5_, user6_.last_login as last5_24_5_, user6_.date_created as date6_24_5_, user6_.date_last_modified as date7_24_5_, user6_.Active as Active24_5_, user6_.created_by_id_fk as created9_24_5_, user6_.last_modified_by_id_fk as last10_24_5_, user7_.UUID as UUID24_6_, user7_.Username as Username24_6_, user7_.Password as Password24_6_, user7_.Email as Email24_6_, user7_.last_login as last5_24_6_, user7_.date_created as date6_24_6_, user7_.date_last_modified as date7_24_6_, user7_.Active as Active24_6_, user7_.created_by_id_fk as created9_24_6_, user7_.last_modified_by_id_fk as last10_24_6_, button8_.web_control_id_fk as uuid5_7_, button8_.Text as Text14_7_, button8_.OnClientClick as OnClient3_14_7_, button8_.button_type as button4_14_7_, button8_1_.access_key as access2_6_7_, button8_1_.css_class as css3_6_7_, button8_1_.Enabled as Enabled6_7_, button8_1_.Height as Height6_7_, button8_1_.skin_id as skin6_6_7_, button8_1_.tab_index as tab7_6_7_, button8_1_.tool_tip as tool8_6_7_, button8_1_.style_id_fk as style9_6_7_, button8_1_.attributes_id_fk as attributes10_6_7_, button8_2_.id as id5_7_, button8_2_.parent_id_fk as parent3_5_7_ FROM Control controls0_, WebControl controls0_1_, Form controls0_2_, SearchForm controls0_3_, ResultsViewer controls0_4_, Panel controls0_5_, DropDownList controls0_6_, ListBox controls0_7_, AddRemove controls0_8_, Button controls0_9_, Label controls0_10_, TextBox controls0_11_, RadioButton controls0_12_, CheckBox controls0_13_, GridView controls0_14_, ObjectDataSource controls0_15_, Control control1_, WebControl control1_1_, Form control1_2_, SearchForm control1_3_, ResultsViewer control1_4_, Panel control1_5_, DropDownList control1_6_, ListBox control1_7_, AddRemove control1_8_, Button control1_9_, Label control1_10_, TextBox control1_11_, RadioButton control1_12_, CheckBox control1_13_, GridView control1_14_, ObjectDataSource control1_15_, Style style2_, Attributes attributes3_, Users user4_, Users user5_, Users user6_, Users user7_, Button button8_, WebControl button8_1_, Control button8_2_ WHERE controls0_.parent_id_fk=control1_.uuid(+) and control1_.uuid=control1_1_.control_id_fk(+) and control1_.uuid=control1_2_.web_control_id_fk(+) and control1_.uuid=control1_3_.form_id_fk(+) and control1_.uuid=control1_4_.form_id_fk(+) and control1_.uuid=control1_5_.web_control_id_fk(+) and control1_.uuid=control1_6_.web_control_id_fk(+) and control1_.uuid=control1_7_.web_control_id_fk(+) and control1_.uuid=control1_8_.web_control_id_fk(+) and control1_.uuid=control1_9_.web_control_id_fk(+) and control1_.uuid=control1_10_.web_control_id_fk(+) and control1_.uuid=control1_11_.web_control_id_fk(+) and control1_.uuid=control1_12_.web_control_id_fk(+) and control1_.uuid=control1_13_.web_control_id_fk(+) and control1_.uuid=control1_14_.web_control_id_fk(+) and control1_.uuid=control1_15_.control_id_fk(+) and control1_1_.style_id_fk=style2_.Id(+) and control1_1_.attributes_id_fk=attributes3_.Id(+) and control1_2_.created_by_id_fk=user4_.UUID(+) and user4_.created_by_id_fk=user5_.UUID(+) and user5_.last_modified_by_id_fk=user6_.UUID(+) and control1_2_.last_modified_by_id_fk=user7_.UUID(+) and control1_3_.search_button_id_fk=button8_.web_control_id_fk(+) and button8_.web_control_id_fk=button8_1_.control_id_fk(+) and button8_.web_control_id_fk=button8_2_.uuid(+) and controls0_.uuid=controls0_1_.control_id_fk(+) and controls0_.uuid=controls0_2_.web_control_id_fk(+) and controls0_.uuid=controls0_3_.form_id_fk(+) and controls0_.uuid=controls0_4_.form_id_fk(+) and controls0_.uuid=controls0_5_.web_control_id_fk(+) and controls0_.uuid=controls0_6_.web_control_id_fk(+) and controls0_.uuid=controls0_7_.web_control_id_fk(+) and controls0_.uuid=controls0_8_.web_control_id_fk(+) and controls0_.uuid=controls0_9_.web_control_id_fk(+) and controls0_.uuid=controls0_10_.web_control_id_fk(+) and controls0_.uuid=controls0_11_.web_control_id_fk(+) and controls0_.uuid=controls0_12_.web_control_id_fk(+) and controls0_.uuid=controls0_13_.web_control_id_fk(+) and controls0_.uuid=controls0_14_.web_control_id_fk(+) and controls0_.uuid=controls0_15_.control_id_fk(+) AND controls0_.form_id_fk=?] ---> System.IndexOutOfRangeException: clazz_8_
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.OracleClient.OracleDataReader.GetOrdinal(String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name, ISessionImplementor session, Object owner)
at NHibernate.Loader.Loader.GetInstanceClass(IDataReader rs, Int32 i, ILoadable persister, Object id, ISessionImplementor session)
at NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.LoadCollection(ISessionImplementor session, Object id, IType type)
--- End of inner exception stack trace ---
at NHibernate.Loader.Loader.LoadCollection(ISessionImplementor session, Object id, IType type)
at NHibernate.Loader.Collection.CollectionLoader.Initialize(Object id, ISessionImplementor session)
at NHibernate.Persister.Collection.AbstractCollectionPersister.Initialize(Object key, ISessionImplementor session)
at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing)
at NHibernate.Collection.AbstractPersistentCollection.Initialize(Boolean writing)
--- End of inner exception stack trace ---
A first chance exception of type 'NHibernate.LazyInitializationException' occurred in NHibernate.DLL
Name and version of the database you are using:Oracle 10g Express Edition
The generated SQL (show_sql=true):Code:
SELECT controls0_.form_id_fk as form4___9_, controls0_.uuid as uuid9_, controls0_.uuid as uuid5_8_, controls0_.id as id5_8_, controls0_.parent_id_fk as parent3_5_8_, controls0_1_.access_key as access2_6_8_, controls0_1_.css_class as css3_6_8_, controls0_1_.Enabled as Enabled6_8_, controls0_1_.Height as Height6_8_, controls0_1_.skin_id as skin6_6_8_, controls0_1_.tab_index as tab7_6_8_, controls0_1_.tool_tip as tool8_6_8_, controls0_1_.style_id_fk as style9_6_8_, controls0_1_.attributes_id_fk as attributes10_6_8_, controls0_2_.Name as Name7_8_, controls0_2_.description as descript3_7_8_, controls0_2_.date_created as date4_7_8_, controls0_2_.date_last_modified as date5_7_8_, controls0_2_.Active as Active7_8_, controls0_2_.created_by_id_fk as created7_7_8_, controls0_2_.last_modified_by_id_fk as last8_7_8_, controls0_3_.search_button_id_fk as search2_8_8_, controls0_5_.Text as Text10_8_, controls0_6_.Text as Text11_8_, controls0_7_.Text as Text12_8_, controls0_8_.Text as Text13_8_, controls0_9_.Text as Text14_8_, controls0_9_.OnClientClick as OnClient3_14_8_, controls0_9_.button_type as button4_14_8_, controls0_10_.Text as Text15_8_, controls0_11_.auto_post_back as auto2_16_8_, controls0_11_.max_length as max3_16_8_, controls0_11_.Text as Text16_8_, controls0_12_.Checked as Checked17_8_, controls0_12_.Text as Text17_8_, controls0_13_.Checked as Checked18_8_, controls0_13_.Text as Text18_8_, controls0_14_.AllowPaging as AllowPag2_19_8_, controls0_14_.AllowSorting as AllowSor3_19_8_, controls0_14_.DataSourceID as DataSour4_19_8_, controls0_14_.GridLines as GridLines19_8_, controls0_15_.TypeName as TypeName20_8_, controls0_15_.SelectMethod as SelectMe3_20_8_, decode(controls0_.uuid, controls0_3_.form_id_fk, 3, controls0_4_.form_id_fk, 4, controls0_2_.web_control_id_fk, 2, controls0_5_.web_control_id_fk, 5, controls0_6_.web_control_id_fk, 6, controls0_7_.web_control_id_fk, 7, controls0_8_.web_control_id_fk, 8, controls0_9_.web_control_id_fk, 9, controls0_10_.web_control_id_fk, 10, controls0_11_.web_control_id_fk, 11, controls0_12_.web_control_id_fk, 12, controls0_13_.web_control_id_fk, 13, controls0_14_.web_control_id_fk, 14, controls0_1_.control_id_fk, 1, controls0_15_.control_id_fk, 15, 0), control1_.uuid as uuid5_0_, control1_.id as id5_0_, control1_.parent_id_fk as parent3_5_0_, control1_1_.access_key as access2_6_0_, control1_1_.css_class as css3_6_0_, control1_1_.Enabled as Enabled6_0_, control1_1_.Height as Height6_0_, control1_1_.skin_id as skin6_6_0_, control1_1_.tab_index as tab7_6_0_, control1_1_.tool_tip as tool8_6_0_, control1_1_.style_id_fk as style9_6_0_, control1_1_.attributes_id_fk as attributes10_6_0_, control1_2_.Name as Name7_0_, control1_2_.description as descript3_7_0_, control1_2_.date_created as date4_7_0_, control1_2_.date_last_modified as date5_7_0_, control1_2_.Active as Active7_0_, control1_2_.created_by_id_fk as created7_7_0_, control1_2_.last_modified_by_id_fk as last8_7_0_, control1_3_.search_button_id_fk as search2_8_0_, control1_5_.Text as Text10_0_, control1_6_.Text as Text11_0_, control1_7_.Text as Text12_0_, control1_8_.Text as Text13_0_, control1_9_.Text as Text14_0_, control1_9_.OnClientClick as OnClient3_14_0_, control1_9_.button_type as button4_14_0_, control1_10_.Text as Text15_0_, control1_11_.auto_post_back as auto2_16_0_, control1_11_.max_length as max3_16_0_, control1_11_.Text as Text16_0_, control1_12_.Checked as Checked17_0_, control1_12_.Text as Text17_0_, control1_13_.Checked as Checked18_0_, control1_13_.Text as Text18_0_, control1_14_.AllowPaging as AllowPag2_19_0_, control1_14_.AllowSorting as AllowSor3_19_0_, control1_14_.DataSourceID as DataSour4_19_0_, control1_14_.GridLines as GridLines19_0_, control1_15_.TypeName as TypeName20_0_, control1_15_.SelectMethod as SelectMe3_20_0_, decode(control1_.uuid, control1_3_.form_id_fk, 3, control1_4_.form_id_fk, 4, control1_2_.web_control_id_fk, 2, control1_5_.web_control_id_fk, 5, control1_6_.web_control_id_fk, 6, control1_7_.web_control_id_fk, 7, control1_8_.web_control_id_fk, 8, control1_9_.web_control_id_fk, 9, control1_10_.web_control_id_fk, 10, control1_11_.web_control_id_fk, 11, control1_12_.web_control_id_fk, 12, control1_13_.web_control_id_fk, 13, control1_14_.web_control_id_fk, 14, control1_1_.control_id_fk, 1, control1_15_.control_id_fk, 15, 0), style2_.Id as Id4_1_, attributes3_.Id as Id0_2_, user4_.UUID as UUID24_3_, user4_.Username as Username24_3_, user4_.Password as Password24_3_, user4_.Email as Email24_3_, user4_.last_login as last5_24_3_, user4_.date_created as date6_24_3_, user4_.date_last_modified as date7_24_3_, user4_.Active as Active24_3_, user4_.created_by_id_fk as created9_24_3_, user4_.last_modified_by_id_fk as last10_24_3_, user5_.UUID as UUID24_4_, user5_.Username as Username24_4_, user5_.Password as Password24_4_, user5_.Email as Email24_4_, user5_.last_login as last5_24_4_, user5_.date_created as date6_24_4_, user5_.date_last_modified as date7_24_4_, user5_.Active as Active24_4_, user5_.created_by_id_fk as created9_24_4_, user5_.last_modified_by_id_fk as last10_24_4_, user6_.UUID as UUID24_5_, user6_.Username as Username24_5_, user6_.Password as Password24_5_, user6_.Email as Email24_5_, user6_.last_login as last5_24_5_, user6_.date_created as date6_24_5_, user6_.date_last_modified as date7_24_5_, user6_.Active as Active24_5_, user6_.created_by_id_fk as created9_24_5_, user6_.last_modified_by_id_fk as last10_24_5_, user7_.UUID as UUID24_6_, user7_.Username as Username24_6_, user7_.Password as Password24_6_, user7_.Email as Email24_6_, user7_.last_login as last5_24_6_, user7_.date_created as date6_24_6_, user7_.date_last_modified as date7_24_6_, user7_.Active as Active24_6_, user7_.created_by_id_fk as created9_24_6_, user7_.last_modified_by_id_fk as last10_24_6_, button8_.web_control_id_fk as uuid5_7_, button8_.Text as Text14_7_, button8_.OnClientClick as OnClient3_14_7_, button8_.button_type as button4_14_7_, button8_1_.access_key as access2_6_7_, button8_1_.css_class as css3_6_7_, button8_1_.Enabled as Enabled6_7_, button8_1_.Height as Height6_7_, button8_1_.skin_id as skin6_6_7_, button8_1_.tab_index as tab7_6_7_, button8_1_.tool_tip as tool8_6_7_, button8_1_.style_id_fk as style9_6_7_, button8_1_.attributes_id_fk as attributes10_6_7_, button8_2_.id as id5_7_, button8_2_.parent_id_fk as parent3_5_7_ FROM Control controls0_, WebControl controls0_1_, Form controls0_2_, SearchForm controls0_3_, ResultsViewer controls0_4_, Panel controls0_5_, DropDownList controls0_6_, ListBox controls0_7_, AddRemove controls0_8_, Button controls0_9_, Label controls0_10_, TextBox controls0_11_, RadioButton controls0_12_, CheckBox controls0_13_, GridView controls0_14_, ObjectDataSource controls0_15_, Control control1_, WebControl control1_1_, Form control1_2_, SearchForm control1_3_, ResultsViewer control1_4_, Panel control1_5_, DropDownList control1_6_, ListBox control1_7_, AddRemove control1_8_, Button control1_9_, Label control1_10_, TextBox control1_11_, RadioButton control1_12_, CheckBox control1_13_, GridView control1_14_, ObjectDataSource control1_15_, Style style2_, Attributes attributes3_, Users user4_, Users user5_, Users user6_, Users user7_, Button button8_, WebControl button8_1_, Control button8_2_ WHERE controls0_.parent_id_fk=control1_.uuid(+) and control1_.uuid=control1_1_.control_id_fk(+) and control1_.uuid=control1_2_.web_control_id_fk(+) and control1_.uuid=control1_3_.form_id_fk(+) and control1_.uuid=control1_4_.form_id_fk(+) and control1_.uuid=control1_5_.web_control_id_fk(+) and control1_.uuid=control1_6_.web_control_id_fk(+) and control1_.uuid=control1_7_.web_control_id_fk(+) and control1_.uuid=control1_8_.web_control_id_fk(+) and control1_.uuid=control1_9_.web_control_id_fk(+) and control1_.uuid=control1_10_.web_control_id_fk(+) and control1_.uuid=control1_11_.web_control_id_fk(+) and control1_.uuid=control1_12_.web_control_id_fk(+) and control1_.uuid=control1_13_.web_control_id_fk(+) and control1_.uuid=control1_14_.web_control_id_fk(+) and control1_.uuid=control1_15_.control_id_fk(+) and control1_1_.style_id_fk=style2_.Id(+) and control1_1_.attributes_id_fk=attributes3_.Id(+) and control1_2_.created_by_id_fk=user4_.UUID(+) and user4_.created_by_id_fk=user5_.UUID(+) and user5_.last_modified_by_id_fk=user6_.UUID(+) and control1_2_.last_modified_by_id_fk=user7_.UUID(+) and control1_3_.search_button_id_fk=button8_.web_control_id_fk(+) and button8_.web_control_id_fk=button8_1_.control_id_fk(+) and button8_.web_control_id_fk=button8_2_.uuid(+) and controls0_.uuid=controls0_1_.control_id_fk(+) and controls0_.uuid=controls0_2_.web_control_id_fk(+) and controls0_.uuid=controls0_3_.form_id_fk(+) and controls0_.uuid=controls0_4_.form_id_fk(+) and controls0_.uuid=controls0_5_.web_control_id_fk(+) and controls0_.uuid=controls0_6_.web_control_id_fk(+) and controls0_.uuid=controls0_7_.web_control_id_fk(+) and controls0_.uuid=controls0_8_.web_control_id_fk(+) and controls0_.uuid=controls0_9_.web_control_id_fk(+) and controls0_.uuid=controls0_10_.web_control_id_fk(+) and controls0_.uuid=controls0_11_.web_control_id_fk(+) and controls0_.uuid=controls0_12_.web_control_id_fk(+) and controls0_.uuid=controls0_13_.web_control_id_fk(+) and controls0_.uuid=controls0_14_.web_control_id_fk(+) and controls0_.uuid=controls0_15_.control_id_fk(+) AND controls0_.form_id_fk=?
Problems with Session and transaction handling?
No, but I am using NHibernator to manage the session
Thanks,
Perry