Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1084)
Subject: Re: DB2 V7 strange bug I think
From: Andrus Adamchik <andrus@objectstyle.org>
In-Reply-To: <4DCD3070.4000709@callistacti.com>
Date: Fri, 13 May 2011 17:14:20 +0300
Content-Transfer-Encoding: quoted-printable
Message-Id: <38B6A390-3741-4166-BB7C-081A4AE3CBC1@objectstyle.org>
References: <4DCBF913.6000602@callistacti.com>
 <AF624BD6-DED4-42ED-BC2E-02F2BEBE4F5B@objectstyle.org>
 <4DCD3070.4000709@callistacti.com>
To: user@cayenne.apache.org

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.=20

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?
>=20
> 2011-05-13 08:43:45,595 [http-8080-1] INFO  =
org.apache.cayenne.access.QueryLogge
> r - Select * from SurveyResultDetails where survey_id =3D 1 and =
question in (Selec
> t question from SurveyQuestions, SurveyQuestionTypes where =
SurveyQuestionTypes.i
> d =3D 5 and SurveyQuestions.question_type_id =3D 5) order by result, =
survey_dts
> 2011-05-13 08:43:45,796 [http-8080-1] INFO  =
org.apache.cayenne.access.QueryLogge
> r - =3D=3D=3D 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=3Dorg.apache.cayenne.DataRow@1533c8[values=3D{SURVEY_DTS=3DSu
> n Apr 10 14:53:17 EDT 2011, REC_MSG=3D101453001, RESULT=3D0, =
QUESTION=3D12, ID=3D50, NOT
> E=3Dnull, CALLER_ID=3D5001110410145147, LANG=3DEN, SURVEY_ID=3D1}, =
version=3D-922337203685
> 4775804, replaces=3D-9223372036854775808]
> SurveyResultDetails =
item=3Dorg.apache.cayenne.DataRow@1faa614[values=3D{SURVEY_DTS=3DS
> un Apr 10 15:17:11 EDT 2011, REC_MSG=3D101517001, RESULT=3D0, =
QUESTION=3D12, ID=3D60, NO
> TE=3Dnull, CALLER_ID=3D5001110410151543, LANG=3DEN, SURVEY_ID=3D1}, =
version=3D-92233720368
> 54775803, replaces=3D-9223372036854775808]
>=20
> On 05/13/2011 06:48 AM, Andrus Adamchik wrote:
>> I can suggest a test:
>>=20
>> select.setFetchingDataRows(true)
>>=20
>> and then print and compare the results between 2 DB's.
>>=20
>> Andrus
>>=20
>=20
>=20