maybe you bound the date parameter to a String object (even if this string is formatted with a looks-like date format). If this is the case, try to bind it with a Date instance. I think I met this problem before.
HTH
Wil Hunt wrote:
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]
