exidnus
02/09/2020, 4:39 PMLessons.update(where = { Lessons.id eq lessonId }) {
with(SqlExpressionBuilder) {
it.update(column, column + "$entityId$ELEM_COLLECTION_SEPARATOR")
}
}
But it throws exception
Caused by: org.h2.jdbc.JdbcSQLFeatureNotSupportedException: Feature not supported: "VARCHAR +"; SQL statement:
UPDATE LESSONS SET CAME_STUDENTS=LESSONS.CAME_STUDENTS+? WHERE LESSONS.ID = ?
Exposed version 0.20.3.
Oh, sorry to bother, I understood, that I should just use SqlExpressionBuilder.concat(column, stringLiteral("$entityId$ELEM_COLLECTION_SEPARATOR"))tapac
02/10/2020, 11:17 AMconcat
function like:
it[column] = concat(column, Lessons.id, stringLiteral(ELEM_COLLECTION_SEPARATOR))