Hi Armin, I did the test using 1.0.4.
Best regards, Ali On 5/11/07, Armin Waibel <[EMAIL PROTECTED]> wrote:
Hi Ali, Ali HACHAMI wrote: > Hi Armin, > > > I tried to fix the problem by renaming the class's attributes, but the > problem is still there. In conclusion the problem happen when the columns > have the same name in the tables (not in the classes). > In my test the java field name ("name") + column name ("NAME_") are the same in both classes/tables. Did you tried to fix the issue using 1.0.4 or did you tried the latest version from SVN (OJB_1_0_RELEASE branch!)? regards, Armin > > > Best regards, > > Ali > > > On 5/5/07, Armin Waibel <[EMAIL PROTECTED]> wrote: >> >> Hi Ali, >> >> sorry for the late reply. Last week I had a DSL malfunction caused by my >> Internet provider. It seems to be fixed (works again for 20 hours), but >> it could happen that I'm out of business again. >> >> >> Ali HACHAMI wrote: >> > Hi, >> > I'm using getReportQueryIteratorByQuery and I want to select columns >> that >> > have the same name but are not present in my criteria : >> > >> > >> > Criteria crit1 = new Criteria(); >> > crit1.addEqualTo("id", new Integer(1)); >> > >> > q = QueryFactory.newReportQuery(Container.class, crit1); >> > >> > String[] cols = { id, "name", "refOtherClass.name "}; >> > q.setAttributes(cls); >> > >> > The pb is that I'm getting the same value for the columns "name" and " >> > refOtherClass.name". >> > >> > Any help? >> >> I try to reproduce your problem and setup a similar test with class >> Author and Publisher (1:1 relation Author-Publisher): >> >> Query q = QueryFactory.newReportQuery( >> Author.class, new String[]{"id", "name", "publisher.name"}, null, true); >> Iterator result = broker.getReportQueryIteratorByQuery(q); >> while(result.hasNext()) >> { >> System.out.println(ArrayUtils.toString(result.next())); >> } >> >> Result: >> {200001,author_1_testA_1178367631953_,publisher_testA_1178367631953_} >> {200002,author_2_testA_1178367631953_,publisher_testA_1178367631953_} >> {200003,author_3_testA_1178367631953_,publisher_testA_1178367631953_} >> {200004,author_4_testA_1178367631953_,publisher_testA_1178367631953_} >> >> As you can see this works with latest version from SVN (OJB_1_0_RELEASE >> branch!). I don't try this test with OJB 1.0.4. So if it's a bug in >> 1.0.4, it seems to be fixed in the next upcoming version of OJB. >> >> If your problem still happens with latest from SVN, please post the >> mapping for class Container and the referenced class. >> >> regards, >> Armin >> >> >> > Thanks in advance, >> > >> > Ali >> > >> >> --------------------------------------------------------------------- >> 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]