Hello,
I am a newbee to nhibernate and I would like to get some help understanding
many-to-many relationship mapping.
I previously came from a Java/WebObjects background and am used to an ORM based
technology and I am trying to move to .NET as rapidly as possible.
After a bunch of hairpulling I figured out the basic mapping between my tables
in a "readonly" way, however, when I try to save to the tables I am getting
errors.
Kindly take a look and please give any advise.
Thanks,
Jerry
My setup:
VS2005 .Net 2.0
Oracle 10g
Simple table structure is
USERINFO<----->>USER_USERGROUP<<----->USERGROUP
(SysUser class) (No class generated) (SysGroup class)
PK oid PK oid_user PK oid
PK oid_user_group
I created the class files and mapping files and am able to fetch against the
database.
But when I try to save just a SysUser I get the following abbreviated error:
Invalid index 4 for this OracleParameterCollection with Count=4
Mapping files:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="ObjectModel.SysUser, ObjectModel" table="userinfo">
<id name="oid" column="oid" type="Decimal" length="22">
<generator class="sequence" />
</id>
<property name="disabled" column="disabled" type="String"
length="5"/>
<property name="eMailAddress" column="email_address"
type="String" length="65"/>
<property name="firstName" column="first_name" type="String"
length="100"/>
<property name="lastLoginDate" column="last_login_date"
type="DateTime" length="7"/>
<property name="lastName" column="last_name" type="String"
length="100"/>
<property name="loginFailureCount"
column="login_failure_count" type="Decimal" length="10"/>
<property name="middleName" column="middle_name" type="String"
length="100"/>
<property name="password" column="password" type="String"
length="65"/>
<property name="phone" column="phone" type="String"
length="65"/>
<property name="sessionTimeout" column="session_timeout"
type="Decimal" length="10"/>
<property name="username" column="username" type="String"
length="65"/>
<bag name="userGroups" table="user_usergroup" cascade="save-
update" lazy="false" inverse="true">
<key column ="oid_user" />
<many-to-many class="ObjectModel.SysUserGroup,
ObjectModel" column="oid_user_group" />
</bag>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="ObjectModel.SysUserGroup, ObjectModel"
table="usergroup">
<id name="oid" column="oid" type="Decimal" length="22">
<generator class="sequence" />
</id>
<property name="name" column="group_name" type="String"
length="65"/>
<bag name="userRoles" table="usergroup_userrole"
cascade="none" lazy="false" inverse="true">
<key column ="oid_user_group" />
<many-to-many class="ObjectModel.SysUserRole, ObjectModel"
column="oid_user_role" />
</bag>
<bag name="users" table="user_usergroup" cascade="save-update"
lazy="false" inverse="true">
<key column ="oid_user_group" />
<many-to-many class="ObjectModel.SysUser, ObjectModel"
column="oid_user" />
</bag>
</class>
</hibernate-mapping>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
