Re: Migrating from MS Access to MySQL
I'm guessing your tables contain float/singles/decimals which overflow the default limit reported by the JDBC driver.
Long stroy short, try disabling the "Enable Scrict Mode" option when installing the mySQL server.
When in strict mode, since the insert statement is a single transaction and there is an error in it, it roll back the entire table data.
Get more information about modes here:
http://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html
Subject
Written By
Posted
December 16, 2005 07:53PM
Re: Migrating from MS Access to MySQL
December 17, 2005 06:33AM
December 17, 2005 04:02PM
December 19, 2005 07:29AM
December 20, 2005 02:04PM
December 20, 2005 09:30PM
December 23, 2005 12:43AM
December 23, 2005 06:35AM
December 25, 2005 02:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.