db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak" <tom...@gmail.com>
Subject Re: Using DdlUtils to Migrate Databases to Derby (MySQL-to-Derby)
Date Sun, 12 Mar 2006 23:32:15 GMT
On 3/13/06, Thomas J. Taylor <thomas.taylor@itqa.miami.edu> 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

Mime
View raw message