I can suggest a test:
select.setFetchingDataRows(true)
and then print and compare the results between 2 DB's.
Andrus
On May 12, 2011, at 6:13 PM, Andrew Willerding wrote:
> Help!
>
> I am at a loss to figure out how to get past this one. The same code works
> perfectly fine when I test it against a MySQL database. I tried using the
> line containing the DB2Adapter statement but it made no difference.
>
> I am running the following code:
>
> sqlQuery = "Select * from SurveyResultDetails where survey_id =
> " + surveyID + " and question in " +
> "(Select question from SurveyQuestions, SurveyQuestionTypes where
> SurveyQuestionTypes.id = 8 and SurveyQuestions.question_type_id = 8) " +
> "order by result,survey_dts";
>
> ObjectContext context = BaseContext.getThreadObjectContext();
> SQLTemplate select = new SQLTemplate(SurveyResultDetails.class,
> sqlQuery);
> // select.setTemplate(DB2Adapter.class.getName(), sqlQuery);
>
> List list = context.performQuery(select);
>
> for (Iterator it = list.iterator(); it.hasNext();) {
> SurveyResultDetails item = (SurveyResultDetails)it.next();
> System.out.println("SurveyResultDetails item=" + item);
> result.add(item);
> }
>
> The result of this is the following on DB2 V7:
>
> 2011-05-12 10:52:53,149 [http-8080-2] INFO
> org.apache.cayenne.access.QueryLogge
> r - Select * from SurveyResultDetails where survey_id = 1 and question in
> (Selec
> t question from SurveyQuestions, SurveyQuestionTypes where
> SurveyQuestionTypes.i
> d = 5 and SurveyQuestions.question_type_id = 5) order by result, survey_dts
> 2011-05-12 10:52:53,189 [http-8080-2] INFO
> org.apache.cayenne.access.QueryLogge
> r - === returned 10 rows. - took 40 ms.
> 2011-05-12 10:52:53,189 [http-8080-2] INFO
> org.apache.cayenne.access.QueryLogge
> r - +++ transaction committed.
> SurveyResultDetails item=null
> SurveyResultDetails item=null
> SurveyResultDetails item=null
> SurveyResultDetails item=null
> SurveyResultDetails item=null
> SurveyResultDetails item=null
> SurveyResultDetails item=null
> SurveyResultDetails item=null
> SurveyResultDetails item=null
> SurveyResultDetails item=null
>
> Here is the result on a MySQL data query (different data)
>
> 2011-05-12 10:42:58,200 [http-8084-2] INFO
> org.apache.cayenne.access.QueryLogger - Select * from SurveyResultDetails
> where survey_id = 1 and question in (Select question from SurveyQuestions,
> SurveyQuestionTypes where SurveyQuestionTypes.id = 5 and
> SurveyQuestions.question_type_id = 5) order by result, survey_dts
> 2011-05-12 10:42:58,208 [http-8084-2] INFO
> org.apache.cayenne.access.QueryLogger - === returned 3 rows. - took 8 ms.
> 2011-05-12 10:42:58,208 [http-8084-2] INFO
> org.apache.cayenne.access.QueryLogger - +++ transaction committed.
> SurveyResultDetails item={<ObjectId:SurveyResultDetails, id=50>; committed;
> [id=>50; result=>0; callerId=>5001110410145147; recMsg=>101453001;
> surveyDts=>Sun Apr 10 14:53:17 EDT 2011; question=>12; surveyId=>1; lang=>EN;
> note=>]}
> SurveyResultDetails item={<ObjectId:SurveyResultDetails, id=60>; committed;
> [id=>60; result=>0; callerId=>5001110410151543; recMsg=>101517001;
> surveyDts=>Sun Apr 10 15:17:11 EDT 2011; question=>12; surveyId=>1; lang=>EN;
> note=>]}
> SurveyResultDetails item={<ObjectId:SurveyResultDetails, id=88>; committed;
> [id=>88; result=>0; callerId=>5001110410161501; recMsg=>101616001;
> surveyDts=>Sun Apr 10 16:16:46 EDT 2011; question=>12; surveyId=>1; lang=>EN;
> note=>]}
>
>
> HELP!
>
> Andrew
>
>
>
