-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 
Author Message
 Post subject: joined-subclass mapping throwing IndexOutOfRangeException?
PostPosted: Tue Apr 15, 2008 10:23 am 
Newbie

Joined: Wed Feb 20, 2008 3:03 pm
Posts: 5
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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 15, 2008 1:59 pm 
Regular
Regular

Joined: Mon Mar 20, 2006 10:49 pm
Posts: 59
Check that the column specified by the index element of your lists has values 0 to n-1 for each instance of the lists' parent classes.

_________________
Mike Abraham


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 15, 2008 3:08 pm 
Newbie

Joined: Wed Feb 20, 2008 3:03 pm
Posts: 5
Well fortunately for me I guess a new version of NHibernate was released last week. After upgrading to the new .dll, and consequently upgrading the Castle .dlls, all is well. In fact, all was well with this mapping document when I used a table-per-hierarchy inheritance strategy, but broke when I changed subclass to joined-subclass, and exchanged my discriminator columns for keys. So I think the CastleDynamicProxy.dll that NHibernate 1.2.1.4000 was using simply couldn't handle nested joined-subclasses... but that's just speculation.

Again, upgrading alone fixed the problem...

Thanks for your suggestion though.
Perry


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 21, 2008 10:45 am 
Beginner
Beginner

Joined: Thu Apr 27, 2006 5:49 am
Posts: 31
plucas wrote:
Well fortunately for me I guess a new version of NHibernate was released last week. After upgrading to the new .dll, and consequently upgrading the Castle .dlls, all is well. In fact, all was well with this mapping document when I used a table-per-hierarchy inheritance strategy, but broke when I changed subclass to joined-subclass, and exchanged my discriminator columns for keys. So I think the CastleDynamicProxy.dll that NHibernate 1.2.1.4000 was using simply couldn't handle nested joined-subclasses... but that's just speculation.

Again, upgrading alone fixed the problem...

Thanks for your suggestion though.
Perry


Perry,

I want to ask you if you experienced the problem all the time you call the query? I ask you this because I have the similar problem, but not all the time I call the query method. It happens sometimes which can be seen in application logs, but I can't reproduce it even on the same data.

I use NHibernate 1.2.0.4000 and I am interested to know if version upgrade will fix the bug.


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 30, 2008 7:22 pm 
Beginner
Beginner

Joined: Thu Oct 20, 2005 9:26 am
Posts: 27
Location: Barcelona
I'm also experiencing something similar, but it's intermittent.
When I try and copy the exact sql statement and run it on the database, everything is fine.
Did you find out what the problem was?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jun 11, 2008 10:41 pm 
Newbie

Joined: Wed Feb 20, 2008 3:03 pm
Posts: 5
Ishitori, dgivoni:

I'm sorry I didn't notice your posts until now.

The problem only appeared when I decided to move from using subclass over to using joined-subclass in my mapping documents (.hbm.xml). I started out using a single hierarchy schema because my subclasses were similar enough that it made sense, but as the model grew more diverse I decided to break away from that. Switching over to joined-subclass yielded this error, but I have a feeling that the bug actually lies within the CastleDynamicProxy.dll that Nhibernate 1.2.xxx uses.

So, to get straight to the point, the "broken" mapping file (modified to use joined-subclass) without any further modifications actually works perfectly using the upgraded NHibernate .dll (v2.0). So, one can only assume that this problem was discovered and fixed in this release. But I am very leary of using this version in a production environment, however, as it is still in ALPHA phase.

Also, to answer your other question, after moving to joined-subclass this error occurred consistently... every time... I am thinking the number of joins was just too large for this version to handle.

HTH.
Perry


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.