This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
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 Building Microservices this week in the Design 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.


Have you checked out Aspose?
subject: Mapping relationship with partial composite key column
It's not a secret anymore!