Thanks a lot for your response. Will surely try to work on the same.

On Mar 28, 1:19 am, cidico <[email protected]> wrote:
> I think this link can help you with the problem:
>
> http://stackoverflow.com/questions/2563755/ensuring-inserts-after-a-c...
>
> You can implement the IIdentifierGenerator to specify how the primary
> key is composed.
>
> On Mar 27, 6:05 am, Huzefa Kagdi <[email protected]> wrote:
>
>
>
> > Hi,
>
> > We have got a strange scenario to map in NHibernate. The database that
> > we are using is Oracle 10g. One of the Parent Table has a Primary Key
> > that is made up of two columns- 1) ID and 2) A Number Defining the
> > Year and Month (not Date). Also this Primary Key acts as a Foreign Key
> > (as well as Primary Key) to all other child tables (fifteen in
> > number). The design is such that there is a Parent Table having all
> > the Transactions (generic information) and then there are Child Tables
> > that actually refer to particular type of transactions (having
> > transaction specific information).
>
> > The problem we have is that we checked that the table has a Sequence
> > attached to it. But the Sequence is designed only for the ID column.
> > Sequence is used only for one column but the table takes two columns
> > as its Primary Key. So how do I write the mapping file for the id tag?
> > Any suggestions would be welcomed.
>
> > Just would like to add that redesigning the database is unfortunately
> > not a option that we have. We have to adhere to this design.

-- 
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.

Reply via email to