cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Willerding <awillerd...@callistacti.com>
Subject DB2 V7 strange bug I think
Date Thu, 12 May 2011 15:13:23 GMT
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