On 3/13/06, Thomas J. Taylor <[EMAIL PROTECTED]> wrote: > I tried running DDLUtils to convert one of our existing MySQL databases to > Derby. It got to the point of importing data from the data.xml file but > failed due to an 'Data Truncation' Exception converting from LONG VARCHAR to > VARCHAR(32700).
Seems you try to insert more than 32700 bytes of data. Don't know about Derby, but in MySQL you can switch the JDBC driver to warn instead of throwing an exception by adding "jdbcCompliantTruncation=false" to the connection URL. cheers, Tom
