Hi, Maybe you forgot to set "mode=mysql" in the database URL?
According to the error code, you are using version 1.3.172 this morning. Maybe the "on duplicate key update" syntax was not yet supported in this (relatively old) version? Regards, Thomas On Thu, Aug 13, 2015 at 6:40 PM, gheorghi evgheniev <[email protected]> wrote: > Hi, > We are using H2DB in MySQL mode as in memory DB to run unit tests on it. > All was good, up until this morning when our builds started to fail for no > reason.(No changes were done) The fails are related to SQL queries which > again, used to work just fine up until this morning. > So i was wandering if there was anything pushed out on a public repos that > could have caused this change in behavior? Cause I can not explain this > behavior otherwise. > Thanks > > > > 13 Aug 12:31:31:259 INFO () Rolled back transaction for test context > [DefaultTestContext@7c46b832 testClass = IConceptValueMapperTest, > testInstance = > com.app.entrd.mc.nes.persistence.mappers.IConceptValueMapperTest@6e71a5c, > te > stMethod = > testDeleteConceptValuesWhenConceptDeleted@IConceptValueMapperTest, > testException = org.springframework.jdbc.BadSqlGrammarException: > ### Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Syntax > error in SQL statement "INSERT INTO concept_values (project_id, concept_id, > value, literal) > VALUES (?, ?, ?, ? ) > ON[*] DUPLICATE KEY UPDATE value = ?"; SQL statement: > INSERT INTO concept_values (project_id, concept_id, value, literal) > VALUES (?, ?, ?, ? ) > ON DUPLICATE KEY UPDATE value = ? [42000-172] > ### SQL: INSERT INTO concept_values (project_id, concept_id, value, > literal) VALUES (?, ?, ?, ? ) ON DUPLICATE KEY UPDATE value > = ? > ### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement > "INSERT INTO concept_values (project_id, concept_id, value, literal) > VALUES (?, ?, ?, ? ) > ON[*] DUPLICATE KEY UPDATE value = ?"; SQL statement: > INSERT INTO concept_values (project_id, concept_id, value, literal) > VALUES (?, ?, ?, ? ) > ON DUPLICATE KEY UPDATE value = ? [42000-172] > ; bad SQL grammar []; nested exception is org.h2.jdbc.JdbcSQLException: > Syntax error in SQL statement "INSERT INTO concept_values (project_id, > concept_id, value, literal) > VALUES (?, ?, ?, ? ) > ON[*] DUPLICATE KEY UPDATE value = ?"; SQL statement: > INSERT INTO concept_values (project_id, concept_id, value, literal) > VALUES (?, ?, ?, ? ) > ON DUPLICATE KEY UPDATE value = ? [42000-172], > mergedContextConfiguration = [MergedContextConfiguration@2e73918e > testClass = IConceptValueMapperTest, locations = > '{classpath:beandef/beans-database-test.xml}', classes = '{} > ', contextInitializerClasses = '[]', activeProfiles = '{}', > propertySourceLocations = '{}', propertySourceProperties = '{}', > contextLoader = > 'org.springframework.test.context.support.DelegatingSmartContextLoader', > parent = [null]] > ]. > > > Not hat i'm also getting error related to this queries: > ALTER TABLE `projects` CHANGE `creationDate` `creation_date` TIMESTAMP; > > which i solved by changing it to: > ALTER TABLE `projects` CHANGE COLUMN `creationDate` `creation_date` > TIMESTAMP; > > But again this doesn't explain why it used to work up until this morning > > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
