MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:February 18 2005 10:13am
Subject:Re: Problem with SUM and DECIMAL field
View as plain text  
Hell.

I think you should read comments at:
  http://bugs.mysql.com/bug.php?id=1388

They are related to the ODBC connector, but may be it will 
help you to solve problems with Connector/J.




LAFONTAINE Julien - LYO <julien.lafontaine@stripped> wrote:
> Hi everyone,
> 
> I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9.
> 
> Now I have a problem when using the SUM operator on DECIMAL field.
> 
> The value returned by the SUM operator when used with DECIMAL field has a
> coma (,) as decimal separator while it used to be have a dot (.) . If I
> query my table to display the DECIMAL fields (SELECT * FROM ...)  I get a
> dot as decimal separator as expected.
> 
> This doesn't look like a big issue but it prevents Connector/J from
> retieving the data properly. Connector/J can't parse the value of the field
> as it's expecting a dot as decimal separator.
> 
> Here is the stack trace :
> 
> java.sql.SQLException: Bad format for BigDecimal '12660,95' in column 1( .
> () . SUM(AMFTPF)()).
>            at com.mysql.jdbc.ResultSet.getBigDecimal(ResultSet.java:493)
> 
> 
> 
> I'm using Connector/J 3.0.16.
> 
> One last thing : this seems to happen only on AIX. I have tried on Linux and
> Windows XP and everything works as expected.
> 
> Is there something wrong with some of my database parameters or is this a
> bug ?
> 
> Please let me know if someone is interested by a testcase.
> 
> 
> Reagrds,
> 
> Julien LAFONTAINE
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Problem with SUM and DECIMAL fieldLAFONTAINE Julien - LYO17 Feb
  • Re: Problem with SUM and DECIMAL fieldGleb Paharenko21 Feb
  • Re: Problem with SUM and DECIMAL fieldMark Matthews21 Feb
RE: Problem with SUM and DECIMAL fieldLAFONTAINE Julien - LYO24 Feb
  • Re: Problem with SUM and DECIMAL fieldMark Matthews24 Feb