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')

JIRA | Philippe Laflamme | 7 years ago
  1. 0

    Inserting boolean values fail when connecting to a MySQL database: This is caused by the use of setValue(String) as opposed to setBooleanValue(). 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') Exception in thread "main" 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

    JIRA | 7 years ago | Philippe Laflamme
    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')
  2. 0

    Inserting boolean values fail when connecting to a MySQL database: This is caused by the use of setValue(String) as opposed to setBooleanValue(). 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') Exception in thread "main" 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

    JIRA | 7 years ago | Philippe Laflamme
    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')
  3. 0

    maintainDB.sh restore command crashes

    YouTrack | 3 years ago
    java.sql.SQLException: Incorrect key file for table 'test_info'; try to repair it
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error Upgrading from 2.5.13 to 3.1.9 MySQL

    symmetricds | 4 years ago | nickpadilla
    org.jumpmind.db.sql.SqlException: Can't create table 'goldrush.#sql-2840_64' (errno: 150)
  6. 0

    An error occured while creating symds tables using auto create command

    symmetricds | 4 years ago | aravindraaz
    java.sql.SQLException: Table storage engine for 'sym_node_host_channel_stats' doesn't have this option
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Incorrect integer value: 'false' for column 'isFemale' at row 1

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    StatementImpl.execute
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
    2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
    5. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
    6. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
    7. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
    9. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
    9 frames
  3. Commons DBCP
    DelegatingStatement.execute
    1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    1 frame
  4. liquibase.database.template
    JdbcTemplate.execute
    1. liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
    2. liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
    3. liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
    3 frames
  5. Liquibase Core
    AbstractChange.executeStatements
    1. liquibase.change.AbstractChange.execute(AbstractChange.java:247)
    2. liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
    2 frames
  6. org.obiba.magma
    IntegrationApp.main
    1. org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcValueSetWriter.close(JdbcValueTableWriter.java:303)
    2. org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:139)
    3. org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:116)
    4. org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:106)
    5. org.obiba.magma.integration.IntegrationApp.main(IntegrationApp.java:152)
    5 frames