Thanks Darius, Mysql query was very long and I reduced to approximately 57,000 characters and and it is now working.
Erick On Fri, Apr 6, 2012 at 11:47 PM, Darius Jazayeri <[email protected]>wrote: > 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 > > > ------------------------------ > 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]
