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?
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?
