Hey all,
I'm using OJBrc6 with MySQL and been faily happy with my results to this
point. I'm running into a problem, however, in generating a proper OQL
query that will get the data I need. Here's the relvant information
(package names shortened for brevity)
Class dm1.Task maps to table tasks
Class dm1.Summary maps to table summaries
tasks has a column fk_summary_id which is a foreign key into the summaries
table.
OJB knows about this and handles the reference to the dm1.Summary object in
a field called _summary.
dm1.Task {
long _summaryId; // Actual foreign key variable from db.
Summary _summary; // Reference to OJB object.
blah blah
}
dm1.Summary {
java.util.Date _date;
blah blah;
}
I want to select all the tasks that have a summary date less than or equal
to a given date..
Here's what my best guess to date is:
SELECT tasks FROM dm1.Task WHERE _summary._date <= $1
I get an error table _summary not found back from the MySQL jdbc driver. So
I'm guessing that something isn't mapping correctly.
Basic queries have worked.. it's this "join" thats apparently causing the
trouble.
Thanks for any ideas.
Wil
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
