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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
