Re: [h2] MVMap rollback

2017-03-03 Thread Roland Lohner
Thank you, Thomas. On Friday, March 3, 2017 at 9:22:51 PM UTC+1, Thomas Mueller Graf wrote: > > Hi, > > No, I'm sorry, there is no way. But you can open the map for a specific > version, and copy the data to a new map. > > Regards, > Thomas > > > On Fri, Mar 3, 2017 at 8:11 AM, Roland Lohner >

Re: [h2] MVMap rollback

2017-03-03 Thread Thomas Mueller Graf
Hi, No, I'm sorry, there is no way. But you can open the map for a specific version, and copy the data to a new map. Regards, Thomas On Fri, Mar 3, 2017 at 8:11 AM, Roland Lohner wrote: > Hi, > > I have to rollback a given MVMap to an earlier version. > Other maps in the store must NOT be rol

Re: [h2] High processor usage when no transactions taking place - revisited

2017-03-03 Thread Thomas Mueller Graf
Hi, It should not keep running. Does it happen with the latest version of H2? Could you send me the database file (compressed)? Regards, Thomas On Thu, Mar 2, 2017 at 1:35 PM, andreas fw wrote: > Hi Thomas, > thanks for the answer. But why does it keep running? That thread has been > running c

Re: [h2] BUG? odd behavior involving automatic foreign key indices and multiple-column primary keys

2017-03-03 Thread Thomas Mueller Graf
Hi, Yes, H2 creates unique indexes for constraints. If you have a complete, standalone, simple reproducible test case, we can have a look. But please remove all columns that are not needed to analyze this. Regards, Thomas On Fri, Mar 3, 2017 at 8:58 PM, Laird Nelson wrote: > I have a table wi

[h2] BUG? odd behavior involving automatic foreign key indices and multiple-column primary keys

2017-03-03 Thread Laird Nelson
I have a table with multiple columns in its primary key. CREATE TABLE GAV ( GROUP_ID VARCHAR(255) NOT NULL, ARTIFACT_ID VARCHAR(255) NOT NULL, VERSION_ID VARCHAR(20) NOT NULL, CLASSIFIER VARCHAR(20) DEFAULT 'jar' NOT NULL PRIMARY KEY (GROUP_ID, ARTIFACT_ID, VERSION_ID, CLASSIFIER) ) I'

[h2] How to disconnect clustering in H2?

2017-03-03 Thread Hyunsoo Ryu
Thanks for information about h2 db in this group. I have some problems in using my h2 clustering mode. So, I want to remove clustering between 2 server nodes. How could I remove it. but, I still want to keep my data in this db, after clustering removed. Please, Help me.!!! -- You received th