tags:

views:

293

answers:

1
Q: 

JPA Secondary Table Issue

I have a three tables: User, Course, and Test.

Course has a User foreign key and Test has a Course foreign key. I am having trouble mapping the Test collection for each User since I need an intermediary step from User -> Course -> Test. I am trying to use a SecondaryTable since the User key for the Test is its associated Course row.

Am I on the right track using SecondaryTable or is there a way to use a JoinTable without the inverseJoinColumn?

A: 

Am I on the right track using SecondaryTable or is there a way to use a JoinTable without the inverseJoinColumn?

I don't think so, specifying secondary tables indicates that the entity's persistent data is stored across multiple tables, which is not exactly the case here.

But it's hard to say more without seeing your entities, the relationships. And by the way, do you have the control of the database (i.e. can you change things)?

Pascal Thivent  2010-02-01 12:05:09
How would I structure a JoinTable in this case? I do have influence over the schema. I would show you the entities, but I am pretty sure they are part of the problem. The main issue here is the fact that I want to get a collection of students from each course in a collection of courses.
Smithers  2010-02-02 02:40:10
@Smithers If you can modify the schema, just model it like you want to use it at the object level. What you are trying to do is just too cumbersome IMHO.
Pascal Thivent  2010-02-04 13:53:04

related questions

Java Time Zone is messed up
Eclipse on win64
Automate builds for Java RCP for deployment with JNLP
Why are professors or schools picking Java over C++ to teach to students?
Is there a real benefit of using J#?
Public/Popular Websites using JavaServer Faces
Why can't I use a try block around my super() call?
Accessing post variables using Java Servlets
Personal Linux web server
Is this really widening vs autoboxing?
How can I Java webstart multiple, dependent, native libraries?
Why can't I call toString() on a Java primitive?
How do I use Java to read from a file that is actively being written?
What code analysis tools do you use for your Java projects?
IllegalArgumentException or NullPointerException for a null parameter?
How do I configure and communicate with a serial port?
What is the best way to parse strings in Java
Getting started with a custom JXTA PeerGroup
Creating a custom button in Java
How to get started "writing" a code coverage tool?
Which Build-/Configuration Management Tool?
What is the difference between an int and an Integer in Java/C#?
What is the meaning of the type safety warning in certain Java generics casts?
How would you access Object properties from within an object method?
Converting CSV File to XML in Java