POJOs for Composite Primary Key from Foreign Key

Posted by Gaurav on Stack Overflow See other posts from Stack Overflow or by Gaurav
Published on 2010-05-13T08:06:17Z Indexed on 2010/05/13 8:14 UTC
Read the original article Hit count: 610

Filed under:

composite-key

|

nhibernate

|

annotations

hi, I have table in database that has only two columns and these two colums are FK references. they have made these two colums as composite primarykey.

table structure

Table A
[
A_id PK
Description
]

Table B
[
B_Id PK
Description
]

Table A_B_Pemissiom
[
A_id (FK table A)
B_Id (FK table B)
PrimaryKey ( A_id,B_Id )
]

Can anyone help , I tried several ways and none of them works. Can anyone tell a working Hibernate mapping solution using annotations ?

Thanks,
Gaurav

© Stack Overflow or respective owner

Related posts about composite-key

NHibernate MySQL Composite-Key

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to create a composite key that mimicks the set of PrimaryKeys in the built in MySQL.DB table. The Db primary key is as follows: Field | Type | Null | ---------------------------------- Host | char(60) | No | Db | char(64) | No | User | char(16) | No | This… >>> More
Fluent nhibernate: Enum in composite key gets mapped to int when I need string

as seen on Stack Overflow - Search for 'Stack Overflow'
By default the behaviour of FNH is to map enums to its string in the db. But while mapping an enum as part of a composite key, the property gets mapped as int. e.g. in this case public class Address : Entity { public Address() { } public virtual AddressType Type { get; set; } … >>> More
Asp.Net MVC Create/Update/Delete with composite key

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm not sure how to use composite key. My Categories table has CategoryId (PK,FK), LanguageId (PK,FK), CategoryName CategoryId | LanguageId | CategoryName 1 | 1 | Car 1 | 2 | Auto 1 | 3 | Automobile etc. I'm following this design The default… >>> More
Why can't I reference child entities with part of the parent entities composite key

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to reference some child entities with part of the parents composite key not all of it, why cant I? This happens when I use the following mapping instead of that which is commented. I get the following error Foreign key in table VolatileEventContent must have same number of columns… >>> More
Composite key syntax in Boost MultiIndex

as seen on Stack Overflow - Search for 'Stack Overflow'
Even after studying the examples, I'm having trouble figuring out how to extract ranges using a composite key on a MultiIndex container. typedef multi_index_container< boost::shared_ptr< Host >, indexed_by< hashed_unique< const_mem_fun<Host,int,&Host::getID> >… >>> More

Related posts about nhibernate

How can I eager-load a child collection mapped to a non-primary key in NHibernate 2.1.2?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have two objects with a many-to-many relationship between them, as follows: public class LeftHandSide { public LeftHandSide() { Name = String.Empty; Rights = new HashSet<RightHandSide>(); } public int Id { get; set; } public string Name { get; set;… >>> More
Nhibernate 2.1 and mysql 5 - InvalidCastException on Setup

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello there, I am trying to use NHibernate with Spring.Net und mySQL 5. However, when setting up the connection and creating the SessionFactoryObject, I get this InvalidCastException: NHibernate seems to cast MySql.Data.MySqlClient.MySqlConnection to System.Data.Common.DbConnection which causes… >>> More
Nhibernate transactions:Avoiding Nhibernate dependency in the service layer

as seen on Stack Overflow - Search for 'Stack Overflow'
One of practices advocated by Nhibernate experts is to do all actions in inside a transaction. In a typical 3 tier web architecture, Nhibernate depedency is limited the data layer. In such a case is it fine to use using (var tr = NHibernateSession.Current.BeginTransaction()) { at the controller… >>> More
Series of abstract classes and NHibernate

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, and first off thanks for your time to look at this. For a research project I'm working on, I have a somewhat complex design (which I've been given) to persist to a database via NHibernate. Here's an example of the class hierarchy: TransitStrategy, TransportationCompany and TransportationLocation… >>> More
Using Time columns with NHibernate, Fluent NHibernate and SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a table with a time column in my SQL Server 2008 database. The property of the object I'm trying to map to is a TimeSpan. How can i tell FluentNHibernate to use the TimeAsTimeSpan NHibernate type, so that I don't have cast problems? >>> More