Java Record List Upsert

[JoshDoug]

Is it possible to Upsert a list of Java Records?

E.g.

@SqlUpdate("""
               INSERT INTO example (join1_id, join2_id, content)
               VALUES <values>
               ON DUPLICATE KEY UPDATE content = :content
               """)
    int upsertExampleContentList(@BindMethodsList(value = "values", methodNames = {"join1Id", "join2Id", "content"}) List<Example> exampleContentList);

[JoshDoug]

I needed to wrap content in VALUES() and remove the colon:

@SqlUpdate("""
               INSERT INTO example (join1_id, join2_id, content)
               VALUES <values>
               ON DUPLICATE KEY UPDATE content = VALUES(content)
               """)
    int upsertExampleContentList(@BindMethodsList(value = "values", methodNames = {"join1Id", "join2Id", "content"}) List<Example> exampleContentList);