tags:

views:

49

answers:

0
Q: 

Hibernate mapping for composite primary key and auto increatement

Pls Provide me mapping for the following table

CREATE TABLE adregistrationtbl ( NUM_ID int(20) NOT NULL auto_increment, openingDate date default NULL, purchaserName varchar(50) default NULL, purchaserAddress text, nomineeName varchar(50) default NULL, nomineeRelation varchar(25) default NULL, nomineeAge varchar(3) default NULL, enrolmentNo varchar(20) NOT NULL default '', planType varchar(20) default NULL, monthlyAmount double default NULL, lastDueDate date default NULL, branchCode varchar(4) NOT NULL default '', sunshineBranch varchar(10) default NULL, agentName varchar(50) default NULL, agentCode varchar(30) default NULL, unitcode varchar(30) default NULL, instalNo int(10) default NULL, PRIMARY KEY (branchCode,enrolmentNo), UNIQUE KEY NUM_ID (NUM_ID) )

related questions

NHibernate: how to enable lazy loading on one-to-one mapping
NHibernate mapping - one-to-one (or one-to-zero)
NHibernate child to polymorphic parent mapping
How to map to get value from primary table in Nhibernate?
How can i view the mapping configurations passed to the NHibernate by the castle activerecord?
Could we have custom name of the primary key column in Fluent NHibernate?
Using Additional Data on Intermediate Table with NHibernate
Storing a comma separated list in a field using nHibernate
Normalizing EnumStringType in NHibernate
NHibernate mapping with a class hierarchy whose base class is abstract and the discriminator is not a string
Can this mapping be done with (Fluent) NHibernate?
Nhibernate ValueType Collection as delimited string in DB
NHibernate Many-to-many
NHibernate: Best way to deal with intermediary table using Fluent NHibernate?
NHibernate Inheritance mapping when sub class in Separate Assemblly
Fluent NHibernate: How to create one-to-many bidirectional mapping?
NHibernate - Is there any good tools to assist you with the configuration file?
Mapping a class with multiple collection properties containing the same object type
Joining NHibernate Classes that share a common column but no foreign key
Fluent NHibernate - how to map a subclass one-to-one?
NHibernate many-to-one and unique constraint violation
NHibernate: One base class, several mappings
Is there any way to fake an ID column in NHibernate?
NHibernate: How can I combine fields from two classes?
Mapping a collection of enums with NHibernate