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
