I have problem with mapping some tables. I have mapped a 100+ table legacy database using Nhibernate. I have encountered some problems around three table; job_operators, job_operator_groups, job_operator_group_lk.
A lookup table is used to provide the name of the job_operator_groups and is also used by various other tables (omitted for simplicity).
I have included the exception from my unit test, the schema for the troublesome three tables and their associated mappings.
<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="Digitalk.Gateway.Core.DomainObjects.JobOperatorGroups,Digitalk.Gateway.Core" table="job_operator_groups" lazy="true">
<id name="ID" column="operator_id" type="int">
<generator class="native" />
</id>
<bag name="JobOperators" inverse="false" table="job_operators" lazy="false" cascade="delete">
<key column="id" />
<many-to-many class="Digitalk.Gateway.Core.DomainObjects.JobOperators,Digitalk.Gateway.Core">
<column name="operator_id" />
</many-to-many>
</bag>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="Digitalk.Gateway.Core.DomainObjects.JobOperatorGroupLk,Digitalk.Gateway.Core" table="job_operator_group_lk" lazy="false">
<id name="ID" column="id" type="int">
<generator class="native" />
</id>
<property name="Name" column="name" type="string" />
<bag name="JobDefAlertNotifier" inverse="true" lazy="false" cascade="delete">
<key column="operator_group_lk_id" />
<one-to-many class="Digitalk.Gateway.Core.DomainObjects.JobDefAlertNotifier,Digitalk.Gateway.Core" />
</bag>
<bag name="JobDefAsrNotifier" inverse="true" lazy="false" cascade="delete">
<key column="operator_group_lk_id" />
<one-to-many class="Digitalk.Gateway.Core.DomainObjects.JobDefAsrNotifier,Digitalk.Gateway.Core" />
</bag>
<bag name="JobOperators" inverse="false" table="job_operator_groups" lazy="false" cascade="delete">
<key column="group_lk" />
<many-to-many class="Digitalk.Gateway.Core.DomainObjects.JobOperators,Digitalk.Gateway.Core">
<column name="id" />
</many-to-many>
</bag>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="Digitalk.Gateway.Core.DomainObjects.JobOperators,Digitalk.Gateway.Core" table="job_operators" lazy="false">
<id name="ID" column="id" type="int">
<generator class="native" />
</id>
<property name="Destination" column="destination" type="string" />
<property name="Name" column="name" type="string" />
<property name="Type" column="type" type="int" />
<bag name="JobOperatorGroups" outer-join="true" table="job_operator_groups">
<key column="id"/>
<many-to-many column="operator_id" class="Digitalk.Gateway.Core.DomainObjects.JobOperatorGroups,Digitalk.Gateway.Core"/>
</bag>
</class>
</hibernate-mapping>
--Create job_operator_groups table
CREATE TABLE [job_operator_groups] (
[group_lk] [int] NOT NULL ,
[operator_id] [int] NOT NULL ,
CONSTRAINT [pk_job_operator_groups] PRIMARY KEY NONCLUSTERED
(
[operator_id],
[group_lk]
) WITH FILLFACTOR = 90 ON [PRIMARY] ,
CONSTRAINT [fk_job_operator_groups_job_operator_group_lk] FOREIGN KEY
(
[group_lk]
) REFERENCES [job_operator_group_lk] (
[id]
),
CONSTRAINT [fk_job_operator_groups_job_operators] FOREIGN KEY
(
[operator_id]
) REFERENCES [job_operators] (
[id]
)
) ON [PRIMARY]
GO
--Create job_operator_group_lk table
CREATE TABLE [job_operator_group_lk] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [varchar] (30) COLLATE Latin1_General_CI_AS NULL ,
CONSTRAINT [pk_job_operator_group_lk] PRIMARY KEY CLUSTERED
(
[id]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
--Create job_operators table
CREATE TABLE [job_operators] (
[destination] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [varchar] (30) COLLATE Latin1_General_CI_AS NULL ,
[type] [int] NULL ,
CONSTRAINT [pk_job_operators] PRIMARY KEY CLUSTERED
(
[id]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
Login
FAQ
Search