-->
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.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 
  Previous topic | Next topic 
Author Message
ecrutchfield
 Post subject: problem implementing "select new class()" feature
PostPosted: Tue May 31, 2005 10:41 am 
Newbie

Joined: Mon May 16, 2005 2:08 pm
Posts: 2
I'm having trouble getting the "select new class()" feature to work. I followed the guidance from http://nhibernate.sourceforge.net/forum/viewtopic.php?t=106, so I now have the <import .../> tag in a mapping file. But, I still get the "class not found" error. Can someone point me in the right direction?
The Exception is: Exception: NHibernate.QueryException Message: class not found: Business.Category [select new Business.Category(cat.Name, subCategories, items) ...

TIA,
Eric


Here's the mapping/code/log:

Code:
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
   <import class="Business.Category,Business" />
   <class name="Business.AbstractCategorySpecification,Business" table="AKBCATEGORY">
      <id name="CategoryId" column="AKBCATEGORYID" type="Int32" unsaved-value="0" access="nosetter.camelcase">
         <generator class="native"/>
      </id>
      <discriminator column="Type" type="String" />
      <property column="NAME" type="String" name="Name" length="256" />
      <subclass discriminator-value="C" name="Business.CategorySpecification,Business">
         <set name="SubCategorySpecifications" cascade="save-update" access="nosetter.camelcase" order-by="[Name] asc">
            <key column="akbParentCategoryId" />
            <one-to-many class="Business.SubCategorySpecification, Business"/>
         </set>
      </subclass>
      <subclass discriminator-value="S" name="Business.SubCategorySpecification,Business">
         <many-to-one name="ParentCategory" column="AKBPARENTCATEGORYID" class="Business.CategorySpecification,Business" not-null="true" access="nosetter.camelcase"/>
         <set name="AssociatedContentItems" inverse="true" access="nosetter.camelcase" lazy="true" table="akbItemCategory">
            <key column="akbCategoryId" />
            <many-to-many class="Business.AbstractContentItem, Business" column="akbItemId"/>
         </set>
      </subclass>      
   </class>
</hibernate-mapping>


Code:
namespace Business
{
   using System;
   using System.Collections;
   using log4net;
   using DataAccess;

   /// <summary>
   /// Summary description for Category.
   /// </summary>
   public class Category
   {
      #region Private attributes
      private static readonly ILog log = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
      private string name;
      private IList subCategories;
      #endregion

      public string Name
      {
         get
         {
            return this.name;
         }
      }

      public IList SubCategories
      {
         get
         {
            return this.subCategories;
         }
      }

      public Category(string name, Iesi.Collections.ISet subCategories, Iesi.Collections.ISet contentItems)
      {
         this.name = name;
         this.subCategories = new ArrayList(subCategories.Count);
      }
   }
   
   
}


query:
"select new Business.Category(cat.Name, subCategories, items) from Business.CategorySpecification as cat ";
" join cat.SubCategorySpecifications as subCategories ";
" join subCategories.AssociatedContentItems as items ";

LOG (this is a selection of log messages, since the full log was over 700 lines long!):
NHibernate.Cfg.Environment DEBUG 2005-05-31 10:09:59.907 connection.provider=NHibernate.Connection.DriverConnectionProvider
NHibernate.Cfg.Configuration DEBUG 2005-05-31 10:10:00.247 connection.driver_class=NHibernate.Driver.SqlClientDriver
NHibernate.Cfg.Configuration DEBUG 2005-05-31 10:10:00.257 connection.connection_string=Server=localhost;initial catalog=library;user id=<hidden>;password=<hidden>
NHibernate.Cfg.Configuration DEBUG 2005-05-31 10:10:00.257 show_sql=false
NHibernate.Cfg.Configuration DEBUG 2005-05-31 10:10:00.267 dialect=NHibernate.Dialect.MsSql2000Dialect
NHibernate.Cfg.Configuration DEBUG 2005-05-31 10:10:00.267 use_outer_join=true
NHibernate.Cfg.Configuration DEBUG 2005-05-31 10:10:00.277 query.substitutions=true 1, false 0, yes 'Y', no 'N'
NHibernate.Cfg.Configuration DEBUG 2005-05-31 10:10:00.287 DataAccess.NHibernateSessionManager<-Business
NHibernate.Cfg.Configuration DEBUG 2005-05-31 10:10:00.287 searching for mapped documents in assembly: Business
NHibernate.Cfg.Configuration INFO 2005-05-31 10:10:00.297 Found mapping documents in assembly: Business.hbm.Region.hbm.xml
NHibernate.Cfg.Configuration INFO 2005-05-31 10:10:00.327 Using dialect: NHibernate.Dialect.MsSql2000Dialect
NHibernate.Dialect.Dialect INFO 2005-05-31 10:10:00.377 Mapping class: Business.Region -> AKBREGION
NHibernate.Cfg.Configuration INFO 2005-05-31 10:10:01.923 Using dialect: NHibernate.Dialect.MsSql2000Dialect
NHibernate.Dialect.Dialect INFO 2005-05-31 10:10:01.933 Mapping class: Business.AbstractCategorySpecification -> AKBCATEGORY
NHibernate.Cfg.Binder INFO 2005-05-31 10:10:01.933 Mapped property: CategoryId -> AKBCATEGORYID, type: Int32
NHibernate.Cfg.Binder DEBUG 2005-05-31 10:10:01.943 Mapped property: Name -> NAME, type: String
NHibernate.Cfg.Binder DEBUG 2005-05-31 10:10:01.943 Mapping subclass: Business.CategorySpecification -> AKBCATEGORY
NHibernate.Cfg.Binder INFO 2005-05-31 10:10:01.953 Mapped property: SubCategorySpecifications, type: ISet
NHibernate.Cfg.Binder DEBUG 2005-05-31 10:10:01.963 Mapping subclass: Business.SubCategorySpecification -> AKBCATEGORY
NHibernate.Cfg.Binder INFO 2005-05-31 10:10:01.963 Mapped property: ParentCategory -> AKBPARENTCATEGORYID, type: CategorySpecification
NHibernate.Cfg.Binder DEBUG 2005-05-31 10:10:01.973 Mapping collection: Business.SubCategorySpecification.AssociatedContentItems -> akbItemCategory
NHibernate.Cfg.Binder INFO 2005-05-31 10:10:01.983 Mapped property: AssociatedContentItems, type: ISet
NHibernate.Cfg.Binder DEBUG 2005-05-31 10:10:01.983 Import: Category -> Business.Category,Business
NHibernate.Cfg.Binder DEBUG 2005-05-31 10:10:01.993 Configured SessionFactory: DataAccess.NHibernateSessionManager
NHibernate.Cfg.Configuration INFO 2005-05-31 10:10:02.003 properties: System.Collections.Hashtable
NHibernate.Cfg.Configuration DEBUG 2005-05-31 10:10:02.003 searching for mapped documents in assembly: Business
NHibernate.Cfg.Configuration INFO 2005-05-31 10:10:02.013 Found mapping documents in assembly: Business.hbm.Region.hbm.xml
NHibernate.Dialect.Dialect INFO 2005-05-31 10:10:05.207 use outer join fetching: True
NHibernate.Cfg.SettingsFactory INFO 2005-05-31 10:10:05.217 Intitializing connection provider: NHibernate.Connection.DriverConnectionProvider
NHibernate.Connection.ConnectionProviderFactory INFO 2005-05-31 10:10:05.227 Configuring ConnectionProvider
NHibernate.Connection.ConnectionProvider INFO 2005-05-31 10:10:05.237 Query language substitutions: yes='Y';true=1;no='N';false=0;
NHibernate.Cfg.SettingsFactory INFO 2005-05-31 10:10:05.237 cache provider: NHibernate.Cache.HashtableCacheProvider
NHibernate.Cfg.SettingsFactory INFO 2005-05-31 10:10:05.247 instantiating and configuring caches
NHibernate.Cfg.Configuration INFO 2005-05-31 10:10:05.257 building session factory
NHibernate.Impl.SessionFactoryImpl INFO 2005-05-31 10:10:05.287 instantiating session factory with properties: show_sql=false;connection.provider=NHibernate.Connection.DriverConnectionProvider;dialect=NHibernate.Dialect.MsSql2000Dialect;connection.driver_class=NHibernate.Driver.SqlClientDriver;hibernate.session_factory
NHibernate.Impl.SessionFactoryImpl DEBUG 2005-05-31 10:10:05.287 The initial capacity was set too low at: 9 for the SelectSqlBuilder that needed a capacity of: 11 for the table AKBHISTORY versionc0_
NHibernate.SqlCommand.SqlSelectBuilder DEBUG 2005-05-31 10:10:05.397 The initial capacity was set too low at: 12 for the SelectSqlBuilder that needed a capacity of: 14 for the table AKBCATEGORY subcateg0_
NHibernate.SqlCommand.SqlSelectBuilder DEBUG 2005-05-31 10:10:05.407 The initial capacity was set too low at: 9 for the SelectSqlBuilder that needed a capacity of: 11 for the table AKBHISTORY versionc0_
NHibernate.SqlCommand.SqlSelectBuilder DEBUG 2005-05-31 10:10:05.417 initializing class SessionFactoryObjectFactory
NHibernate.Impl.SessionFactoryObjectFactory DEBUG 2005-05-31 10:10:05.437 registered: 0fefd9b91078429da81fd0c433f2ab4a(DataAccess.NHibernateSessionManager)
NHibernate.Impl.SessionFactoryObjectFactory DEBUG 2005-05-31 10:10:05.447 Factory name:DataAccess.NHibernateSessionManager
NHibernate.Impl.SessionFactoryObjectFactory INFO 2005-05-31 10:10:05.457 Instantiated session factory
NHibernate.Impl.SessionFactoryImpl DEBUG 2005-05-31 10:10:05.457 opened session
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.520 Couldn't find an existing AppUser instance in the HttpSession, so trying to get it from the database.
Business.SecurityManager DEBUG 2005-05-31 10:10:05.530 Getting AppUser instance using 335\IM481
Business.AppUser DEBUG 2005-05-31 10:10:05.530 search: AppUser
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.550 criteria: System.Collections.ArrayList
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.560 The initial capacity was set too low at: 12 for the SelectSqlBuilder that needed a capacity of: 14 for the table AKBUSER this
NHibernate.SqlCommand.SqlSelectBuilder DEBUG 2005-05-31 10:10:05.570 flushing session
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.580 Flushing entities and processing referenced collections
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.590 Processing unreferenced collections
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.590 Processed 0 unreachable collections.
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.600 scheduling collection removes/(re)creates/updates
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.600 Processed 0 for recreate (0), remove (0), and update (0)
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.610 Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.620 Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.620 dont need to execute flush
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.630 about to open: 0 open IDbCommands, 0 open DataReaders
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:05.640 Building an IDbCommand object for the SqlString: SELECT this.AccesserId as AccesserId1_, this.UserName as UserName1_, this.FirstName as FirstName1_, this.LoginType as LoginType1_, this.Email as Email1_, this.LastName as LastName1_, usersess1_.akbSessionID
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:05.650 binding '335\IM481' to parameter: 0
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.650 SELECT this.AccesserId as AccesserId1_, this.UserName as UserName1_, this.FirstName as FirstName1_, this.LoginType as LoginType1_, this.Email as Email1_, this.LastName as LastName1_, usersess1_.akbSessionID as akbSessi1_0_, usersess1_.CafeUserSessionID as
NHibernate.Loader.Loader INFO 2005-05-31 10:10:05.660 Preparing SELECT this.AccesserId as AccesserId1_, this.UserName as UserName1_, this.FirstName as FirstName1_, this.LoginType as LoginType1_, this.Email as Email1_, this.LastName as LastName1_, usersess1_.akbSessionID as akbSessi1_0_, usersess1_.CafeUserSes
NHibernate.Impl.BatcherImpl INFO 2005-05-31 10:10:05.670 Obtaining IDbConnection from Driver
NHibernate.Connection.DriverConnectionProvider DEBUG 2005-05-31 10:10:05.680 processing result set
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:05.750 returning '10' as column: akbSessi1_0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.770 returning '2ada076f42a247d0b3bd1de3c30594dc' as column: AccesserId1_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.770 result row: 10, 2ada076f42a247d0b3bd1de3c30594dc
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:05.780 Initializing object from DataReader: 10
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:05.790 Hydrating entity: Business.UserSession#10
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:05.800 returning '1' as column: CafeUser2_0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.800 returning 'True' as column: CanOrder0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.810 returning 'Content Administrator' as column: Role0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.820 returning null as column: LASTEMAI9_0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.830 returning '6/5/2005' as column: EXPIRES0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.830 returning '2ada076f42a247d0b3bd1de3c30594dc' as column: CafeUserID0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.840 returning null as column: LASTEMA10_0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.900 returning 'Testing' as column: AKBAUTHKEY0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.900 returning 'Testing' as column: CAFEAUTH7_0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.910 Initializing object from DataReader: 2ada076f42a247d0b3bd1de3c30594dc
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:05.920 Hydrating entity: Business.AppUser#2ada076f42a247d0b3bd1de3c30594dc
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:05.920 returning '335\IM481' as column: UserName1_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.930 returning 'NAKARIN BEN' as column: FirstName1_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.940 returning 'ChildAgent' as column: LoginType1_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.940 returning '' as column: Email1_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.950 returning 'ROJVONGPAISAL' as column: LastName1_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:05.960 done processing result set (1 rows)
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:05.960 done closing: 0 open IDbCommands, 0 open DataReaders
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:05.970 total objects hydrated: 2
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:05.980 resolving associations for: [Business.UserSession#10]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.980 creating collection wrapper:[Business.UserSession.selectedStates#10]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:05.990 done materializing entity [Business.UserSession#10]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.000 resolving associations for: [Business.AppUser#2ada076f42a247d0b3bd1de3c30594dc]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.010 creating collection wrapper:[Business.AppUser.groupProfiles#2ada076f42a247d0b3bd1de3c30594dc]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.020 about to open: 0 open IDbCommands, 0 open DataReaders
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:06.020 Building an IDbCommand object for the SqlString: SELECT usersess0_.akbSessionID as akbSessi1_0_, usersess0_.CafeUserSessionID as CafeUser2_0_, usersess0_.CanOrder as CanOrder0_, usersess0_.Role as Role0_, usersess0_.LASTEMAILFROM as LASTEMAI9_0_, usersess0
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:06.030 binding '2ada076f42a247d0b3bd1de3c30594dc' to parameter: 0
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:06.040 SELECT usersess0_.akbSessionID as akbSessi1_0_, usersess0_.CafeUserSessionID as CafeUser2_0_, usersess0_.CanOrder as CanOrder0_, usersess0_.Role as Role0_, usersess0_.LASTEMAILFROM as LASTEMAI9_0_, usersess0_.EXPIRES as EXPIRES0_, usersess0_.CafeUserID as
NHibernate.Loader.Loader INFO 2005-05-31 10:10:06.040 Preparing SELECT usersess0_.akbSessionID as akbSessi1_0_, usersess0_.CafeUserSessionID as CafeUser2_0_, usersess0_.CanOrder as CanOrder0_, usersess0_.Role as Role0_, usersess0_.LASTEMAILFROM as LASTEMAI9_0_, usersess0_.EXPIRES as EXPIRES0_, usersess0_.Cafe
NHibernate.Impl.BatcherImpl INFO 2005-05-31 10:10:06.050 processing result set
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.060 returning '10' as column: akbSessi1_0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:06.060 result row: 10
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.070 done processing result set (1 rows)
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.080 done closing: 0 open IDbCommands, 0 open DataReaders
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:06.080 total objects hydrated: 0
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.090 done materializing entity [Business.AppUser#2ada076f42a247d0b3bd1de3c30594dc]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.100 initializing non-lazy collections
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.100 initializing collection [Business.AppUser.groupProfiles#2ada076f42a247d0b3bd1de3c30594dc]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.110 checking second-level cache
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.120 collection not cached
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.120 about to open: 0 open IDbCommands, 0 open DataReaders
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:06.130 Building an IDbCommand object for the SqlString: SELECT akbuserg0_.AccesserId as AccesserId__, akbuserg0_.akbGroupProfileId as akbGroup2___, grouppro1_.AKBGROUPPROFILEID as AKBGROUP1_0_, grouppro1_.NAME as NAME0_, grouppro1_.DESCRIPTION as DESCRIPT3_0_ FRO
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:06.140 binding '2ada076f42a247d0b3bd1de3c30594dc' to parameter: 0
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:06.150 SELECT akbuserg0_.AccesserId as AccesserId__, akbuserg0_.akbGroupProfileId as akbGroup2___, grouppro1_.AKBGROUPPROFILEID as AKBGROUP1_0_, grouppro1_.NAME as NAME0_, grouppro1_.DESCRIPTION as DESCRIPT3_0_ FROM akbUserGroupProfile akbuserg0_ inner join AKBGR
NHibernate.Loader.Loader INFO 2005-05-31 10:10:06.150 Preparing SELECT akbuserg0_.AccesserId as AccesserId__, akbuserg0_.akbGroupProfileId as akbGroup2___, grouppro1_.AKBGROUPPROFILEID as AKBGROUP1_0_, grouppro1_.NAME as NAME0_, grouppro1_.DESCRIPTION as DESCRIPT3_0_ FROM akbUserGroupProfile akbuserg0_ inner
NHibernate.Impl.BatcherImpl INFO 2005-05-31 10:10:06.160 result set contains (possibly empty) collection: [Business.AppUser.groupProfiles#2ada076f42a247d0b3bd1de3c30594dc]
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.393 uninitialized collection: initializing
NHibernate.Impl.SessionImpl INFO 2005-05-31 10:10:06.403 processing result set
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.403 returning '36' as column: AKBGROUP1_0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:06.413 result row: 36
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.423 Initializing object from DataReader: 36
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.433 Hydrating entity: Business.GroupProfile#36
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.433 returning 'Life Annuity plus GSL' as column: NAME0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:06.443 returning 'Used with regions that sell both 335 products and GSL, requested by Amy Johnson.' as column: DESCRIPT3_0_
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:06.443 returning '2ada076f42a247d0b3bd1de3c30594dc' as column: AccesserId__
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:06.453 found row of collection: [Business.AppUser.groupProfiles#2ada076f42a247d0b3bd1de3c30594dc]
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.463 reading row
NHibernate.Impl.SessionImpl INFO 2005-05-31 10:10:06.463 returning '36' as column: akbGroup2___
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:06.473 loading [GroupProfile#36]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.483 attempting to resolve [GroupProfile#36]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.493 resolved object in session cache [Business.GroupProfile#36]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.503 done processing result set (1 rows)
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.503 done closing: 0 open IDbCommands, 0 open DataReaders
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:06.513 total objects hydrated: 1
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.523 resolving associations for: [Business.GroupProfile#36]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.533 creating collection wrapper:[Business.GroupProfile.Regions#36]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.533 done materializing entity [Business.GroupProfile#36]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.543 1 collections were found in result set
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.553 collection fully initialized: [Business.AppUser.groupProfiles#2ada076f42a247d0b3bd1de3c30594dc]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.553 1 collections initialized
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.563 collection initialized
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.563 initializing collection [Business.UserSession.selectedStates#10]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.573 checking second-level cache
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.583 collection not cached
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.583 about to open: 0 open IDbCommands, 0 open DataReaders
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:06.593 Building an IDbCommand object for the SqlString: SELECT akbstate0_.akbSessionID as akbSessi3___, akbstate0_.akbStateCountryID as akbState4___, statecou1_.akbStateCountryID as akbState1_0_, statecou1_.IsCountry as IsCountry0_, statecou1_.Name as Name0_, sta
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:06.603 binding '10' to parameter: 0
NHibernate.Type.NullableType DEBUG 2005-05-31 10:10:06.603 SELECT akbstate0_.akbSessionID as akbSessi3___, akbstate0_.akbStateCountryID as akbState4___, statecou1_.akbStateCountryID as akbState1_0_, statecou1_.IsCountry as IsCountry0_, statecou1_.Name as Name0_, statecou1_.Abbreviation as Abbrevia3_0_ FROM akbStat
NHibernate.Loader.Loader INFO 2005-05-31 10:10:06.613 Preparing SELECT akbstate0_.akbSessionID as akbSessi3___, akbstate0_.akbStateCountryID as akbState4___, statecou1_.akbStateCountryID as akbState1_0_, statecou1_.IsCountry as IsCountry0_, statecou1_.Name as Name0_, statecou1_.Abbreviation as Abbrevia3_0_ FR
NHibernate.Impl.BatcherImpl INFO 2005-05-31 10:10:06.613 result set contains (possibly empty) collection: [Business.UserSession.selectedStates#10]
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.623 uninitialized collection: initializing
NHibernate.Impl.SessionImpl INFO 2005-05-31 10:10:06.633 processing result set
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.643 done processing result set (0 rows)
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.643 done closing: 0 open IDbCommands, 0 open DataReaders
NHibernate.Impl.BatcherImpl DEBUG 2005-05-31 10:10:06.653 total objects hydrated: 0
NHibernate.Loader.Loader DEBUG 2005-05-31 10:10:06.663 1 collections were found in result set
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.663 collection fully initialized: [Business.UserSession.selectedStates#10]
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.673 1 collections initialized
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.673 collection initialized
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.683 Getting content items for user 335\IM481 using category 'Communications' with applyStateFilter = False and viewNonVisibleItems = True and ViewInActiveItems = True
Business.Category DEBUG 2005-05-31 10:10:06.693 begin
NHibernate.Transaction.AdoTransaction DEBUG 2005-05-31 10:10:06.703 Getting categories using statement: select new Business.Category(cat.Name, subCategories, items) from Business.CategorySpecification as cat join cat.SubCategorySpecifications as subCategories join subCategories.Associate
DataAccess.CategoryGateway DEBUG 2005-05-31 10:10:06.713 find: select new Business.Category(cat.Name, subCategories, items) from Business.CategorySpecification as cat join cat.SubCategorySpecifications as subCategories join subCategories.AssociatedContentItems as items , Ameri
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.723 No Types and Values
NHibernate.Engine.QueryParameters DEBUG 2005-05-31 10:10:06.723 compiling query
NHibernate.Hql.QueryTranslator DEBUG 2005-05-31 10:10:06.743 rollback
NHibernate.Transaction.AdoTransaction DEBUG 2005-05-31 10:10:06.803 transaction completion
NHibernate.Impl.SessionImpl DEBUG 2005-05-31 10:10:06.813 An error occured while trying to query the database.
DataAccess.CategoryGateway ERROR 2005-05-31 10:10:06.823 Exception: NHibernate.QueryException Message: class not found: Business.Category [select new Business.Category(cat.Name, subCategories, items) from Business.CategorySpecification as cat join cat.SubCateg
Top
 Profile  
 
ecrutchfield
 Post subject: Problem partially resolved
PostPosted: Wed Jun 01, 2005 11:12 am 
Newbie

Joined: Mon May 16, 2005 2:08 pm
Posts: 2
The query should be "select new Category(...)" instead of "select new Business.Category". This will then change the error message to "cannot find constructor for Category()". If I change the query and constructor to take just a string, it works fine. However, I'm still trying to figure out how to pass a collection of objects from "select new Category()". Does anyone know what the type should be in this case? ISet didn't work, nor did IList.

Thanks,
Eric
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 

Board index » Hibernate & Java Persistence » NHibernate Users

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.