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.
