cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: DB2 V7 strange bug I think
Date Fri, 13 May 2011 10:48:36 GMT
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
> 
> 
> 


Mime
View raw message