For a FLOAT type field, the correct
precision must be defined. By default, MySQL uses four bytes to store
a FLOAT type that does not have an explicit precision
definition. For example, this causes a number such as 12345.67890123
to be rounded off to 12345.7 during an INSERT.
To prevent this, specify FLOAT(10,2) in the DDL
file, which forces the database to use an eight-byte double-precision
column. For more information, see http://dev.mysql.com/doc/mysql/en/numeric-types.html.

MySQL always starts a new connection when autoCommit==true is set. This ensures that each SQL statement forms a single
transaction on its own. If you try to rollback or commit an SQL statement,
you get an error message.