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.

Reply via email to