On 2017/12/07 1:37 PM, Silvio wrote:
Does that mean that you allow reading the resultset AFTER the transaction completes? I was assuming the transaction
Of course. Under most conditions (ie. with setAutoCommit==true), the transaction is complete and closed before the
ResultSet is even returned to the client.
This is how JDBC works on most databases.
So most people tend to call getBlob() and expect it to work, even though they
are now fetching data outside a transaction.
And they expect it to work even if something else deletes the LOB while they
are reading it - outside the transaction :-(
So fixing this requires some work, and requires a fair amount of care on the part of people writing code to read LOBs
from H2.
--
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 post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.