I guess another route would be to change the datatype to varchar. Is this possible? Is it safe?
-Adam On Sunday, June 14, 2015 at 12:46:55 PM UTC-4, Adam McMahon wrote: > > Noel, > > Thanks for the suggestion. When you say latest version, do you mean > latest stable version, or the latest build? > > Would the upgrade process be to simple replace the jar and restart the > DB? Or is it best to restore a fresh DB from sql script? > > -Adam > > On Sunday, June 14, 2015 at 2:54:40 AM UTC-4, Noel Grandin wrote: >> >> We have fixed a bunch of stuff around LOB'S since then. I suggest you >> update to the latest version but run with mvstore disabled >> On Sun, 14 Jun 2015 at 02:31, Adam McMahon <[email protected]> wrote: >> >>> Hi, >>> >>> I am using H2 to store text as clobs. >>> The operations go like this: >>> >>> The clobs are read into a String from the DB >>> The String is transformed into a json ojbect >>> the json object is modified >>> the object is transformed into a json string and saved back into H2 as a >>> clob >>> >>> Multiple threads are performing the above operations at the same time. >>> >>> I am running into thread dead locks when doing this. If I synchronize >>> around my methods which Select and Execute into the database, I do not run >>> into the deadlocks. Thus, I am avoiding the problem by making sure that >>> all my calls to H2 are synchronized in my code, which makes me wonder if >>> there is a synchronization problem somewhere in H2. Are there any known >>> deadlock problems in h2 with regard to clobs or the such. >>> >>> H2 version: {name=info.VERSION, value=1.3.176 (2014-04-05)} >>> >>> Thanks, >>> -Adam >>> >>> -- >>> 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 post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
