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
Hello Everyone,
I am having a rather strange issue with an update statement. I am using a
preparedstatement to execute and update statement and passing 3 parameters
(UUID, String, int). when I execute the update i get this error
"org.h2.jdbc.JdbcSQLDataException: Data conversion error