Here ya go. I've had this happen before where MySQL will have
something like .33333333333 but castor would get confused on it. Have
always taken care of it on my side by formating/truncating/whatever
the data before it gets put in.
[XML]
...
<field name="weirPlateHeight" type="double">
<sql name="weirPlateHeight"/>
</field>
...
[SQL]
CREATE TABLE `prjdimsfcopenings` (
`id` int(11) NOT NULL auto_increment,
`systemId` int(11) NOT NULL default '0',
....
`weirOffset` double NOT NULL default '0',
`weirSump` double NOT NULL default '0',
`weirPlateHeight` double NOT NULL default '0',
...
PRIMARY KEY (`id`),
KEY `systemId` (`systemId`)
)
[JAVA]
private double weirPlateHeight;
public double getWeirPlateHeight() {
return weirPlateHeight;
}
public void setWeirPlateHeight(double weirPlateHeight) {
this.weirPlateHeight = weirPlateHeight;
}
Thats it. Normally, like I said, I can take care of this issue with in
my own stuff through formatting. But I'm confused because doing a
normal SELECT from anywhere (command line client, php, where ever) it
shows as 2.22 in the database. =\
-Nick
On 5/26/05, Bruce Snyder <[EMAIL PROTECTED]> wrote:
> On 5/26/05, Nick Stuart <[EMAIL PROTECTED]> wrote:
>
> > Ok I'm stumped. Here is the end part of the UPDATE statement coming
> > from the logs.
> >
> > .. weirPlateHeight=2.219999999999998 WHERE id=6 AND
> > systemId=1257...weirPlateHeight=2.22
> >
> > Why is the first weirPlateHeight have a million digits on it? Got me!
> > The database shows 2.22, my field itself in the GUI part of the
> > program shows 2.2, but apparently when it gets put into the cache it
> > gets set to 2.21999999.
> >
> > This is all happening from a straight load and then save. =\ I
> > thought it might be a JDBC issue, updated to the latest
> > mysql-connector, no go. Tried this with both 0.9.6 and 0.9.7M1 and it
> > does the same thing.
> >
> > Where could I hunt this down next?
>
> Nick,
>
> Please post the following for further analysis:
>
> 1) the XML mapping for the weirPlateHeight field
> 2) the DDL for the table where the weirPlateHeight column resides
> 3) the Java definition for the weirPlateHeight field
>
> I hazard a guess that the conversion being done by Castor is not correct.
>
> Bruce
> --
> perl -e 'print unpack("u30","D0G)[EMAIL
> PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
> );'
>
> The Castor Project
> http://www.castor.org/
>
> Apache Geronimo
> http://geronimo.apache.org/
>
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
