[b]Hibernate version: 3.2 [/b]

[b]Mapping documents: hibernate-mapping [/b]

[b]Name and version of the database you are using: Sybase (ASE 12.5.3)[/b]

[b]The SQL schema(show_sql=true):
CREATE TABLE dbo.Customer
(
cus_id int NOT NULL,
fname char(30) NOT NULL,
lname char(30) NULL
)

CREATE TABLE dbo.Address
(
addr_id int NOT NULL,
cus_id int NULL,
street varchar(50) NULL,
city varchar(50) NULL,
zipcode varchar(50) NULL,
)

CREATE TABLE dbo.TableIds
(
table_name char(40) NOT NULL,
next_id int NOT NULL
)

[/b]


We need to migrate our 7 yr-old java code to use hibernate.

Currently, to insert a row into Customer table (renamed for simplicity) is to execute select statement in the TableIds to get the unique key before executing INSERT statement on Customer table. The app is using trigger to update entries in TableIds table.

Without changing the db schema, which id generator should I use? How can I express the one-to-many relationship between Customer and Address table in hibernate-mapping xml? (PLEASE provide sample code/config)

Thank you

one to many relationship:

One Bid is from 1 Item, One Item can have more than 1 Bids
Bid n ------> 1 Item



O the page 167 of the book Java Persistence with Hibernate you can find a table with the GenerationType's. Check it out and see what is the better for your case. If you have doubts use the auto. here is an example



That book is very good. Read the capter 1,2, 4, 6, 10.

**dont forget to rate if it was helpfull this tip

I'm still getting mapping error. <generator class="native"/> does not work. I'm using Sybase and tables have no IDENTITY column thus "native" is not working.

I'm working on "assigned" and looking at chapter 8 of the same book. Thanks for input though.

Anybody has similar project? Please tell me how did you approach when designing your domain model.

Regards,
Marvin