File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Mapping relationship with partial composite key column Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Mapping relationship with partial composite key column" Watch "Mapping relationship with partial composite key column" New topic

Mapping relationship with partial composite key column

Michael A Hoffman
Ranch Hand

Joined: Mar 04, 2009
Posts: 37

Working on Hibernate 3.2.4ga, calling Oracle 10. It is likely I am not setting this up properly; however, here is my case.

I have 2 legacy database tables. The first table is called "TITLES". It contains a fk with the column name "TITL_BOOK_CAT". The second table is called "BOOKCAT_ACCESS" and contains a non-generated/non-sequential composite pk of columns named "BCCA_BOOK_CATEGORY" and "BCCA_ACCESS_LVL".

My goal is to setup a relationship between the Titles and BookCatAccess entities such that each Title could have one to many BookCatAccess entities. I have tried various ways to map this relationship; however, I have not been able to get the results I expected.

Below is the source code:

public class Titles {
private String titleBookCat;

...<getters and setters for titleBookCat>...

@JoinColumn(name="BCCA_BOOK_CATEGORY", referencedColumnName="TITL_BOOK_CAT")
private List<BookCatAccess> bookCategoryAccessList;

...<getters and setters for bookCategoryAccessList>...


public class BookCatAccess {

private BookCatAccessId id;

...<getters and setters for id>...

public class BookCatAccessId implements Serializable {
private String bookCategory;

private Long accessLevel;

I do not get SQL back as this call results in a ClassCastException.

Any direction or advice would be helpful.


I agree. Here's the link:
subject: Mapping relationship with partial composite key column
It's not a secret anymore!