Just one thing I thought of, I saw somewhere that "one class multiple tables" mappings was a feature to be expected in future versions of OJB, which would solve my problem. Also, the "table" attribute of the class-descriptor element in the DTD points to this as well.
Is this a planned feature? Arnar > -----Original Message----- > From: Arnar Birgisson [mailto:[EMAIL PROTECTED] > Sent: 14. ma� 2004 18:48 > To: [EMAIL PROTECTED] > Subject: Outer join in Report Query > > > Hello there, > > I have a problem similar to Wallace's > (http://www.mail-archive.com/[EMAIL PROTECTED]/msg09417.h > tml) from a few weeks ago. > > I have a table containing a log of errors/mistakes that > happen in the production of a book or some artifact (this is > for a commercial printer). One field in this log is called > "JobID" and can be any string. In most cases, but not nearly > all, this string is a reference number to another table > "Jobs" which contains a description of the job as well as the > customer id and name. > > Now, as I said, JobID in the Problems table can be any string > and doesn't need to reference an existent row in the Jobs > table. My application only handles problem reports from the > Problems table as entities, and doesn't make any changes to > the other table (which is populated by a legacy job > scheduling system). I have an OJB mapping for the Problems > table that is working great. > > However, I would like to display the job description and > customer name along with the problem, given that the JobID of > the problem exists in the Jobs table. In a nutshell, I want > the results of this SQL query in a > ReportQuery: > > select P.ProblemId, P.ProblemDescription, P.JobId, > J.JobDescription, J.Customer from Problems P > left outer join Jobs J on P.JobId = J.JobId > > How would I do this? I wan't the JobId field to be a plain > String attribute of the Problem class, not a reference to a > seperate Job class (in fact, I don't have any need for such a > class at all). > > Can I use the QueryBySql class to generate such custom report > queries? I didn't find any documentation for that class, so > I'm taking a wild shot > :o) > > Of course, I can do this directly through JDBC, but I just > wanted to check with you if there is a way to do this through OJB. > > Arnar > > > --------------------------------------------------------------------- > 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]
