Re: [h2] deadlock with clob data types?

2015-06-14 Thread Noel Grandin
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 a...@cs.miami.edu wrote: Hi, I am using H2 to store text as clobs. The operations go like this: The clobs are read into

Re: [h2] deadlock with clob data types?

2015-06-14 Thread Adam McMahon
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

Re: [h2] deadlock with clob data types?

2015-06-14 Thread Adam McMahon
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

Re: [h2] deadlock with clob data types?

2015-06-14 Thread Noel Grandin
Updating to 1.4 is a drop in and go replacement as long as you turn off mvstore in the url On Sun, 14 Jun 2015 at 19:09, Adam McMahon a...@cs.miami.edu wrote: I guess another route would be to change the datatype to varchar. Is this possible? Is it safe? -Adam On Sunday, June 14, 2015

[h2] deadlock with clob data types?

2015-06-13 Thread Adam McMahon
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