Hi Erick, I believe the database column is a mysql "text" column (and it changes to "mediumtext" in OpenMRS 1.9).
How long *is* your sql? Do you have a very long description on the DSD, or lots of parameters? -Darius On Fri, Apr 6, 2012 at 12:59 PM, Erick Mugoma <[email protected]>wrote: > Hi, > Am trying to create an SQL Data set definition. The following error occurs > when I try to save. > Caused by: java.sql.BatchUpdateException: Data truncation: Data too long > for column 'serialized_data' at row 1 > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2016) > at > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1452) > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) > at > org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) > > How long should the sql query be? > > Thanks > > Erick > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from > OpenMRS Developers' mailing list _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
