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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/bcb64688-bc9b-4c79-8841-0725fe2191b6n%40googlegroups.com.