Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.05

I am now working on a legacy database(MS SQLSERVER 2000).

I have two tables, They are one-to-many relation.

CREATE TABLE [FSICOLUMNSETTING] (
[OBJECTID] [int] NOT NULL ,
[CLASSID] [int] NOT NULL ,
[NAME] [varchar] (255) NULL ,
[DESCRIPTION] [varchar] (255) NULL ,
[CREATED] [datetime] NULL ,
[LASTMODIFIED] [datetime] NULL ,
[OWNERID] [int] NULL ,
[LASTMODIFIEDBY] [int] NULL
)

CREATE TABLE [FSICOLUMNSETTINGENTRY] (
[OBJECTID] [int] NOT NULL ,
[CLASSID] [int] NOT NULL ,
[NAME] [varchar] (255) NULL ,
[DESCRIPTION] [varchar] (255) NULL ,
[CREATED] [datetime] NULL ,
[LASTMODIFIED] [datetime] NULL ,
[OWNERID] [int] NULL ,
[LASTMODIFIEDBY] [int] NULL ,
[COLUMNSETTINGNAME] [varchar] (255)NULL ,
[COLUMNINDEX] [int] NULL ,
[COLUMNNAME] [varchar] (50)NULL ,
[SCENARIONAME] [varchar] (50)NULL ,
[PREPAYMODELMATRIXNAME] [varchar] (50) NULL
)

We know Hibernate use the parent's id to relate the child's FK.

But in the legacy database, it use the parent table(FSICOLUMNSETTING) 's unique field "NAME" to relate the child table(FSICOLUMNSETTINGENTRY) 's field "COLUMNNAME".

The two tables can be maped to the one-to-many relation?

How to do?

Regards

Does anybody have met the same case.