org.springframework.jdbc.UncategorizedSQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 1) Start Opal 2) Export a ValueTable that has many attributes (ex: Participants) to a JdbcDatasource: export -d sql-datasource opal-data.Participants If your ValueTable has enough attributes, you should get this error: org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024); nested exception is java.sql.SQLException: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:349) at org.obiba.magma.datasource.jdbc.JdbcDatasource.doWithDatabase(JdbcDatasource.java:163) at org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcVariableWriter.close(JdbcValueTableWriter.java:125) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:130) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:117) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:69) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:51) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy40.exportTablesToDatasource(Unknown Source) at org.obiba.opal.cli.client.command.ExportCommand.execute(ExportCommand.java:31) at org.obiba.opal.cli.client.OpalConsole.prompt(OpalConsole.java:136) at org.obiba.opal.cli.client.OpalConsole.<init>(OpalConsole.java:103) at org.obiba.opal.cli.client.OpalConsole.main(OpalConsole.java:185) Caused by: java.sql.SQLException: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024) at org.obiba.magma.datasource.jdbc.JdbcDatasource$2.doInConnection(JdbcDatasource.java:169) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342) ... 21 more Caused by: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.change.AbstractChange.execute(AbstractChange.java:247) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) at org.obiba.magma.datasource.jdbc.JdbcDatasource$ChangeDatabaseCallback.doInDatabase(JdbcDatasource.java:211) at org.obiba.magma.datasource.jdbc.JdbcDatasource$2.doInConnection(JdbcDatasource.java:167) ... 22 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2637) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2566) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:625) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 27 more
    via by Martin Boulanger,
  • 1) Start Opal 2) Export a ValueTable that has many attributes (ex: Participants) to a JdbcDatasource: export -d sql-datasource opal-data.Participants If your ValueTable has enough attributes, you should get this error: org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024); nested exception is java.sql.SQLException: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:349) at org.obiba.magma.datasource.jdbc.JdbcDatasource.doWithDatabase(JdbcDatasource.java:163) at org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcVariableWriter.close(JdbcValueTableWriter.java:125) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:130) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:117) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:69) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:51) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy40.exportTablesToDatasource(Unknown Source) at org.obiba.opal.cli.client.command.ExportCommand.execute(ExportCommand.java:31) at org.obiba.opal.cli.client.OpalConsole.prompt(OpalConsole.java:136) at org.obiba.opal.cli.client.OpalConsole.<init>(OpalConsole.java:103) at org.obiba.opal.cli.client.OpalConsole.main(OpalConsole.java:185) Caused by: java.sql.SQLException: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024) at org.obiba.magma.datasource.jdbc.JdbcDatasource$2.doInConnection(JdbcDatasource.java:169) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342) ... 21 more Caused by: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.change.AbstractChange.execute(AbstractChange.java:247) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) at org.obiba.magma.datasource.jdbc.JdbcDatasource$ChangeDatabaseCallback.doInDatabase(JdbcDatasource.java:211) at org.obiba.magma.datasource.jdbc.JdbcDatasource$2.doInConnection(JdbcDatasource.java:167) ... 22 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2637) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2566) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:625) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 27 more
    via by Martin Boulanger,
  • Connecting the JDBC datasource on a MySQL instance in the integration app fails with the following error. The problem is caused because the SQL type of the column is "VARCHAR". In MySQL, these columns must have a size specified (ie: VARCHAR(255) ). Stacktrace: Exception in thread "main" org.obiba.magma.MagmaRuntimeException: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `integration_app` ADD `barcode` VARCHAR at org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcVariableWriter.close(JdbcValueTableWriter.java:140) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:129) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:116) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:106) at org.obiba.magma.integration.IntegrationApp.main(IntegrationApp.java:152) Caused by: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `integration_app` ADD `barcode` VARCHAR at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.change.AbstractChange.execute(AbstractChange.java:247) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) at org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcVariableWriter.close(JdbcValueTableWriter.java:137) ... 4 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 8 more
    via by Philippe Laflamme,
  • Connecting the JDBC datasource on a MySQL instance in the integration app fails with the following error. The problem is caused because the SQL type of the column is "VARCHAR". In MySQL, these columns must have a size specified (ie: VARCHAR(255) ). Stacktrace: Exception in thread "main" org.obiba.magma.MagmaRuntimeException: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `integration_app` ADD `barcode` VARCHAR at org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcVariableWriter.close(JdbcValueTableWriter.java:140) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:129) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:116) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:106) at org.obiba.magma.integration.IntegrationApp.main(IntegrationApp.java:152) Caused by: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `integration_app` ADD `barcode` VARCHAR at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.change.AbstractChange.execute(AbstractChange.java:247) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) at org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcVariableWriter.close(JdbcValueTableWriter.java:137) ... 4 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 8 more
    via by Philippe Laflamme,
  • MySQL database problem | Mango Automation
    via by Unknown author,
  • Unable to connect to MySQL database at startup
    via by Unknown author,
    • org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024); nested exception is java.sql.SQLException: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:349) at org.obiba.magma.datasource.jdbc.JdbcDatasource.doWithDatabase(JdbcDatasource.java:163) at org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcVariableWriter.close(JdbcValueTableWriter.java:125) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:130) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:117) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:69) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:51) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy40.exportTablesToDatasource(Unknown Source) at org.obiba.opal.cli.client.command.ExportCommand.execute(ExportCommand.java:31) at org.obiba.opal.cli.client.OpalConsole.prompt(OpalConsole.java:136) at org.obiba.opal.cli.client.OpalConsole.<init>(OpalConsole.java:103) at org.obiba.opal.cli.client.OpalConsole.main(OpalConsole.java:185) Caused by: java.sql.SQLException: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024) at org.obiba.magma.datasource.jdbc.JdbcDatasource$2.doInConnection(JdbcDatasource.java:169) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342) ... 21 more Caused by: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `Participants` ADD `BoneDensity_OUTPUT_FOOT_SCANNED` VARCHAR(1024) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.change.AbstractChange.execute(AbstractChange.java:247) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) at org.obiba.magma.datasource.jdbc.JdbcDatasource$ChangeDatabaseCallback.doInDatabase(JdbcDatasource.java:211) at org.obiba.magma.datasource.jdbc.JdbcDatasource$2.doInConnection(JdbcDatasource.java:167) ... 22 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2637) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2566) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:625) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 27 more

    Users with the same issue

    slash
    7 times, last one,
    Casper
    88 times, last one,
    tvrmsmith
    7 times, last one,
    Hronom
    3 times, last one,
    Kialandei
    13 times, last one,
    115 more bugmates