Its a small project with 7 tables (three of which were like a bad
idea, as noted below, and which will likely go away)
Here are all of the tables:
create table Projects (
ProjectId integer,
Code TEXT not null unique,
Description TEXT not null,
primary key (ProjectId),
unique (Code)
)
// The next three tables likely go away
create table ActivityBases (
ActivityBaseId integer,
Description TEXT not null,
BusinessId TEXT not null,
primary key (ActivityBaseId),
unique (BusinessId)
)
create table ProjectActivity (
ActivityBaseId INTEGER not null,
ProjectId INTEGER, << related to project, so maybe
a
problem??
primary key (ActivityBaseId)
)
create table AccountingActivity (
ActivityBaseId INTEGER not null,
AccountId INTEGER,
primary key (ActivityBaseId)
)
// this table is why I thought I needed the activity base tables
// but am thinking now that activity base is a model concept that
// should not be represented as db tables (just use Projects &
Accounts)
create table Allocations (
AllocationId integer,
StartTime DATETIME not null,
EndTime DATETIME not null,
PostingTime DATETIME,
ResourceId INTEGER,
ActivityBaseId INTEGER, <<<-----**
primary key (AllocationId),
unique (StartTime, EndTime, ResourceId, ActivityBaseId)
)
create table Resources (
ResourceId integer,
ResourceName TEXT not null,
BusinessId TEXT not null,
OrganizationName TEXT not null,
primary key (ResourceId)
)
create table Accounts (
AccountId integer,
AccountNumber TEXT not null,
Description TEXT not null,
primary key (AccountId),
unique (AccountNumber)
)
On Mar 20, 12:17 pm, Fabio Maulo <[email protected]> wrote:
> are you registering some other mapping ? (containing SQL or HQL for example)
>
> 2010/3/20 Berryl Hesh <[email protected]>
>
>
>
> > Yes, the hbms are generated via FNH.
>
> > I am not sure I understand your question though. If you mean some sort
> > of interceptor, then no.
>
> > Here is what the ddl for the projects table look like, if that adds
> > anything to the plot:
>
> > create table Projects (
> > ProjectId integer,
> > Code TEXT not null unique,
> > Description TEXT not null,
> > primary key (ProjectId),
> > unique (Code)
> > )
>
> > On Mar 20, 11:50 am, Fabio Maulo <[email protected]> wrote:
> > > mmm... your mapping is generated...
> > > are you registering something in the NH's before the mapping-source you
> > are
> > > using have register all classes-mapping ?
>
> > > 2010/3/20 Berryl Hesh <[email protected]>
>
> > > > Ok, the new repository is off of the suspect list, since the old one
> > > > now has the same error.
>
> > > > So, here is the mapping:
>
> > > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-
> > > > access="property" auto-import="true" default-cascade="none" default-
> > > > lazy="true">
> > > > <class xmlns="urn:nhibernate-mapping-2.2"
> > > > name="Domain.Model.Projects.Project, Domain, Version=1.0.0.0,
> > > > Culture=neutral, PublicKeyToken=null" table="Projects">
> > > > <id name="Id" type="System.Int32, mscorlib, Version=2.0.0.0,
> > > > Culture=neutral, PublicKeyToken=b77a5c561934e089" unsaved-value="0">
> > > > <column name="ProjectId" />
> > > > <generator class="identity" />
> > > > </id>
> > > > <property name="Code" type="Data.UserTypes.ProjectCodeUserType,
> > > > Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null">
> > > > <column name="Code" length="10" not-null="true" unique="true"
> > > > unique-key="DomainSignature" />
> > > > </property>
> > > > <property name="Description" type="System.String, mscorlib,
> > > > Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
> > > > <column name="Description" length="75" not-null="true" />
> > > > </property>
> > > > </class>
> > > > </hibernate-mapping>
>
> > > > On Mar 20, 10:25 am, Berryl Hesh <[email protected]> wrote:
> > > > > Only because it's the only thing that changed.
>
> > > > > I think I once had a situation where I got a mapping exception was
> > > > > thrown and the real problem was not the actual mapping but some other
> > > > > type mismatch somewhere. SO that's what I think is the real suspect,
> > > > > and I'm looking for the experience in this group to help find what
> > the
> > > > > problem might be.
>
> > > > > Can you think of any situations where this exception is thrown but it
> > > > > isn't the mapping that is causing it?
>
> > > > > On Mar 20, 6:52 am, Fabio Maulo <[email protected]> wrote:
>
> > > > > > Why you have such suspect ?
>
> > > > > > 2010/3/20 <[email protected]>
>
> > > > > > > I think this is one for fabio...
> > > > > > > Sent from my Verizon Wireless BlackBerry
>
> > > > > > > -----Original Message-----
> > > > > > > From: Berryl Hesh <[email protected]>
> > > > > > > Date: Sat, 20 Mar 2010 00:51:24
> > > > > > > To: nhusers<[email protected]>
> > > > > > > Subject: [nhusers] mapping exception (no persister for..)
> > weirdness
>
> > > > > > > I started getting this after I started using a new design for a
> > > > > > > repository, but only in one scenario, which is the weird part.
> > Tests
> > > > > > > that validate the mapping and the repository itself run fine.
>
> > > > > > > The repository root is Projects, and the scenario that leads to
> > the
> > > > > > > exception is when legacy projects from a different db are
> > converted
> > > > to
> > > > > > > the green field system. The previous repository handled this fine
> > > > too,
> > > > > > > and there is no code change in the conversion routine except for
> > the
> > > > > > > implemented IProjectRepository.
>
> > > > > > > Rather than posting my entire code base or more english to this
> > post,
> > > > > > > I'm hoping someone here can spot a symptom from the exception and
> > > > > > > brief description, or at least ask a good question or two to
> > narrow
> > > > it
> > > > > > > down. I guess the repository itself is the major suspect, but
> > that's
> > > > > > > as far as I can get it right now.
>
> > > > > > > Thanks,
> > > > > > > Berryl
>
> > > > > > > === the Exception trace =====
>
> > > > > > > failed: NHibernate.MappingException : No persister for:
> > > > > > > Domain.Model.Projects.Project
> > > > > > > at NHibernate.Impl.SessionFactoryImpl.GetEntityPersister(String
> > > > > > > entityName)
> > > > > > > at NHibernate.Impl.SessionImpl.GetEntityPersister(String
> > entityName,
> > > > > > > Object obj)
> > > > > > > at
>
> > NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object
> > > > > > > entity, String entityName, Object anything, IEventSource source,
> > > > > > > Boolean requiresImmediateIdAccess)
> > > > > > > at
>
> > NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent
> > > > > > > event)
> > > > > > > at
>
> > NHibernate.Event.Default.DefaultSaveEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent
> > > > > > > event)
> > > > > > > at
>
> > NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent
> > > > > > > event)
> > > > > > > at
>
> > NHibernate.Event.Default.DefaultSaveEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent
> > > > > > > event)
> > > > > > > at
>
> > NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent
> > > > > > > event)
> > > > > > > at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event)
> > > > > > > at NHibernate.Impl.SessionImpl.Save(Object obj)
> > > > > > > NHibernate\Repository\NHibRepository.cs(40,0): at
> > > > > > > Core.Data.NHibernate.Repository.NHibRepository`1.Add(T item)
> > > > > > > Repositories\ProjectRepository.cs(30,0): at
> > > > > > > Data.Repositories.ProjectRepository.SaveAll(IEnumerable`1
> > projects)
> > > > > > > LegacyConversion\LegacyBatchUpdater.cs(20,0): at
>
> > Data.LegacyConversion.LegacyBatchUpdater.ConvertOpenLegacyProjects(ILegacyProjectDao
> > > > > > > legacyProjectDao, IProjectRepository greenProjectRepository)
> > > > > > > Data\Brownfield\ProjectBatchUpdate_SQLiteTests.cs(31,0):
> > > > > > > at .Tests.Data.Brownfield
>
> > > > > > > --
> > > > > > > You received this message because you are subscribed to the
> > Google
> > > > Groups
> > > > > > > "nhusers" group.
> > > > > > > To post to this group, send email to [email protected].
> > > > > > > To unsubscribe from this group, send email to
> > > > > > > [email protected]<nhusers%[email protected]>
> > <nhusers%[email protected]<nhusers%[email protected]>
>
> > > > <nhusers%[email protected]<nhusers%[email protected]>
> > <nhusers%[email protected]<nhusers%[email protected]>
>
> > > > > > > .
> > > > > > > For more options, visit this group at
> > > > > > >http://groups.google.com/group/nhusers?hl=en.
>
> > > > > > > --
> > > > > > > You received this message because you are subscribed to the
> > Google
> > > > Groups
> > > > > > > "nhusers" group.
> > > > > > > To post to this group, send email to [email protected].
> > > > > > > To unsubscribe from this group, send email to
> > > > > > > [email protected]<nhusers%[email protected]>
> > <nhusers%[email protected]<nhusers%[email protected]>
>
> > > > <nhusers%[email protected]<nhusers%[email protected]>
> > <nhusers%[email protected]<nhusers%[email protected]>
>
> > > > > > > .
> > > > > > > For more options, visit this group at
> > > > > > >http://groups.google.com/group/nhusers?hl=en.
>
> > > > > > --
> > > > > > Fabio Maulo
>
> > > > --
> > > > You received this message because you are subscribed to the Google
> > Groups
> > > > "nhusers" group.
> > > > To post to this group, send email to [email protected].
> > > > To unsubscribe from this group, send email to
> > > > [email protected]<nhusers%[email protected]>
> > <nhusers%[email protected]<nhusers%[email protected]>
>
> > > > .
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/nhusers?hl=en.
>
> > > --
> > > Fabio Maulo
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "nhusers" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to
> > [email protected]<nhusers%[email protected]>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/nhusers?hl=en.
>
> --
> Fabio Maulo
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
