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 converting "UUID
to BOOLEAN"; SQL statement:
UPDATE MARKET_GLOBAL SET BUYER =? AND BUYER_NAME =? WHERE ID =? [22018-200]"
I have confirmed the variable being passed into the UUID is not null, and
that the field type is declared as UUID.
To make things more interesting, i created a new method ("test()") and
replicated the code, then passed the same variables via this method and it
worked. i then called the failing method within the same run instance and
it failed.
Here is my github with the class in
reference:
https://github.com/Caltinor/GnCLib/blob/main/src/dicemc/gnclib/trade/dbref/H2Impl.java
I am calling executeTransaction which is failing on the first if (it works
fine if the count does not equal the entry stock). another thing worth
noting is i am calling getMarketList(...) before i call
executeTransaction(...).
Any help is greatly appreciated.
-Caltinor
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/bcb64688-bc9b-4c79-8841-0725fe2191b6n%40googlegroups.com.
