I wanted to follow up on this. I did resolve the issue though the problem
was entirely caused by a novice mistake on my part. I used "AND" in the
SET portion of the update statement instead of ", ". so the assignments
were being treated like expressions and confusing the database. original
I am happy to try to create a standalone test case, however that might be
easier said than done.
As I pointed out, I replicated the code in another method, used the same
input variables, and the update statement worked. I do have another update
statement that assigns a UUID that I suspect
That smells like the kind of bug that H2 sometimes has with determining the
type of a parameter in a PreparedStatement.
Normally it can be worked around by using CAST around the ? so that H2
knows exactly what type to use there.
Possibly we could track down the bug if you can provide a