imo the table Panel_Test_Table is a link table to connect rows in Test_table, is that correct ?
Test_table test_key / category
55 / PA 10 / TE 15 / TE 66 / PA
Panel_Test_Table panel_test_key / panel_key / test_key
1 / 55 / 10 2 / 55 / 15 3 / 66 / 10
a test can be connected to multiple panels ? is it a m:n relationship between Test_table rows ? what's the meaning of the panel_test_key ?
jakob
Gary wrote:
I have a, for me, complex OJB problem, and am looking for pointers.
I have two classes: a Test, and a PanelOfTests. I have two tables: Tests_Table, and Panel_Test_Table.
Here is the pseudocode:
public class Test { int testID; String category; // can be "TE" for test, "PA" for panel }
public class PanelOfTests extends Test { Collection tests; // a collection of Test objects }
table Tests_Table test_key, int category, varchar
table Panel_Test_Table panel_test_key, int panel_key, int test_key, int
A PanelOfTests then is in fact a Test, one that has a
category of "PA," and which contains 1-n other Tests. To find the tests that a given panel (say, 55)
contains I get all the rows in Panel_Test_Table where
panel_key = 55 and instantiate a Test object for each
of the test_keys.
Any good ideas on how to do this in OJB metadata/row readers/? I am unable to change the database layout.
Thanks, Gary
__________________________________ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
