thank you jacob, I have scarab account and am associated with OJB module,
sergey -----Original Message----- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 3:29 PM To: OJB Users List Subject: Re: OJB report query hi sergey, do you have a scarab-account ? btw. this is what OJB242 is all about: OJB can not resolve criteria or columns containing multiple attributes. ie: upper(col1 || col2) this leads to problems with distinct count-queries, where we need concatenation to construct one distinct value based on the pks: SELECT count(distinct (key1 || key2 || key3)) jakob Manukyan, Sergey wrote: > thank you jakob, > > scarab tells me: > > "You do not have permission to view an issue with that ID. If you believe it > > is a valid ID, check with the project owner or system administrator" > > any help? > > Sergey > > (I am associated with OJB module) > > > > -----Original Message----- > From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] > Sent: Monday, March 22, 2004 2:16 PM > To: OJB Users List > Subject: Re: OJB report query > > hi sergey, > > ojb currently cannot handle multiple columns in one criteria. see > > http://nagoya.apache.org/scarab/issues/id/OJB242 > > jakob > > Manukyan, Sergey wrote: > >>Folks, >> >>I am repeating my question here as obviously it stands as a problem for me >>now and either: >>1. it cannot be solved by current OJB implementation >>2. there is a solution I don't know about >> >>How can I specify expressions in OJB report query? >> >>F.e. I am making a report that as a column should produce addition of two >>table columns : >> >>qry.setColumns( >> new String[] { >> "materialVariance + laborVariance" >> } >> >>materialVariance and laborVariance are defined as field names in OJB >>repository, unfortunately this code doesn't work as OJB failes to make a >>mapping to actual table column names in SQL generation and makes SQL like: >> >>SELECT materialVariance + laborVariance FROM .... >> >>And of course there are no such columns in database table, >>Now I am forced to make substitution and instead of field names include >>column names in OJB query: >> >>qry.setColumns( >> new String[] { >> "MATVAR + LABVAR" >> } >> >>Which is evidently a bad way of using OJB that is increasing future >>maintenance. I am using RC4. >> >>Please tell me if there is or there is no solution for this problem in OJB >>as it looks like limitation for me, >> >>Thank you, >>-Sergey >> >> >> >> >>********************** >>** LEGAL DISCLAIMER ** >>********************** >> >>This E-mail message and any attachments may contain >>legally privileged, confidential or proprietary >>information. If you are not the intended recipient(s), >>or the employee or agent responsible for delivery of >>this message to the intended recipient(s), you are >>hereby notified that any dissemination, distribution >>or copying of this E-mail message is strictly >>prohibited. If you have received this message in >>error, please immediately notify the sender and >>delete this E-mail message from your computer. >> >>--------------------------------------------------------------------- >>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] > > --------------------------------------------------------------------- > 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] ********************** ** LEGAL DISCLAIMER ** ********************** This E-mail message and any attachments may contain legally privileged, confidential or proprietary information. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this E-mail message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this E-mail message from your computer. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
