topic Re: Inserting Floats or Doubles into a MySQL Table in Talend Studio

Inserting Floats or Doubles into a MySQL Table

Anonymous — Sat, 16 Nov 2024 14:19:32 GMT

I'm trying to take a numerical value from an xml file and put it into a MySQL table. When I try and set the schemas (both for retrieving the value from the xml file and for putting it into the table) to use Float or Double values i get the error message:
Exception in component tMysqlOutput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Display width out of range for column 'Price' (max = 255)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
... etc.
and the price is definitely not that large a number.
Any ideas on what i'm doing wrong?

Re: Inserting Floats or Doubles into a MySQL Table

Anonymous — Thu, 26 Jun 2008 14:16:33 GMT

I'm having the same problem. I'm getting the same error when trying to read a price value from an XML file and insert it into MySQL as a float or double. Anyone know what's going on here?

Re: Inserting Floats or Doubles into a MySQL Table

Anonymous — Thu, 26 Jun 2008 14:46:10 GMT

Just define the length of your float (or double) by editing your MySQL Output Schema.

Re: Inserting Floats or Doubles into a MySQL Table

Anonymous — Thu, 26 Jun 2008 15:32:13 GMT

That worked - thanks for the tip.

Re: Inserting Floats or Doubles into a MySQL Table

_AnonymousUser — Sat, 05 Dec 2015 16:45:56 GMT

Damien, please, how to edit the length of the float ? didn't find where this parameter is...