cayenne-user mailing list archives

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


Mime
View raw message