Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-Id: <54E4CAB3-D26F-41D6-89EE-572248D19CE2@objectstyle.org>
From: Andrus Adamchik <andrus@objectstyle.org>
To: user@cayenne.apache.org
In-Reply-To: <15951944.post@talk.nabble.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v919.2)
Subject: Re: Wrong data type for source attribute of a relationship?
Date: Tue, 11 Mar 2008 00:17:12 +0200
References: <15951944.post@talk.nabble.com>

We stopped supporting FireBird some time back due to the lack of  
qualified volunteers, so I don't remember all the issues that we had  
with it. But still this seems weird... Just to doublecheck, what Java  
and DB type you entered for the object attribute and the corresponding  
column in the Modeler?

Also is this column an FK? Meaningful FK's are generally a bad idea.  
I'd recommend you get the value via a related object instead.

Andrus

On Mar 10, 2008, at 9:30 PM, Walter Haas wrote:
> Hello,
>
> after creating a relationship which uses a column of the mapped type  
> double
> (decimal in db) as source field, the type cast of the readProperty  
> method
> throws an exception. It seems that the value is stored as BigDecimal  
> if the
> field is used in a relationship!?
>
> This happens in Cayenne 3.02M and 3.03M (used with JayBird/FireBird).
> Is this intendet behaviour? Any way to prevent this from happening?
>