Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Message-ID: <9211.209.212.102.102.1342084481.squirrel@webmail.xsinet.co.za>
Date: Thu, 12 Jul 2012 11:14:41 +0200 (SAST)
Subject: Date cast exception due to relationship
From: dollj@xsinet.co.za
To: user@cayenne.apache.org
User-Agent: SquirrelMail/1.4.11
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Importance: Normal

I have an Activity table and associated class containing a sql.Date field.

I also have a Results table (also with a date field) and associated
ActivityResults class.

At this point the model works without error.

However when i create a 1-M relationship, using Cayenne modeler, in
Activity to ActivityResults (partly based on the date fields) then i get
an util.Date to sql.Date cast exception in the _Activity class here:

return (Date)readProperty("activityDate");

It seems as though the relationship is causing Cayenne to switch
internally from creating a sql.Date to a util.Date ?  This is then
returned by readProperty() and causes the cast exception because _Activity
is expecting a sql.Date

This behavior occurs in 3.0.2 and in 3.1b1