But when I read the CLOB again I get the old value, String has not been appended.
This is very basic JDBC stuff and it should work with all DBs, at lead with Oracle it works, so has someone an idea of what is wring with MySQL?
Wendy Gibbons wrote:when you say read again, do you mean read from the database, or just using java to stream over that variable again?
If it is from the database you don't show us the insert/update statement, and then the next select statement where you get the clob again.
I mean read again from DB, by making a new PreparedStatement and selecting the very same CLOB again, so there was NO insert/update statement at all.
I found my issue, but I had to use a decompiler to find what was wrong.
So I have read a CLOB the "normal way" with a select and a ResultSet, and I make: