Hi all!

I am a new hibernate user, and i am trying to get inside of the hibernate complex world.
Currently i need to do the following. I have 3 tables defined: player, team and player_team_assoc.
The third table (player_team_assoc) was defined to satisfy the needing of have a many-to-many relationship between team and player tables.

Basically the tables structure is like this:

Player
--------
(PK)player_id
player_name

Team
------
(PK)team_id
team_name

player_team_assoc
-----------------------
(PK)team_id
(PK)player_id
is_team_manager


My problem arrives when i try to set the 'is_team_manager' field of the 'player_team_assoc' table to a Player java object in the player hiberante definition.
I have tried everything, i tried to put a composite-element, element, keys, etc, but i cannot find the way to say that i want to load the 'is_team_manager' field to a player object.

In the next lines i attach the bag xml definition of Player and Team elements:

Player definition
-------------------

<bag name="collectionTeams" table="player_team_assoc" inverse="true" cascade="all" lazy="true">
<key column="player_id" />
<many-to-many column="team_id" class="slm.persistence.dao.team.Team" />
</bag>


I guess that in the previous definition i should put something inside the bag tags indicating that i want to set the 'is_team_manager' field to a property of the Player object.


Team definition
------------------

<bag name="collectionPlayers" table="player_team_assoc" cascade="all" lazy="true">
<key column="team_id" />
<many-to-many column="player_id" class="slm.persistence.dao.player.Player" />
</bag>


The hibernate version iam using is 3.1 and the database is MySql-4.0.16



Since now, THX for any help!! :)

What you can do is use a bag of composite elements in your team object :



Where TeamMember is a class that has a Player and a isTeamManager attributes.

An other (better ?) way to to this would be to add a teamManager attribute to your Team object (If a team has exactly one manager)

It is called ternary relationships, couple of llinks:
http://www.hibernate.org/hib_docs/v3/re ... ns-ternary
http://ndpsoftware.com/HibernateMappingCheatSheet.html

I tried the solution of put that code on the Player xml definition, and add an attribute called 'isTeamManager' to it, but when i try to execute a simple query to load a player it throws me this exception:




And the Player definition looks like this now:



I guess that bag doesnt allow that order or something like that... i change that declaration through all the bag tag :) but it didnt work.

MORE HELPPPPPPPPP d:

Bytes!

Pablo

should be
<bag name="collectionPlayers" table="player_team_assoc" cascade="all" lazy="true">
<key column="team_id" />
<composite-element class="TeamMember">
<many-to-one column="player_id" />
<property name="teamManager"/>
</composite-element>
</bag>

Provided that class TeamMember has property teamManager with setter 'setTeamManager(boolean v )' and getter 'boolean isTeamManager()';

Player itself should not have 'teamManager' property.

Sorting is supported via order-by attribute
http://www.hibernate.org/hib_docs/v3/re ... tions.html

Thanks for the help... finally the error was found. It was a severe error, because it was a conceptual error. It was impossible to have that property on the player object itself, because if that happen it means that the player is the team manager of all the elements of the collection of teams.
Thanks for everything!!!

Hope to help you sometime :D

bytes

Pablo