Sorry I may have not made it clear, but the point of this exercise was not to produce data rows, but to uncover and debug the differences between MySQL and DB2. So could you print out the data rows (like you did below) for BOTH databases and check the differences.
More specifically I am trying to determine whether you need to use 'setColumnNamesCapitalization' per http://cayenne.apache.org/doc30/advanced-sqltemplate.html Andrus On May 13, 2011, at 4:21 PM, Andrew Willerding wrote: > That worked to retrieve a DataRow object. The data is there now. Is there > some way to convert this now into a usable cayenne data object without > pulling the columns out of the HashMap one column at a time? Or is there an > underlying bug that is at the root why this is works for MySQL but not for > DB2 V7? > > 2011-05-13 08:43:45,595 [http-8080-1] 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-13 08:43:45,796 [http-8080-1] INFO > org.apache.cayenne.access.QueryLogge > r - === returned 10 rows. - took 201 ms. > 2011-05-13 08:43:45,796 [http-8080-1] INFO > org.apache.cayenne.access.QueryLogge > r - +++ transaction committed. > SurveyResultDetails > item=org.apache.cayenne.DataRow@1533c8[values={SURVEY_DTS=Su > n Apr 10 14:53:17 EDT 2011, REC_MSG=101453001, RESULT=0, QUESTION=12, ID=50, > NOT > E=null, CALLER_ID=5001110410145147, LANG=EN, SURVEY_ID=1}, > version=-922337203685 > 4775804, replaces=-9223372036854775808] > SurveyResultDetails > item=org.apache.cayenne.DataRow@1faa614[values={SURVEY_DTS=S > un Apr 10 15:17:11 EDT 2011, REC_MSG=101517001, RESULT=0, QUESTION=12, ID=60, > NO > TE=null, CALLER_ID=5001110410151543, LANG=EN, SURVEY_ID=1}, > version=-92233720368 > 54775803, replaces=-9223372036854775808] > > On 05/13/2011 06:48 AM, Andrus Adamchik wrote: >> I can suggest a test: >> >> select.setFetchingDataRows(true) >> >> and then print and compare the results between 2 DB's. >> >> Andrus >> > >
