org.obiba.magma.MagmaRuntimeException

liquibase.exception.JDBCException: Error executing SQL INSERT INTO `integration_app` (`lastName`, `interview_startDate`, `Action_stage`, `isFemale`, `gender`, `barcode`, `interviewYear`, `fullName`, `firstName`, `entity_id`, `isMale`) VALUES ('Laflamme', '2009-10-28', '[BloodPressure, Questionnaire, Samples]', 'false', 'Male', '12345', '2009', 'Philippe Laflamme', 'Philippe', '12345', 'true')

Samebug tips1

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web1666

  • via Unknown by Philippe Laflamme,
  • via Unknown by Philippe Laflamme,
  • via Unknown by Unknown author,
  • Stack trace

    • org.obiba.magma.MagmaRuntimeException: liquibase.exception.JDBCException: Error executing SQL INSERT INTO `integration_app` (`lastName`, `interview_startDate`, `Action_stage`, `isFemale`, `gender`, `barcode`, `interviewYear`, `fullName`, `firstName`, `entity_id`, `isMale`) VALUES ('Laflamme', '2009-10-28', '[BloodPressure, Questionnaire, Samples]', 'false', 'Male', '12345', '2009', 'Philippe Laflamme', 'Philippe', '12345', 'true') at org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcValueSetWriter.close(JdbcValueTableWriter.java:305) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:139) 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 INSERT INTO `integration_app` (`lastName`, `interview_startDate`, `Action_stage`, `isFemale`, `gender`, `barcode`, `interviewYear`, `fullName`, `firstName`, `entity_id`, `isMale`) VALUES ('Laflamme', '2009-10-28', '[BloodPressure, Questionnaire, Samples]', 'false', 'Male', '12345', '2009', 'Philippe Laflamme', 'Philippe', '12345', 'true') 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$JdbcValueSetWriter.close(JdbcValueTableWriter.java:303) ... 4 more Caused by: java.sql.SQLException: Incorrect integer value: 'false' for column 'isFemale' at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 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

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    aidoanaidoan
    5 times, last one
    slashslash
    4 times, last one
    tvrmsmithtvrmsmith
    4 times, last one
    Unknown visitor
    Unknown visitorOnce,
    MethodCallMethodCall
    Once,
    148 more bugmates