I forgot to mention that I am running the ReportQuery on a View(Oracle
db), not a normal table. I don't know what difference that would make
when selecting. When I have time I will trace the source code and find
out exactly what is happening.
Thanks anyway.
Blake
-Original Message-
From: Armin Waibel [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 7:32 AM
To: OJB Users List
Subject: Re: Need constant Object[] size from ReportQuery
Hi Blake,
Mills, Blake S CTR 805 CSPTS/SCE wrote:
Hello,
I am trying to use a ReportQuery because I only need a limited amount
of the data from a certain table. Everything works great except the
Object[] size returned by the ReportQueryRsIterator changes depending
on if there are any null values.
I test this with latest from SVN (OJB_1_0_RELEASE branch) and can't
reproduce your problem.
Test result for QueryTest#testReportQueryNullFields
http://svn.apache.org/viewvc/db/ojb/branches/OJB_1_0_RELEASE/src/test/or
g/apache/ojb/broker/QueryTest.java?view=markup
Result_1: {null,testReportQueryNullFields_1159443495281,2}
Result_2: {Robert,testReportQueryNullFields_1159443495281,1}
Result_2: {null,testReportQueryNullFields_1159443495281,2}
As you can see null-fields are included in the result.
regards,
Armin
For example if want two column values from your ReportQuery and one of
them is null, then the returned Object[] size will only one, NOT two.
How do you know which of the two columns is represented in the
Object[]?
I would expect an Object[] with size two with null in the place of the
column that had no value. Am I missing something? Below is how I
setup the ReportQuery.
broker.beginTransaction();
Criteria criteria = new Criteria();
criteria.addEqualTo(personAccountId, new
Integer(person.getId()));
ReportQueryByCriteria reportQuery =
QueryFactory.newReportQuery(TaskView.class, criteria);
String[] columns = new String[] {warningThreshold,
notApplicable, dueDate, doneDate};
reportQuery.setAttributes(columns);
Iterator iterator =
broker.getReportQueryIteratorByQuery(reportQuery);
Thanks for the help,
Blake
-
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]