Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Mapping relationship with partial composite key column

Michael A Hoffman
Ranch Hand
Posts: 37
Java jQuery Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.


  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic